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.

已提問 6 個月前檢視次數 348 次
1 個回答
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
專家
已回答 6 個月前
  • 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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南