docker-compose 构建MySQL主从复制集群

cd mysql-cluster
./build.sh

docker exec mysql-master sh -c "export MYSQL_PWD=root; mysql -u root cluster_db -e 'create table code(code int); insert into code values (100), (200)'"

docker exec mysql-slave1 sh -c "export MYSQL_PWD=root; mysql -u root cluster_db -e 'select * from code \G'"
docker exec mysql-slave2 sh -c "export MYSQL_PWD=root; mysql -u root cluster_db -e 'select * from code \G'"

docker-compose logs

docker-compose ps

docker exec mysql-master sh -c 'mysql -u root -proot -e "SHOW MASTER STATUS \G"'

docker exec mysql-slave1 sh -c 'mysql -u root -proot -e "SHOW SLAVE STATUS \G"'
docker exec mysql-slave2 sh -c 'mysql -u root -proot -e "SHOW SLAVE STATUS \G"'

docker exec -it mysql-master bash

docker exec -it mysql-slave1 bash
docker exec -it mysql-slave2 bash

# 查看用户权限
show grants for db_cluster;
# 授权
GRANT ALL PRIVILEGES ON `cluster\_db2`.* TO db_cluster;
# 更新 
flush privileges;