By using AWS re:Post, you agree to the Terms of Use

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)?

asked 6 months ago218 views
3 Answers
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

answered 6 months ago
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

answered 6 months ago
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.

answered 6 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions