从库宕机引发的主键冲突
刚刚接到报警短信，从库宕机，马上通知机房重启，在检查MySQL时，发现同步挂了，报主键冲突，询问开发是不是有往里面写数据，回答没有。这就奇怪了，怎么会无缘
刚刚接到报警短信，从库宕机，马上通知机房重启，在检查MySQL时，发现同步挂了，报主键冲突，询问开发是不是有往里面写数据，回答没有。
这就奇怪了，怎么会无缘无故报错呢？在检查了my.cnf配置文件，发现有个参数没有配置：
innodb_overwrite_relay_log_info = 1当从库宕机后，重新开启主从复制同步，它可以重新执行已提交事务，这样就会造成同步失败，而这个参数就会避免这个问题的出现。
当开启了这个参数后
.... + InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates of other storage engines may have problem of consistency. + InnoDB: relay-log.info is detected. + InnoDB: relay log: position 429, file name ./gauntlet3-relay-bin.000111 + InnoDB: master log: position 280, file name gauntlet3-bin.000015 .... InnoDB: Starting crash recovery. .... InnoDB: Apply batch completed + InnoDB: In a MySQL replication slave the last master binlog file + InnoDB: position 0 468, file name gauntlet3-bin.000015 + InnoDB: and relay log file + InnoDB: position 0 617, file name ./gauntlet3-relay-bin.000111 090205 17:41:31 InnoDB Plugin 1.0.2-3 started; log sequence number 57933 + InnoDB: relay-log.info have been overwritten. .... 090205 17:41:31 [Note] Slave SQL thread initialized, starting replication in log ``gauntlet3-bin.000015`` at position 468, relay log ``./gauntlet3-relay-bin.000111`` position: 617已经执行完的Position点：
master log: position 280, file name gauntlet3-bin.000015在恢复时它内部会检测到280这个点已经执行完毕，从下一个点468开始同步，并且重写relay.info文件，，确保了主从同步正确。
建议在从库上添加，如果是官方MySQL，参数是relay_log_recovery=1
具体请参考：
本文出自 “贺春旸的技术专栏” 博客，请务必保留此出处
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1665
14
1424
52
1322
25
1270
29
1249
24
Solve the problem of playing headphones and speakers at the same time in win11
Jan 06, 2024 am 08:50 AM
Generally speaking, we only need to use one of the headphones or speakers at the same time. However, some friends have reported that in the win11 system, they encountered the problem of headphones and speakers sounding at the same time. In fact, we can turn it off in the realtek panel and it will be fine. , let’s take a look below. What should I do if my headphones and speakers sound together in win11? 1. First find and open the "Control Panel" on the desktop. 2. Enter the control panel, find and open "Hardware and Sound" 3. Then find the "Realtek High Definition" with a speaker icon. Audio Manager" 4. Select "Speakers" and click "Rear Panel" to enter the speaker settings. 5. After opening, we can see the device type. If you want to turn off the headphones, uncheck "Headphones".
One or more items in the folder you synced do not match Outlook error
Mar 18, 2024 am 09:46 AM
When you find that one or more items in your sync folder do not match the error message in Outlook, it may be because you updated or canceled meeting items. In this case, you will see an error message saying that your local version of the data conflicts with the remote copy. This situation usually happens in Outlook desktop application. One or more items in the folder you synced do not match. To resolve the conflict, open the projects and try the operation again. Fix One or more items in synced folders do not match Outlook error In Outlook desktop version, you may encounter issues when local calendar items conflict with the server copy. Fortunately, though, there are some simple ways to help
MySql data migration and synchronization: How to achieve MySQL data migration and synchronization between multiple servers
Jun 15, 2023 pm 07:48 PM
MySQL is a very popular open source relational database management system that is widely used in various web applications, enterprise systems, etc. In modern business application scenarios, most MySQL databases need to be deployed on multiple servers to provide higher availability and performance, which requires MySQL data migration and synchronization. This article will introduce how to implement MySQL data migration and synchronization between multiple servers. 1. MySQL data migration MySQL data migration refers to the data migration in the MySQL server.
What is mysql logical primary key
Jul 10, 2023 pm 01:46 PM
MySQL logical primary key refers to the field or field combination used to identify a record in the database, but it is not unique. Logical primary keys are usually used for data queries and data operations. The logical primary key can be any field with identifying properties. For example, in the user table, the user name can be used as the logical primary key because it can be used to identify a record, but it is not unique.
How to set the return key and home key on Redmi K70Pro?
Feb 23, 2024 pm 01:40 PM
Mobile phones are now a necessity for young and middle-aged people. Of course, people of each age group have different needs for mobile phones. As one of the more popular models now, RedmiK70Pro has a very diverse range of functions and services that can meet the needs of consumers of different ages. How to set the return key and home key on Redmi K70Pro? You also need to understand it clearly. Only after you understand it can you decide whether to buy this mobile phone. Then follow the editor to take a look at the following content! How to set the return key and home key on Redmi K70Pro? To access your phone's settings menu, you can open the settings interface by pulling down the notification shade or looking for the settings icon on your home screen. In the settings interface, find and click "Button" or "Navigation Bar"
Teach you how to synchronize the win10 clipboard with your mobile phone
Jan 06, 2024 am 09:18 AM
A very useful function of win10 clipboard is the cross-device cloud storage function, which is very useful and can help users copy and paste simultaneously on PC devices and mobile devices. The setting method is very simple, just set it on the clipboard in the system. Synchronize win10 clipboard to mobile phone 1. First click Start in the lower left corner to enter settings. 2. Then click "System". 3. Select "Clipboard" on the left. 4. Finally, click Login in "Cross-device synchronization" on the right, and then select your mobile phone.
How to resolve Win11 wallpaper screen conflict
Jun 29, 2023 pm 01:35 PM
How to solve Win11 wallpaper screen conflict? Recently, some users have experienced a black screen after installing some wallpaper software on their computers. This is most likely caused by wallpaper-screen conflicts. So how should this situation be solved? Let’s take a look at the solution to the problem of wallpaper screen conflict in Windows 11 system. Solution to the problem of wallpaper screen conflict in win11 system 1. Open the window in the settings option of the desktop. 2. Click the Run New Task button under the File menu. 3. Enter explorer.exe in the new task pop-up box, click OK to save and restart the resource manager.
Guide to uninstalling the NumPy library to avoid conflicts and errors
Jan 26, 2024 am 10:22 AM
The NumPy library is one of the important libraries in Python for scientific computing and data analysis. However, sometimes we may need to uninstall the NumPy library, perhaps because we need to upgrade the version or resolve conflicts with other libraries. This article will introduce readers to how to correctly uninstall the NumPy library to avoid possible conflicts and errors, and demonstrate the operation process through specific code examples. Before we start uninstalling the NumPy library, we need to make sure that the pip tool is installed, because pip is the package management tool for Python.
