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

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.

주제

마이그레이션 및 현대화 분석 데이터베이스

태그

아마존 Relational Database Service 아마존 Aurora 오로라 MySQL MySQL

언어

English

joeylover

질문됨 6달 전347회 조회

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

전문가

Riku_Kobayashi

답변함 6달 전

joeylover
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.

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

관련 콘텐츠