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. (see upstream)

Quick Start

make build

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 3 MySQL containers with master-slaves STATEMENT-based replication¹

make build

Make changes to master

make master db=mydb sql="create table code(code int); insert into code values (100), (200)"

Read changes from slave

make slave1 db=mydb sql="select * from code \G"

make slave2 db=mydb sql="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

make ps

Clean data dir

make clean

Run command inside "mysql_master"

make master_status

Run command inside "mysql_slave"

make slave1_status

make slave2_status

Enter into "mysql_master"

make master

Enter into "mysql_slave"

make slave1

make slave2

Footnotes

1. https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html Not using row for this project ↩