MySQL master-slave failure when the first view from the database
mysql> show slave status G;
Remember bin-log of pos and binlog file (usually selected on a point nearest to recover pos) or check the time point mysql error diary,
The mysql-binlog converted to txt, you can view each database operation
mysqlbinlog / path /mysql-bin.000xxx > txt1.txt
use change master to master_host = 'xxxx', master_user = 'mysync', master_password = 'q123456',
master_log_file = 'mysql-bin.xxx', master_log_pos = xxx;
key in the main library and can not find the mysql synchronization pos and pos where bin-log file. |