AWS RDS instance upgrade down time
I have a few questions in regards to upgrading the RDS instance.
- What is the downtime when upgrading the instance from let's say small to large. Is the downtime relatively similar when you go and change any instance type(small, large, xlarge) or are there determining factors such as database size that alter the timing.
- Can anyone share a technique of how to upgrade the instance type avoiding the downtime using RDS? Is that even possible in RDS. It doesn't have to be in great detail just some cliff-notes/big-picture stuff.
- Is there down time when you allocate more disk space?
Answer
I don't think this is an on-topic question for StackOverflow at all, but some information anyway:
It's significant and depends on the size of the database. I've had it take an hour or more some times. I've also had creating snapshots, restoring from snapshots, and multi-az creation take around two hours before.
It depends on how you have things configured now. If you have Multi-AZ already enabled, then an instance upgrade will actually occur on the slave, then a failover will occur, then the new slave is updated. This results in about 1 or 2 minutes of actual downtime. The instance upgrade on the slave usually takes around 10 to 20 minutes, but there is no downtime in this setup. Note that when it does the failover, Amazon does a DNS swap internally so that your RDS endpoint points to the right machine, so you may have to restart your web processes that point to the DB so that they reconnect to the DB and pull in the new IP from a new DNS lookup.