This repo demonstrates how to setup a mysql master replica using docker-compose and the official mysql docker image.
- Replica Pairs
cp .env.example .env
docker-compose up -d
docker logs -ft mysql_configure
// stop & remove
docker-compose down
docker exec -ti mysql_master bash
mysql -u root -p -h 127.0.0.1 -P 3306
> show databases;
docker exec -ti mysql_replica bash
mysql -u root -p -h 127.0.0.1 -P 3306
> use test;
> select * from test;
- some issues
authentication with sha2
docker logs -ft mysql_master
docker logs -ft mysql_replica
default_authentication_plugin=caching_sha2_password
fork from here, For detailed article refere to mysql