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
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |