使用 Docker 配置 MySQL 主从集群

[mysqld]
log-bin = mysql-bin
server-id = 1

[mysqld]
server-id = 10

MYSQL_ROOT_PASSWORD=mytest

$ docker-compose up -d

$ docker-compose exec mysql_master mysql -uroot -pmytest

GRANT REPLICATION SLAVE ON *.* to 'backup'@'%' identified by 'mytest';
SHOW master status;

$ docker-compose exec mysql_node mysql -uroot -pmytest

change master to master_host='mysql_1',master_user='backup',
     master_password='mytest',master_log_file='mysql-bin.000004',
     master_log_pos=312,master_port=3306;

start slave;

show slave status;

create database test;

show databases;