By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Bug Report: default_collation_for_utf8mb4 of parameter group not applied after RDS restart

1

I want to report a bug. I use RDS with MySQL 8.0.31 I set default_collation_for_utf8mb4=utf8mb4_general_ci After RDS is modified, I run "show global variables like 'default_collation_for_utf8mb4';" and the value indeed changed to utf8mb4_general_ci.

But after I restart my RDS instance, the default_collation_for_utf8mb4 goes back to utf8mb4_0900_ai_ci, which breaks our replication to MySQL 5.7 instance.

Please check this bug. Thank you

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceDatabaseMySQL
Language
English
rePost-User-0087010
asked a year ago1129 views
2 Answers
0

It seems that the default_collation_for_utf8mb4 parameter is not being persisted after an RDS restart. This could be due to a configuration issue or a bug in RDS itself.

One workaround you can try is to create a custom parameter group that sets the default_collation_for_utf8mb4 parameter to the desired value. Then, associate your RDS instance with this custom parameter group. This should ensure that the desired value for default_collation_for_utf8mb4 is applied even after an RDS restart.

hash
answered a year ago
  • rePost-User-0087010
    a year ago

    Hello, sry I didn't explained clearly. I am already using a custom parameter group. Even though I am using a custom parameter group, after a restart of RDS, the value still resets. Thats the bug.

0

I'm having the exact same bug.

alex
answered 8 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

Relevant content