A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an 8XL-sized instance, and the read replicas are each XL-sized instances. Users report that database queries are returning stale data. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary. Which changes will reduce the lag? (Choose two.)

Topic #: - All AWS Certified Database - Specialty Questions

A. Deploy two additional read replicas matching the existing replica DB instance size.
B. Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas. Most Voted
C. Move the read replicas to the same Availability Zone as the primary DB instance.
D. Increase the instance size of the primary DB instance within the same instance class.
E. Increase the instance size of the read replicas to the same size and class as the primary DB instance. Most Voted

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Share this post

Join the Discussion