项目
在 GitHub 查看
vbabak/docker-mysql-master-slave
vbabak/docker-mysql-master-slave has 264 GitHub stars and 162 forks. GitHot measured 0 stars in 24 hours. Last checked 2026-11-19 20:31 UTC. Last push 2023-04-25.
实测星标增长
- 24小时
- 0
- 7天
- 正在收集历史
- 15天
- 正在收集历史
- 1个月
- 正在收集历史
各周期内的星标净变化,周期相互重叠,并非每日新增。缺失的测量保持空白。星标代表关注度,不代表软件质量。
关于
Docker MySQL master-slave replication
数据README.md
原文Docker MySQL master-slave replication
MySQL 8.0 master-slave replication with using Docker.
Previous version based on MySQL 5.7 is available in mysql5.7 branch.
Run
To run this examples you will need to start containers with "docker-compose" and after starting setup replication. See commands inside ./build.sh.
Create 2 MySQL containers with master-slave row-based replication
./build.sh
Make changes to master
docker exec mysql_master sh -c "export MYSQL_PWD=111; mysql -u root mydb -e 'create table code(code int); insert into code values (100), (200)'"
Read changes from slave
docker exec mysql_slave sh -c "export MYSQL_PWD=111; mysql -u root mydb -e 'select * from code \G'"
Troubleshooting
Check Logs
docker-compose logs
Start containers in "normal" mode
Go through "build.sh" and run command step-by-step.
Check running containers
docker-compose ps
Clean data dir
rm -rf ./master/data/*
rm -rf ./slave/data/*
Run command inside "mysql_master"
docker exec mysql_master sh -c 'mysql -u root -p111 -e "SHOW MASTER STATUS \G"'
Run command inside "mysql_slave"
docker exec mysql_slave sh -c 'mysql -u root -p111 -e "SHOW SLAVE STATUS \G"'
Enter into "mysql_master"
docker exec -it mysql_master bash
Enter into "mysql_slave"
docker exec -it mysql_slave bash