Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

AWS RDS parameter group showing "Pending-Reboot" after mysql upgrade

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!

like image 665
user3236765 Avatar asked Jan 10 '17 13:01

user3236765


People also ask

How long does it take to reboot an RDS instance?

In my experience a 500Gb DB will usually be restored in about 20-25 minutes.

Does upgrading RDS cause downtime?

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.

How long do RDS upgrades take?

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.


1 Answers

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.

like image 119
user3236765 Avatar answered Sep 28 '22 03:09

user3236765