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 operation and maintenance slave_ skip_ errors
- MySQL master-slave replication. An error is reported when starting slave. Slave failed to initialize relay log info structure from the repository
- MySQL error code 1217 (ER_ROW_IS_REFERENCED): Cannot delete or update a parent row: a foreign key co
- Error connecting to master, – retry time: 60 retries: 86400
- After the two hosts set up the master-slave replication of MySQL, the show slave status displays: last_ IO_ Error: error connecting to master ……
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- Explain MySQL replication error 1032 & 1205
- ERROR 2026 (HY000): SSL connection error: ASN: before date in the future
- Centos7 view and close firewall
- MySQL error STORAGE ENGINE failed
- 【Exception】mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table…
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MySQL error: error 1010 (HY000) when deleting database
- [Oracle] when inserting data, “ora-00001: unique constraint” appears
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./myapp’, errno: 39)
- Error 1045 (28000): solution to access denied for user ‘root’ @’localhost ‘(using password: no)
- Error dropping database can’t rmdir