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

1. Delete a record in the Master node, and the Slave node cannot find the record and report an error

Take the following measures:

Stop slave

Set global sql_slave_skip_counter=1

Start slave

2. Update a record on the Master node, but not on the Slave node

Find the missing record on the Slave node and manually perform the INSERT operation to complete the data

Insert into table_name.

Stop slave

Set global sql_slave_skip_counter=1

Start slave

3. SLave node relay log is corrupted

Find the Master_Log_File and Exec_Master_Log_Pos parameters through the show slave status\ G command

Stop slave

Change master to master_log_file='MySQL-bin.0000010',master_log_pos=821

Start slave

You can also add the parameter relay_log_recovery to the configuration file to automatically repair the relay log

The meaning of relay_log_recovery parameter:

Turn on automatic recovery of relay logs as soon as the MySQL service starts. The recovery process creates a new relay log file, initializes the location of the SQL thread in the new relay log, and initializes the I / O thread pointing to the location of the SQL thread.

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.