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

0

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?

已提问 2 年前840 查看次数
1 回答
1
已接受的回答

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.

AWS
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则