mysql5.6搭建主从过程中遇到主从server_uuid一致无法同步的问题怎么解决

本篇内容介绍了“mysql5.6搭建主从过程中遇到主从server_uuid一致无法同步的问题怎么解决”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！ Beginnin免费主机域名g with MySQL 5.6, the server generates a true UUID in addition to the–server-idsupplied by the user. This is available as the global, read-only variableserver_uuid.
When starting, the MySQL server automatically obtains a UUID as follows:
Attempt to read and use the UUID written in the filedata_dir/auto.cnf(wheredata_diris the server’s data directory).
Ifdata_dir/auto.cnfis not found, generate a new UUID and save it to this file, creating the file if necessary.
Theauto.cnffile has a format similar to that used formy.cnformy.inifiles. In MySQL 5.6,auto.cnfhas only a single[auto]section containing a singleserver_uuidsetting and value; the file’s contents appear similar to what is shown here:[auto]
server_uuid=8a94f357-aab4-11df-86ab-c80aa9429562

Important
Theauto.cnffile is automatically generated; do not attempt to write or modify this file.
In MySQL 5.6.5 and later, a server’sserver_uuidis 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-idoption 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即可

“mysql5.6搭建主从过程中遇到主从server_uuid一致无法同步的问题怎么解决”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注云技术网站，小编将为大家输出更多高质量的实用文章！免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@byun.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。云技术公众号手机网站二维码Copyright Yisu Cloud Ltd. All Rights Reserved. 2018 版权所有广州云技术计算有限公司粤ICP备17096448号-1
粤公网安备 44010402001142号增值电信业务经营许可证编号：B1-20181529

相关推荐: 如何使用SQL语句备份并压缩数据库

本篇内容主要讲解“如何使用SQL语句备份并压缩数据库”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用SQL语句备份并压缩数据库”吧!备份并压缩数据库的语法格式请参考如下：with后面的选项stats主要免费主…