1.修改配置文件后重启
主 ip 10.0.0.1
[mysqld]
#read-only=1
server-id=1
log-bin=mysql-bin
从 ip 10.0.0.2
[mysqld]
read-only=1
server-id=2
log-bin=mysql-bin
2.创建同步用户
主操作
CREATE USER 'repl' IDENTIFIED BY '1';
GRANT REPLICATION SLAVE ON *.* TO 'repl';
3.配置从结点向主结点同步
从操作
CHANGE MASTER TO MASTER_HOST='10.0.0.1', MASTER_USER='repl', MASTER_PASSWORD='1';
START SLAVE;
SHOW MASTER STATUS \G;
4.(配置双主结点)
主操作
CHANGE MASTER TO MASTER_HOST='10.0.0.2', MASTER_USER='repl', MASTER_PASSWORD='1';
START SLAVE;
SHOW MASTER STATUS \G;