En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

I want to remove RDS's DB replication settings and change it so that the current reader instance performs all reader/writer tasks.

0

Currently, I am using mysql in rds with two instances of reader and writer, but I would like to remove the writer instance and set the reader instance to read/write. This is an attempt to reduce costs. Actually the usage is not high enough to require DB Replication. Due to circumstances, the DB connection address of the current reader instance must be maintained. Therefore, I would like to remove only the writer instance and set the reader instance to enable writing as well. I would like to know how to do this. please answer about my question.

Sujets
Migration et modernisationAnalytiqueBase de données
Balises
Amazon Relational Database ServiceAmazon AuroraAurora MySQLMySQL
Langue
English
joeylover
demandé il y a 6 mois348 vues
1 réponse
1

Hello.

I thought it would be a good idea to promote the read replica to a writer instance and then delete the instance that was originally the writer instance.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.Promote

profile picture
EXPERT
Riku_Kobayashi
répondu il y a 6 mois
  • joeylover
    il y a 6 mois

    Thank you for your replies, but I can't find the "Promote" action on my reader database instance.

    I think my databases use synchronous replication. It's not read replicas. It's read instance. I think that's why I can't use "Promote". How can I make this read instance to writable instance? Do I just set read_only rds parameter to 0? And then just delete my write instance?

    Please give me more hint.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents