Preliminary study: When deploying logical table name case blending in Mycat by deployment discovery, the full change occurs after the Mycat connection. Easy to cause Error logic table (create physical table by mixed table name);
Possible ways to Save:
1, Linux deployment installed MySQL, the default is not to ignore the table name case, you need to manually to/etc/my.cnf under the configuration Lower_case_table_names=1 to make the Linux environment MySQL ignore the table name casing, Otherwise, you will be prompted to find a table error when using Mycat!
2. The official issues mentioned that this issue was not seen on the 1.6.5 release. Select Upgrade.
Description
These methods are not necessarily feasible and need to be practiced. May also stay in the practical stage, the concept of mycat is not very well known to lead to the above problems arise.
Reference:
https://github.com/MyCATApache/Mycat-Server/issues/1498
Http://it.dataguru.cn/thread-624130-1-1.html
Analysis and research on the problem of table name full lowercase after mycat connection database