By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Make multi-az cluster read replica, to be writable.

0

Im trying to find a way, to make the multi-az cluster read replica, to become writable. Is it even possible? or the only way of "promoting" the read replica, to be writable, is to "failover" the primary instance?

  • Gary Mclean EXPERT
    a year ago

    What RDS instance/type are you running? MYSQL/Auora?

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceDatabase
Language
English
Joann Babak
asked a year ago219 views
1 Answer
0
Accepted Answer

An RDS Multi-az cluster has one writer node and two reader nodes. Only one of these is writeable. You can call failover-db-cluster to switch roles, but the result will still be one writer and two readers. Hope that answered your question.

AWS
MODERATOR
philaws
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content