Aurora cross region replica replication time

[pskarthic]

A company is using an Amazon RDS for MySQL 5.6 with Multi-AZ deployment enabled and several web servers across two AWS Regions. The database is currently experiencing highly dynamic reads due to the growth of the company’s website. The Solutions Architect tried to test the read performance from the secondary AWS Region and noticed a notable slowdown on the SQL queries.

The correct answer is Migrate the existing database to Amazon Aurora and create a cross-region read replica.

Explanation given as, Aurora Cross region replicas will be having 1 seconds replication time.

But in AWS docs below is mentioned

“In a cross-Region scenario, there is more lag time between the source DB cluster and the read replica due to the longer network channels between AWS Regions.“

Link -> https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.CrossRegion.html

And I guess Aurora Serverless is the one which can achieve 1 sec replication time. Please correct me if I am wrong.

[pskarthic]

Is there any other information required from my side?

[Carlo-TutorialsDojo]

Hello pskarthic,

Thanks for your feedback.

I checked the documentation that you shared but I didn’t find any specific replication time.

Under the “Can I have cross-region replicas with Amazon Aurora” section of the Amazon Aurora FAQs, it says that a typical replication lag is under 1 second.

https://aws.amazon.com/rds/aurora/faqs/

Regards,

Carlo @ Tutorials Dojo

• This reply was modified 3 years, 8 months ago by  Carlo-TutorialsDojo.

[pskarthic]

I checked the FAQ, “typical latency of under a second” mentioned for Aurora Global database, but in Aurora Global database was not in the answer list. That is the reason I skipped it, should I consider general Aurora and Aurora Global database as one when choosing answers?

[Carlo-TutorialsDojo]

Hello pskarthic,

It depends on the given options. The Global database is just a feature of Amazon Aurora. If you observe, the options are mostly about general services (Elasticache, Amazon RDS), implying that it is evaluating your understanding of various services. If there’s an option to select Amazon Aurora vs Amazon Aurora Global Database, then the latter is the more correct answer.

Regards,
Carlo @ Tutorials Dojo

[pskarthic]

Thanks you very much, really helpful.