Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

RDS modify Multi AZ to true

17 October,2023 by Rambler

How do I change my RDS from single AZ to multi AZ?

 

Step 1 : Make a note of the current configuration of the Single AZ RDS Instance 

aws rds describe-db-instances --db-instance-identifier myrdsinstance

"Address": "myrdsinstance.xxxxxxx.xxxxxx.rds.amazonaws.com",

"AvailabilityZone": "az-1",

Multi AZ : false 

 

Step 2 : Modify the RDS Instance - in this case I'm applying immediately , although there is an option to make the change at the next Maintenance window 

aws rds modify-db-instance --db-instance-identifier myrdsinstance --multi-az --apply-immediately

 

aws rds describe-db-instances --db-instance-identifier dms-test-jv-instance

"DBInstanceStatus": "modifying"

Eventually it will change to to "available"

 

"Address": "myrdsinstance.xxxxxxx.xxxxxx.rds.amazonaws.com",

"AvailabilityZone": "az-1",

Multi AZ : false 

"SecondaryAvailabilityZone": "az-2",

From AWS docs

"the new addition is SecondaryAvailabilityZone  .If MultiAZ is true , specifies the name of the secondary Availability Zone for a DB instance with multi-AZ support"

 

Read more on RDS management topics

What is option group and parameter group in RDS ?

How do I restore my AWS RDS? aws backup start-restore-job example

DeleteDBInstance - Cannot delete RDS Instance

 

 

 


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on RDS modify Multi AZ to true


dba-ninja.com