Cross-Region Replication with Amazon Aurora MySQL | AWS Certified SysOps Administrator

Setting Up Amazon Aurora MySQL Cross-Region Replica

Question

A start-up firm is using the Amazon Aurora MySQL database for its enterprise application.

Due to massive growth in different regions, they are looking for setting Read Replica in different regions to increase Read performance for users in different regions.

Which of the following should be considered for the Amazon Aurora MySQL cross Region replica?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Correct Answer: B.

To increase availability & enable users to enhance Read performance by reading data from the nearest Regions, Read Replicas can be created for the Amazon Aurora MySQL database.

Up to 15 Read Replicas can be created for both encrypted & unencrypted DB clusters in different AWS regions.

These cross-region Read Replicas can be created using the AWS Management Console, AWS CLI, or Amazon RDS API.

Option A is incorrect as Read Replicas can be created for both encrypted & unencrypted DB clusters in any AWS region.

Option C is incorrect as Amazon Aurora MySQL supports cross-region replica.

Option D is incorrect as you will need to manually create a cross-region Read Replica for the Amazon Aurora MySQL DB cluster.

Don't get confused between 5 cross-region DB clusters and 15 cross-region Read-Replica.

For more information refer below,

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

The correct answer is B: Up to 15 cross-region Read-Replica is supported for both encrypted & unencrypted DB clusters in any AWS region.

Amazon Aurora is a relational database engine developed by AWS that is fully compatible with MySQL and PostgreSQL. It is designed to be highly scalable, fault-tolerant, and performant. Amazon Aurora supports creating up to 15 cross-region replicas, which means you can create up to 15 copies of your database in different regions.

Read replicas are copies of your database that are used to offload read traffic from the primary database. By creating read replicas in different regions, you can improve the read performance for users located in those regions. This is because read traffic can be directed to the read replica in the same region as the user, which reduces latency and improves response time.

In Amazon Aurora, you can create cross-region replicas for both encrypted and unencrypted DB clusters. However, there are some limitations on the number of replicas you can create. You can create up to 15 replicas for each primary DB cluster, and these replicas can be located in any AWS region.

Option A is incorrect because it mentions that only unencrypted DB clusters support cross-region replicas, which is not true.

Option C is incorrect because Amazon Aurora does support cross-region replicas.

Option D is incorrect because Amazon Aurora does not automatically create cross-region replicas. You need to manually create replicas in different regions as per your requirement.