What Happens to Read Replicas when MySQL on Amazon RDS Database is Deleted?
Question
A MySQL on the Amazon RDS database is deleted.
What happens to the read replicas?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: C.
For MariaDB, MySQL, and Oracle RDS instances, when the source database is deleted, read replicas in the same region and cross-region read replicas are promoted.
For PostgreSQL RDS instances, when the source database is deleted, read replicas in the same region are promoted, and cross-region read replicas are set to replication status “terminated.”
Therefore, Option C is CORRECT, and all other options are incorrect.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.htmlWhen a MySQL database on Amazon RDS is deleted, the read replicas associated with that database also undergo a specific process. The correct answer depends on the type of read replicas and their location. Here are the explanations of each answer:
A. All read replicas are set to replication status “terminated”. This answer is not correct. If all read replicas are set to "terminated," it means that they are stopped and can't be used anymore. This is not the behavior expected when a database is deleted.
B. Read replicas in the same region are promoted. Cross-region read replicas are set to replication status “terminated”. This answer is the correct one. When a MySQL database is deleted, the read replicas in the same region are automatically promoted to become their standalone databases. They become independent and can be managed on their own. However, cross-region read replicas are stopped and can't be used anymore.
C. All read replicas are promoted. This answer is not correct. If all read replicas are promoted, it means that they become their own standalone databases, which is not possible for cross-region read replicas since they require a source database to replicate from.
D. Read replicas in the same region are deleted. Cross-region read replicas are set to replication status “terminated”. This answer is not correct. If all read replicas are deleted, it means that they are stopped and can't be used anymore, which is not the behavior expected when a database is deleted.
In conclusion, the correct answer is B. Read replicas in the same region are promoted. Cross-region read replicas are set to replication status “terminated”.
