PrepAway - Latest Free Exam Questions & Answers

Is creating a Read Replica of another Read Replica supp…

Is creating a Read Replica of another Read Replica supported?

PrepAway - Latest Free Exam Questions & Answers

A.
Only in certain regions

B.
Only with MSSQL based RDS

C.
Only for Oracle RDS types

D.
No

Explanation:
https://aws.amazon.com/rds/faqs/
Q: Can I create a Read Replica of another Read Replica?
Amazon RDS for MySQL: You can create a second-tier Read Replica from an existing firsttier Read Replica. By creating a second-tier Read Replica, you may be able to move some of
the replication load from the master database instance to a first-tier Read Replica. Please
note that a second-tier Read Replica may lag further behind the master because of additional
replication latency introduced as transactions are replicated from the master to the first tier
replica and then to the second-tier replica.
Amazon RDS for PostgreSQL: Read Replicas of Read Replicas are not currently supported.

3 Comments on “Is creating a Read Replica of another Read Replica supp…

  1. Sunny says:

    Q: Can I create a Read Replica of another Read Replica?

    Amazon Aurora, Amazon RDS for MySQL and MariaDB: You can create a second-tier Read Replica from an existing first-tier Read Replica. By creating a second-tier Read Replica, you may be able to move some of the replication load from the master database instance to a first-tier Read Replica. Please note that a second-tier Read Replica may lag further behind the master because of additional replication latency introduced as transactions are replicated from the master to the first tier replica and then to the second-tier replica.

    Amazon RDS for PostgreSQL: Read Replicas of Read Replicas are not currently supported.




    3



    0

Leave a Reply to Sunny Cancel reply

Your email address will not be published. Required fields are marked *