CODEWITHSUNDEEP
amazon-web-servicesdatabase-replicationamazon-aurora
Ram
Ram

Reputation: 367

How to make AWS aurora Mysql into a writable instance

I am working on a project where we are creating a new region for resilience purpose. As we create a new Region for the project, we also plan to create a Read replica of Aurora MySQL DB. My question here has two parts

  1. If the project in existing region goes down, how to make the read replica of Aurora MySQL in the other region as the new Master and writable? I searched through few videos and stackoverflow questions and I do understand how to make the RDS mysql as writable instance. but, I don't see how to make such a "read-only" parameter modification in Aurora MySQL!
  2. How could I do this change with a Jenkins Job?

Any help is highly appreciated! Thanks!

Upvotes: 1

Views: 577

Answers (1)

Ashaman Kingpin
Ashaman Kingpin

Reputation: 1577

  1. You can use the AWS CLI for this, specifically the:

aws rds promote-read-replica-db-cluster

command which contrary to the name actually applies to Aurora as stated in the documentation for the command:

Note:
This action only applies to Aurora DB clusters.

You can find more information in the AWS documentation for Aurora, specifically the section on Promoting a Read Replica to Be a DB Cluster.

  1. Seems like you should be able to use the Jenkins AWS plugin but there are many options.

Upvotes: 1

Related Questions