Changes to server_collation on aurora mysql8 instance is not applied

0

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

profile picture
jtm
posta 2 anni fa1107 visualizzazioni
1 Risposta
0
Risposta accettata

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

con risposta 2 anni fa
  • I can confirm that rebooting resolves the issue, thanks.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande