By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

About drop aurora instance under primary production instance mysql.

0

Good morning, I have an aurora read replica below a production transactional instance in mysql. My question is, how do I drop this reading instance, considering that it presents an error message to drop, message below: It is important to point out that he does not have to be promoted to master, as the transactional database is ok

"Cannot delete the last instance of the read replica DB cluster. Promote the DB cluster to a standalone DB cluster in order to delete it."

Enter image description here

Topics
AnalyticsDatabase
Tags
Amazon AuroraMySQL
Language
English
rePost-User-9651737
asked 7 months ago165 views
1 Answer
0

HI, Greetings!

When you promote the Aurora cluster, it will be a standalone cluster and no longer be synchronised with the source (RDS primary) as the replication from source is stopped. And this promotion will not impact the source (RDS primary) and your applications will continue to work with the existing endpoints of the source unless you update it/perform a cutover.

Hence in order to delete the Aurora Read Replica that you created, it is safe to Promote the Aurora cluster and then perform the deletion, without impacting your transactional database.

Let me know if I answered your question or if you have any follow-up.

Thanks,

Ranjini Menon

profile pictureAWS
RanjiniMenon-AWS
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content