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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南