I started an upgrade for our production SQL Server RDS instance to version 15.0.4435, and it's been running for over 3 hours now. We have multi-AZ enabled for redundancy. Interestingly, when I did the same upgrade on our staging and QA environments, it only took about 20-30 minutes. I'm really curious about what might be slowing down this upgrade. Does anyone know if this duration is typical?
2 Answers
Make sure to check the MySQL error logs via events from your RDS instance; they could give you some insight into what's causing the delay. Sometimes the logs will show warnings or errors that might help you pinpoint the issue.
One thing to consider is the amount of data in your production database compared to your staging environment. If the prod DB is significantly larger, it could explain the longer upgrade time. Have you checked that?
Staging and prod should be pretty close to the same. It did eventually finish at some point overnight.
It was actually SQL Server, not MySQL. But yes, it did finish at some point overnight.