//
you're reading...

Questions

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

Discussion

28 Responses to “Is creating a Read Replica of another Read Replica supported?”

  1. Venku says:

    It is possible for the MySql database.

  2. borja says:

    You cannot create a Read Replica from another Read Replica (that is, you cannot create cascading Read Replicas).

    http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

  3. 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.

    • 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

  4. R says:

    D is correct

  5. Chef says:

    No. D is correct.

  6. 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.

  7. swagata mondal says:

    B is the correct answe
    https://aws.amazon.com/about-aws/whats-new/2013/08/28/amazon-rds-read-replica-new-features/
    we can create read replica for mysql

  8. 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 .

  9. 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.

  10. 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.

  11. Lee says:

    There is no answer.

    MS-SQL, MySQL, MariaDB supported read replica of read replica.

  12. 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.

  13. 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.

  14. 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.

  15. aisenguru says:

    Answer is Yes.

  16. aisenguru says:

    up to 5 replicas allowed (including a replica of a replica.

  17. aisenguru says:

    RR of RR are only available for MySQL and MariaDB.

  18. 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.

  19. Johnny says:

    Oracle owns MySQL so the answer is C Only for Oracle RDS types

  20. 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

  21. noorani khan says:

    question is wrong . It is supported but theres no right answer in the list LOOOOL

  22. Ganesh Ghube says:

    Only with MySQL based RDS

Leave a Reply