再次通过tiup cluster edit-config xxxx查看,已经看到lower_case_table_names: 1了。
但尝试登录OGG时还是报错
OGG-00768 The Value ‘2’ of system variable lower_case_table_names is not supported. SQL error (0)
客户端查看该参数,还是未修改状态:
MySQL [(none)]> show variables like ‘%lower_case%’;
±-----------------------±------+
| Variable_name | Value |
±-----------------------±------+
| lower_case_file_system | 1 |
| lower_case_table_names | 2 |
±-----------------------±------+
2 rows in set (0.24 sec)
MySQL [(none)]> show variables like ‘lower%’;
±-----------------------±------+
| Variable_name | Value |
±-----------------------±------+
| lower_case_file_system | 1 |
| lower_case_table_names | 2 |
±-----------------------±------+
2 rows in set (0.25 sec)