MySQl主从配置（Ubuntun ，Mysql 8.0.25）

1 、master配置

a)修改配置

在/etc/mysql/mysql.conf.d/mysqld.cnf

设置bin-log=binlog

设置server-id=1

b)创建用于复制操作的用户

 CREATE USER 'repl'@'10.10.0.18' IDENTIFIED WITH mysql_native_password BY 'yourpwd';

  CREATE USER 'repl'@'10.10.0.21' IDENTIFIED WITH mysql_native_password BY 'yourpwd';

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'10.10.0.18';

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'10.10.0.21';

flush privileges;

c）重启 systemctl restart mysql;

2、slave1/2配置

 a)修改配置

在/etc/mysql/mysql.conf.d/mysqld.cnf

设置server-id=1|2

read-only=1

重启systemctl restart mysql 

c)在slave设置master参数

mysql> CHANGE MASTER TO

MASTER_HOST='10.10.0.15',

MASTER_USER='repl',

MASTER_PASSWORD='yourpwd',

MASTER_LOG_FILE='binlog.000006',

MASTER_LOG_POS=856;

d)查看主从同步状态

mysql> show slave status;

e)开启主从同步

mysql> start slave;

f)再查看主从同步状态

mysql> show slave status;

注意：三个主机上的Mysql的 uuid、 server_id都不能重复，否则报错。克隆的主机会重复。

mysql>show replica status ,有last_error,last_sql_error字段说明错误原因