Search code examples
mysqldatabaseamazon-web-servicesinstanceamazon-rds

Can not create a new RDS MySQL DB instance with "lower_case_table_names=1"

I'm trying to create a new MySQL v8.0.11 RDS DB Instance with "lower_case_table_names=1".

The creation of the database is stuck and in the logs I can see the following error:

"Different lower_case_table_names settings for server ('1') and data dictionary ('0')."

Anyone has gone through this?

Please help.

Solution

  • https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names

    It is prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized. The restriction is necessary because collations used by various data dictionary table fields are based on the setting defined when the server is initialized, and restarting the server with a different setting would introduce inconsistencies with respect to how identifiers are ordered and compared.

    This is a question for AWS regarding support for this option. It depends on how they initialize RDS instances. I'm guessing that they clone an image of a pre-initialized InnoDB tablespace, instead of initializing a new tablespace.