Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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.

Temas
Migración y modernizaciónAnálisisBase de datos
Etiquetas
Amazon Relational Database ServiceAmazon AuroraAurora MySQLMySQL
Idioma
English
joeylover
preguntada hace 6 meses347 visualizaciones
1 Respuesta
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
EXPERTO
Riku_Kobayashi
respondido hace 6 meses
  • joeylover
    hace 6 meses

    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.

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante