Is AWS Aurora Global Database ACID compliant?

0

I am investigating setting up a global database cluster for an application that will be globally spread, across multiple regions (US, EU, AU). One piece of information I couldn't find is if Aurora Global Database is ACID compliant. I know the regional instances are.

Also, as you'd need to be writing on a single node, write forwarding would likely need to be enabled or some application logic programmed to select the writer node. Wouldn't this also add a large volume of latency (e.g. when writer instance is in us-east-1, and client is based in ap-southeast-2)?

질문됨 2년 전1505회 조회
3개 답변
0

Modern Database Infrastructure are build with ACID compliant . Aurora Global Database will be ACID compliant .. There could be some latency in milli Second because of network . But it has to be tested and analyzed before finalizing the solution

AWS
Gaurav
답변함 2년 전
0

As far as ACID properties are concerned , they are related to the DB Engines i.e. MySQL and PostgreSQL. Both of these are ACID compliant.

For the performance concerns, Aurora Global Database lets you easily scale database reads across the world and place your applications close to your users. Your applications enjoy quick data access regardless of the number and location of secondary regions, with typical cross-region replication latencies below 1 second.

There are some limitations for the global DBs as called out here

AWS
답변함 2년 전
0

If you need local write instead of cross-region access to Writer instance on primary region, and consider write forwarding, please check write forwarding document https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-write-forwarding.html, there are some limitation and consistency model. Before using write forwarding, I highly recommend to test application behaviour and compatibility/performance carefully.

AWS
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인