Skip to content

lzag/docker-mysql-master-slave

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Docker MySQL master-slave replication

MySQL 8 master-slave replication with Docker.

Run

To run this examples you will need to start containers with "docker compose up". The replication is set up automagically when the containers are started.

Make changes to master

docker compose exec mysql_source sh -c 'mysql -p${MYSQL_ROOT_PASSWORD} db -e "INSERT INTO code VALUES (100), (200)"'

Read changes from replica

docker compose exec mysql_replica sh -c 'mysql -p${MYSQL_ROOT_PASSWORD} db -e "select * from code \G"'

Troubleshooting

Check Logs

docker compose logs

Check master status

docker compose exec mysql_source sh -c 'mysql -p${MYSQL_ROOT_PASSWORD} -e "SHOW BINARY LOG STATUS \G"'

Check replica status

docker compose exec mysql_replica sh -c 'mysql -p${MYSQL_ROOT_PASSWORD} -e "SHOW REPLICA STATUS \G"'

About

Docker MySQL master-slave replication

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Shell 100.0%