Mysql master database deletes data from the database if not synchronized to delete the data before the synchronization action stops below for the solution
The first step is to stop slave synchronization service.
Step 2: Skip the current error
set global sql_slave_skip_counter=10; (Increase the value if the data is deleted)
Step 3: Start Slave;
The first step is to stop slave synchronization service.
Step 2: Skip the current error
set global sql_slave_skip_counter=10; (Increase the value if the data is deleted)
Step 3: Start Slave;
Read More:
- MySQL master-slave replication. An error is reported when starting slave. Slave failed to initialize relay log info structure from the repository
- After the two hosts set up the master-slave replication of MySQL, the show slave status displays: last_ IO_ Error: error connecting to master ……
- Oracle can’t start the database due to deleting DBF file by mistake
- Encapsulation of adding, deleting and modifying database by JDBC
- MySQL error: error 1010 (HY000) when deleting database
- MySQL operation and maintenance slave_ skip_ errors
- Mysql start slave error 1201 (HY000)
- Transfer: completely solve the problem that the browser home page is tampered by deleting the script file
- When configuring ROS distributed / Error report solution and command requirements encountered in the process of master-slave computer
- The problem of MySQL database connection failure errno: 1049 error
- Caused by: java.net.SocketException : connection reset or caused by: java.sql.SQLRecoverableException solve
- Hadoop hdfs dfs -ls/ error: Call From master/192.168.88.108 to slave1:9820 failed on connection except
- MySQL workbench insert data prompt error: 1046 (errorcode: 1046. No database select…)
- Solution of MySQL data garbled problem
- Solve the problem of MySQL database report 1055 error
- Solve the problem caused by: java.sql.SQLRecoverableException : IO error: connection reset related problems
- Using AspectJ to transfer the data written to FTP service to MySQL database
- Solutions to the problem of using sudo caused by Ubuntu’s wrong modification of sudoers
- An error is reported when kettle connects Oracle database and MySQL database