Shulou(Shulou.com)06/01 Report--

Slave replication applies binlog exception handling method:

1. View error message

Show slave status\ G

Relay_Log_File: mysql-relay.000016

Relay_Log_Pos: 20593960

Executed_Gtid_Set: ae498b08-b570-11e3-a1ff-18a905565190:45

Mysqlbinlog-no-defaults-vvv-base64-output=DECODE-ROWS-start-position=20593960 mysql-relay.000016-result-file=result.sql

Analyze the specific statements and, if necessary, check the main library to verify the existence of the corresponding records. Confirm whether the thing can be skipped

If it is confirmed that it can be skipped, perform the next step to skip the thing.

two。 Skip the exception transaction and operate on slave:

Stop slave

Set gtid_next='ae498b08-b570-11e3mura1ffMur18a905565190pur46'

Begin;commit

Set gtid_next='AUTOMATIC'

Start slave

Show slave status\ G

3. Verify that it is back to normal.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.