In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.