If I have multiple Read Replicas for my master DB Instance and I promote one of them, what happens to the
rest of the Read Replicas?
A.
The remaining Read Replicas will still replicate from the older master DB Instance
B.
The remaining Read Replicas will be deleted
C.
The remaining Read Replicas will be combined to one read replica
Answer should be A:
If a source DB instance has several Read Replicas, promoting one of the Read Replicas to a DB instance has no effect on the other replicas.
A is the right answer.
See http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.Promote
If a source DB instance has several Read Replicas, promoting one of the Read Replicas to a DB instance has no effect on the other replicas.
A.
The remaining Read Replicas will still replicate from the older master DB Instance
I choose A
If you promote a MySQL or MariaDB Read Replica that is in turn replicating to other Read Replicas, those Read Replicas remain active.
Consider an example where MyDBInstance1 replicates to MyDBInstance2, and MyDBInstance2 replicates to MyDBInstance3. If you promote MyDBInstance2, replication from MyDBInstance1 to MyDBInstance2 no longer occurs, but MyDBInstance2 still replicates to MyDBInstance3.
A is the correct answer for me