Master – Slave olarak çalışan Mysql databaseleriniz arasındaki senkronizasyonda yaşanan kopmanın düzeltilmesi için aşağıdaki adımları izleyebilirsiniz.
mysql> show slave status\G # konutu bize mevcut durumu gösterir.
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: alexzeng.wordpress.com
Master_User: mysql_rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: LBMS-bin.000012
Read_Master_Log_Pos: 239005305
Relay_Log_File: LBMS-relay-bin.000004
Relay_Log_Pos: 221245258
Relay_Master_Log_File: LBMS-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1594
Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
Skip_Counter: 0
Exec_Master_Log_Pos: 221245113
Relay_Log_Space: 239007065
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1594
Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)
Bu durumda Master DB deki Relay log file adını ve master_log_pos değerini kontrol etmemiz gerekiyor.
Relay_Master_Log_File: LBMS-bin.000012Bu durumda slave tarafta servisi resetlememiz yeterli olacaktır.
...
Exec_Master_Log_Pos: 221245113
mysql> slave stop;Şimdi tekrar slave durumunu kontrol edebiliriz.
mysql> change master to master_log_file='LBMS-bin.000012',master_log_pos=221245113;
mysql> start slave;
mysql> show slave status\G*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: alexzeng.wordpress.com
Master_User: mysql_rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: LBMS-bin.000012
Read_Master_Log_Pos: 239014770
Relay_Log_File: LBMS-relay-bin.000002
Relay_Log_Pos: 1905303
Relay_Master_Log_File: LBMS-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 223150164
Relay_Log_Space: 17770064
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 159147
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)
Hiç yorum yok:
Yorum Gönder