mysql5.6搭建主從過程中遇到主從server_uuid一致無法同步的問題
Property | Value |
---|---|
System Variable | server_uuid |
Scope | Global |
Dynamic | No |
Type | string |
When starting, the MySQL server automatically obtains a UUID as follows:
-
Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir is the server's data directory).
-
If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary.
The auto.cnf file has a format similar to that used for my.cnf or my.ini files. In MySQL 5.6, auto.cnf has only a single [auto] section containing a single server_uuid setting and value; the file's contents appear similar to what is shown here:
[auto]server_uuid=8a94f357-aab4-11df-86ab-c80aa9429562
The auto.cnf file is automatically generated; do not attempt to write or modify this file.
In MySQL 5.6.5 and later, a server's server_uuid is also used in GTIDs for transactions originating on that server. For more information
When starting, the slave I/O thread generates an error and aborts if its master's UUID is equal to its own unless the --replicate-same-server-id option has been set.
錯誤如下:
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
解決方法:
cd $MYSQL_DATA_HOME/data/
mv auto.cnf auto.cnf.bk
重啟mysql即可
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-2153807/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Mysql主從架構搭建的時候遇到的問題MySql架構
- mysql主從同步問題整理MySql主從同步
- MySQL5.6升級5.7時,出現主從延遲問題排查過程MySql
- mysql主從同步(2)-問題梳理MySql主從同步
- MySQL主從不一致的修復過程MySql
- Redis主從同步叢集搭建Redis主從同步
- Mysql5.6主從複製MySql
- MySQL主從同步(一主一從、一主多從、主從從)等結構的概述與配置MySql主從同步
- mysql主從不同步問題解決MySql
- 快速搭建主從的指令碼和問題排查指令碼
- RocketMQ主從同步MQ主從同步
- Redis主從同步Redis主從同步
- mysql主從同步MySql主從同步
- mysql 主從同步 Error 'Out of range value for column的問題MySql主從同步Error
- MYSQL主從不同步問題以及解決辦法彙總MySql
- 搭建 mariadb 資料庫主從同步資料庫主從同步
- rocketMq之雙主雙從同步模式搭建MQ模式
- redis建立主從複製的過程Redis
- Redis主從搭建Redis
- mysql主從搭建MySql
- MYSQL資料庫主從同步(一主一從)MySql資料庫主從同步
- MySQL 5.7的安裝及主從複製(主從同步)MySql主從同步
- MySQL主從同步配置MySql主從同步
- Mongo主從同步原理Go主從同步
- MySQL複製過程中出現的從庫無法連線主庫的解決辦法MySql
- mysql5.6主從引數詳解MySql
- MySQL-主從複製之同步主從資料MySql
- MySQL 主從 AUTO_INCREMENT 不一致問題分析MySqlREM
- centos 搭建redis主從CentOSRedis
- MYSQL主從搭建5.6.38MySql
- mysqlxtrabackup線上搭建主從MySql
- Centos7 下配置mysql5.6主從複製例項(一主兩從)CentOSMySql
- MYSQL5.6.40原始碼安裝 主從搭建 主主搭建MySql原始碼
- MySQL主從不同步問題分析與處理思路MySql
- ORACLE RAC TO RAC DG搭建過程中可能遇到的問題Oracle
- 用 docker 學習 redis 主從複製2 主從同步的offsetDockerRedis主從同步
- MySQL 資料主從同步MySql主從同步
- redis主從同步機制Redis主從同步