MySQL database ab different steps and the process of solving

if AB different steps

1) View the auxiliary SQL log tailf/var/log/mysqld.log

140304 11:59:18 [Note] Slave I/O thread:connected to master ' [email protected]:3306 ', replication started in log ' Binlog .000011 ' at position 294

# whether the server can reach the master server smoothly

If you find that your user name password has an error /etc/my.cnf/var/lib/mysql/master.info

2) See if the SQL thread has an error

140304 11:59:08 [Note] Slave SQL thread initialized, starting replication in log ' binlog.000011 ' at position 294, relay Lo G '/var/lib/mysql/mysql-relay-bin.000001 ' Position:4

Manually to perform synchronization

1)mysql> slave stop;

2) mysql> change MASTER to master_host= ' 192.168.18.254 ', master_user= ' slave ', master_password= ' 123456 ', Master_log_ file= ' binlog.000011 ';

3) mysql > Slave start;

If synchronization occurs and data is inconsistent after AB Synchronization

Back up the main library to manually synchronize to a consistent state and then perform a manual synchronization of 1 ,2, 3 steps

MySQL database ab different steps and the process of solving