search

yoshinorim / mha4mysql-manager

Development tree of Master High Availability Manager and tools for MySQL (MHA), Manager part
http://code.google.com/p/mysql-master-ha/
GNU General Public License v2.0
1.46k stars 501 forks source link

MHA binlog setting check failed, need to set --start_file or --binlog_prefix #137

Closed zhangpeng3710 closed 4 years ago

zhangpeng3710 commented 4 years ago

I try to config MHA 0.56 for mysql 5.7, everything is done. when I run masterha_check_repl --conf=app1.cnf, I get the following message: executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/data/mysql --output_file=/data/mysql

Failed to save binary log: Set --start_file=<starting_binlog_filename> or --binlog_prefix=<binlog_file_prefix>

Binlog setting check failed!

I modified MasterMonitor.pm added --binlog_prefix=mysql-bin into the command , but it doesn't work, still gave me above error message.

zhangpeng3710 commented 4 years ago

I found that error in app1.cnf, cause I added #comment after params in the same line.