Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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.

Argomenti
Migrazione e modernizzazioneAnalisiDatabase
Tag
Amazon Relational Database ServiceAmazon AuroraAurora MySQLMySQL
Lingua
English
joeylover
posta 6 mesi fa347 visualizzazioni
1 Risposta
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
ESPERTO
Riku_Kobayashi
con risposta 6 mesi fa
  • joeylover
    6 mesi fa

    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.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente