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

posta 2 anni fa1505 visualizzazioni
3 Risposte
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
con risposta 2 anni fa
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
con risposta 2 anni fa
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
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande