MySQL修改server uuid

如果从服务器是克隆的主服务器，那么server uuid的值就和主服务器是一样的，后面主从复制报错误1593，所以我们要修改从服务器的server uuid

1、登录MySQL

[root@localhost ~]# mysql -uroot -proot

2、利用uuid函数生成新的uuid

mysql> select uuid();
+--------------------------------------+
| uuid()                               |
+--------------------------------------+
| d5364e36-d19f-11ec-900e-000c29e2ab08 |
+--------------------------------------+
1 row in set (0.01 sec)

3、查看配置文件目录

mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)

4、复制新标签，到另外一个界面操作

[root@localhost ~]# vi /var/lib/mysql/auto.cnf
5、uuid修改为新生成的uuid

server-uuid=d5364e36-d19f-11ec-900e-000c29e2ab08

6、重启服务

service mysqld restart