lower_case_table_names
does anyone have experience with the lower_case_table_names=1 in PXC? the default Galera Cluster Configurator sets the value to 0 (zero) and I need to have it set to 1.
thanks
-
Hi
There is no problem changing it to another value to match your environment. We just set it 0 as default.
You can do that before you run the deployment script by editing the s9s-galera-NNN/mysql/config/my.cnf file or after you have deployed the cluster by using the CC web client and go to Manage->Configurations and change it for each node.
lower_case_table_names values for your reference:- 0
Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or OS X). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption may result. - 1
Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases. - 2
Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement, but MySQL converts them to lowercase on lookup. Name comparisons are not case sensitive. This works only on file systems that are not case sensitive! InnoDB table names are stored in lowercase, as for lower_case_table_names=1.
Best Regards,
Alex
- 0
Please sign in to leave a comment.
Comments
1 comment