Find answers, ask questions, and connect with our
community around the world.

Home Forums AWS AWS Certified Solutions Architect Associate Aurora cross region replica replication time

  • Aurora cross region replica replication time

  • pskarthic

    Member
    August 9, 2021 at 2:12 pm

    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

    Member
    August 10, 2021 at 12:05 pm

    Is there any other information required from my side?

    • Carlo-TutorialsDojo

      Administrator
      August 10, 2021 at 11:41 pm

      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

      • pskarthic

        Member
        August 13, 2021 at 11:04 am

        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

          Administrator
          August 13, 2021 at 10:15 pm

          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

            Member
            August 13, 2021 at 11:00 pm

            Thanks you very much, really helpful.

Viewing 1 - 2 of 2 replies

Log in to reply.

Original Post
0 of 0 posts June 2018
Now