If you don’t have any error but your replication slave does not work and you get the following information when you “show slave statusG”:
Slave_IO_State:
Slave_IO_Running: No
Step1: check your mysql log file ( mysql log file is in /var/log/mysqld.log or /var/log/syslog), if you have this error:
Got fatal error 1236: ‘Client requested master to start replication from impossible position’ from master when reading data from binary log
Step2:
mysql> show slave statusG;
You will find the master log file:
Relay_Master_Log_File: ip-218-129-133-44-bin.000124
and Master log position:
Exec_Master_Log_Pos: 450207777
Step3:
In your master server:
mysql> show master logs;
You will find a record: ip-218-129-133-44-bin.000111 | 450207682
Step4:
If the length of this log file on master is smaller than master log position on slave.
(Here 450207682<450207777)
mysql> Change Master To Master_Log_Pos=450207682;
Step5:
Restart mysql.
If it still does not work, try to do the replication from beginning following the instructions (master master replication):
http://www.quickr.org/how_to_set_up_MySQL_master_master_replication_to_synchronize_two_databases
Leave a Reply