mottox/mysql-replication repository overview

⁠mysql-replication

A custom mysql docker image with replication enabled, easy and convenient to set up MySQL master-slave replication in 30 seconds.

⁠Introduction

The image is based on official mysql-server⁠ with replication enabled for the purpose of learning mysql. Note that this image is for people who want to learn and practice MySQL replication in an easy way.

⁠Environment Variables

SERVER_ID
Make sure every node has a different server id.

REPLICATION_USER
The user name for replication.

REPLICATION_PASSWORD
The password of replication user.

⁠Getting Started

1. Download the image

   docker pull mottox/mysql-replication
   

   Copy

   Alternatively, you could also clone this repository and build the image locally.

2. Run master node with

   docker run \
   --name master \
   -e MYSQL_ALLOW_EMPTY_PASSWORD=yes \
   -e MYSQL_ROOT_HOST=% \
   -e SERVER_ID=1 \
   -d mottox/mysql-replication
   

   Copy

   And then Run slave node with

   docker run \
   --name slave \
   -e MYSQL_ALLOW_EMPTY_PASSWORD=yes \
   -e MYSQL_ROOT_HOST=% \
   -e SERVER_ID=2 \
   -e REPLICATION_MASTER_HOST=master \
   --link master:replication   \
   -d mottox/mysql-replication
   

   Copy

   Instead of run the two commands above, you could also copy and use the docker-compose.yml configuration file and run docker-compose up to set up master-slave replication.

3. Check if replication is ready

   docker exec -it slave mysql -e 'show slave status\G'
   

   Copy

   The expected Slave_IO_State should be Waiting for master to send event.

4. Test replication freely

⁠Inspiration

official mysql image⁠
docker-mysql-replication⁠
High Performance MySQL⁠