we upgraded our AWS RDS mysql instance from 5.5.42 to 53 and we applied the original parameter group to this instance.
However when I checked the rds instance's configuration details, the Parameter Group value remains "pending-reboot" even though I've manually rebooted the rds.
How do I fix this issue? Thanks!
In my experience a 500Gb DB will usually be restored in about 20-25 minutes.
Upgrades to the database engine level require downtime. Even if your RDS DB instance uses a Multi-AZ deployment, both the primary and standby DB instances are upgraded at the same time. This causes downtime until the upgrade is complete, and the duration of the downtime varies based on the size of your DB instance.
Amazon RDS upgrades the operating system to a newer version to improve database performance and customers' overall security posture. Typically, the updates take about 10 minutes.
Hi so I found a solution which is quite simple. I had to make a minor edit to the parameter group (any one of the many variables will do), and save the changes. After that I rebooted the rds instance and now the parameter group is in-sync.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With