Changes to server_collation on aurora mysql8 instance is not applied
Hi
When changing collation_server on a 8.0.mysql_aurora.3.01.0 DB cluster it seems like the change is not applied to existing clusters but only new ones.
A custom DB cluster parameter group was created with collation_server=utf8_bin and a cluster was created using it. Later we changed to collation_server=utf8mb4_bin but the cluster now reports collation_server=utf8mb4_0900_ai_ci when executing show variables like 'c%_server' (also confirmed that when you run create database test it gets the wrong collation).
It seems like it is only related to collation_server, the value of character_set_database seems to get applied correctly.
If I create a new cluster using the updated parameter group it works as expected
Can anyone reproduce / confirm this?
Best regards Jens
- 最新
- 最多得票
- 最多評論
Check reboot pending status.
If a DB instance isn't using the latest changes to its associated DB parameter group, the AWS Management Console shows the DB parameter group with a status of pending-reboot. The pending-reboot parameter groups status doesn't result in an automatic reboot during the next maintenance window. To apply the latest parameter changes to that DB instance, manually reboot the DB instance.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithParamGroups.html
I can confirm that rebooting resolves the issue, thanks.