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
preguntada hace 2 años1107 visualizaciones
1 Respuesta
0
Respuesta aceptada

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

respondido hace 2 años
  • I can confirm that rebooting resolves the issue, thanks.

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas