Is creating a Read Replica of another Read Replica supported?

Is creating a Read Replica of another Read Replica supported?

A.
Only in certain regions

B.
Only with MSSQL based RDS

C.
Only for Oracle RDS types

D.
No

31 Comments on “Is creating a Read Replica of another Read Replica supported?

  1. tom says:

    ‘D’ – would be the right answer for the options provided in this question.

    Please refer to url provided by @Sam above:
    Create a replica from an existing Read Replica (supported for MySQL 5.6) – You can now 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.

    1. Rocky says:

      The question : “Is creating a Read Replica of another Read Replica supported?”
      My answer is YES!

      so the list of answers provided were NON-SENSE

  2. maven says:

    The answer might be B.

    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 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. Aneesh Mohan says:

    The question is outdated , now you can have read replica of read replica option available for MYSQL. So the question is not valid to current AWS offerings .

  4. kay says:

    If a Read Replica is running any version of MariaDB or MySQL 5.6 and later, you can specify it as the source DB instance for another Read Replica. For example, you can create ReadReplica1 from MyDBInstance, and then create ReadReplica2 from ReadReplica1. Updates made to MyDBInstance are replicated to ReadReplica1 and then replicated from ReadReplica1 to ReadReplica2. You cannot have more than four instances involved in a replication chain. For example, you can create ReadReplica1 from MySourceDBInstance, and then create ReadReplica2 from ReadReplica1, and then create ReadReplica3 from ReadReplica2, but you cannot create a ReadReplica4 from ReadReplica3.

  5. RC says:

    In Fact there is NO correct answer.

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

    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.

  6. Dong Liang says:

    Create a replica from an existing Read Replica (supported for MySQL 5.6) – You can now 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.

  7. Dong Liang says:

    D

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

    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.

  8. Duck Bro says:

    D
    https://aws.amazon.com/rds/faqs/
    Q: Can I create a Read Replica of another Read Replica?

    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.

  9. aisenguru says:

    However, given the quality of choices on this particular question, the answer needs to be No because it does not give the option to select where RR of RR are actually supported which happens to be only of MySQL and MariaDB RDS.

    So it must be D.

  10. Amit says:

    Guys answer is D

    For B > MS-SQL is Microsoft SQL doesnt support creating replica of replica
    What you are referring to is My-SQL is an open source

    Johnny Volkswagon owns Audi but when it comes to cars they are simply two different cars

  11. kat says:

    Create a replica from an existing Read Replica (supported for MySQL 5.6) – You can now 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.

  12. Ricardo says:

    Today response:
    The answer is D. Because it is not supported for any kind of DB. Only for:Amazon Aurora, Amazon RDS for MySQL and MariaDB
    https://aws.amazon.com/rds/faqs/
    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.


Leave a Reply

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