• 2019-08-10T12:18:27.745963Z 7 [Note] Slave I/O thread for channel '': connected to master 'repl_user@192.168.43.81:3306',replication started in log 'mysql-bin.000001' at position 154 2019-08-10T12:18:


    2019-08-10T12:18:27.745963Z 7 [Note] Slave I/O thread for channel '': connected to master 'repl_user@192.168.43.81:3306',replication started in log 'mysql-bin.000001' at position 154
    2019-08-10T12:18:27.748074Z 7 [ERROR] Slave I/O for channel '': 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. Error_code: 1593

    上述错误提示,/var/log/mysqld.log

    because master and slave have equal MySQL server UUIDs

    应为我做实验使用的mysql是克隆的,所以MySQL server UUIDs处出现了问题
    解决方法:
    在mysql数据文件目录下有个auto.cnf文件,把他删掉,然后重启mysql服务,
    重新启动slave,正常了

    
    
  • 相关阅读:
    Python学习笔记5
    Python字符串的encode与decode
    python代码`if not x:` 和`if x is not None:`和`if not x is None:`
    关于sys.argv
    Python学习笔记4
    Python学习笔记3
    Python学习笔记2
    生产者消费者_测试
    进程管理
    软件包管理
  • 原文地址:https://www.cnblogs.com/izqq/p/11332910.html
Copyright © 2020-2023  润新知