How do I upgrade MySQL from 5.6 -> 5.7 with custom parameter groups


We're preparing to migrate our MySQL 5.6 database to 5.7 before the upcoming deadline in March. Our 5.6 database is using a non-default parameter group (mostly to enable utf-8 character support), and we're not sure what steps to take to ensure that our parameters are carried forward.

So far it looks like we need to create a new parameter group for 5.7 and recreate the changes that we had made to our 5.6 parameter group before we perform the actual migration. Is this correct? What happens if we just let the database get auto-migrated to 5.7 by RDS? Will it fall back to the default parameter group for 5.7 or will it attempt to diff changes from the 5.6 parameter group and carry those changes forward?

asked 10 months ago198 views
1 Answer
Accepted Answer

When you perform a DB major version upgrade, you'll have to create a new parameter group and add the custom parameter values which you had set currently. Per documentation, "If your DB instance is a member of a custom DB parameter group, create a new DB parameter group with your existing settings that is compatible with the new major version."

By default, a version upgrade will switch to default parameter group on the newer version.

answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions