docker-mysql-replication

KO | EN

gitlite — search

#react #typescript #llm #go #golang #machine-learning #linux #macos #java #awesome #cli #kubernetes #pytorch #mcp

docker-mysql-replication

(★ 13)

Easy to use MySQL master-slave(s) replication with Docker containers

docker-mysql-replication Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# docker-mysql-replication

Need MySQL master-slave replication? One command to start master, one command to start each slave. What could be easier?

```
┌────────┐     ┌─────────┐
│        │     │         │
│ Master ├────>│ Slave 1 │
│        ├──┐  │         │
└────────┘  │  └─────────┘
           ...
            │  ┌─────────┐
            │  │         │
            └─>│ Slave N │
               │         │
               └─────────┘
```

## Environment variables

In addition to variables available from [official MySQL image](https://hub.docker.com/_/mysql/), you may/must specify
some of the following variables for `docker run`.

For both master and slave:

| Name | Type | Mandatory | Default value | Description
| ---- | ---- | --------- | ------------- | -----------
| `SERVER_ID` | Number | Yes | No default value | [--server-id option](https://dev.mysql.com/doc/refman/8.0/en/replication-options.html#sysvar_server_id)
| `MODE` | String | Yes | No default value | `master` or `slave`
| `REPLICATOR_USERNAME` | String | No | `replicator` | User name of the account to use for connecting to the master
| `REPLICATOR_PASSWORD` | String | No | `password` | Password of the account to use for connecting to the master

For master only:

| Name | Type | Mandatory | Default value | Description
| ---- | ---- | --------- | ------------- | -----------
| `LOG_BIN` | String | No | `log-bin` | [--log-bin option](https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#option_mysqld_log-bin)
| `BINLOG_FORMAT` | String | No | `MIXED` | [--binlog-format option](https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_format)

For slave only:

| Name | Type | Mandatory | Default value | Description
| ---- | ---- | --------- | ------------- | -----------
| `MASTER_HOST` | String | No | `mysql-master.tld` | Host name (or IP address) of the master host
| `MASTER_PORT` | Number | No | `3306` | TCP/IP port  of the master host
| `RELAY_LOG` | String | No | `relay-bin` | [--relay-log option](https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#sysvar_relay_log)

## Start master

Run something like

```bash
docker run \
  --name mysql-master-42 \
  --detach \
  --env SERVER_ID=42 \
  --env MODE=master \
  --env MYSQL_ROOT_PASSWORD=password \
  --publish 10000:3306 \
  quay.io/alexanderfefelov/mysql-replication \
&& docker run --rm --link mysql-master-42:foobar martin/wait -p 3306 -t 300
```

and master with server ID 42 will be available at port 10000.

## Start slave(s)

After executing something like

```bash
docker run \
  --name mysql-slave-24 \
  --detach \
  --env SERVER_ID=24 \
  --env MODE=slave \
  --env MASTER_HOST=192.168.1.123 \
  --env MASTER_PORT=10000 \
  --env MYSQL_ROOT_PASSWORD=password \
  --publish 12345:3306 \
  quay.io/alexanderfefelov/mysql-replication \
&& docker run --rm --link mysql-slave-24:foobar martin/wait -p 3306 -t 300 \
&& docker exec mysql-slave-24 cp /read-only.cnf /etc/mysql/conf.d/ \
&& docker restart mysql-slave-24 \
&& docker run --rm --link mysql-slave-24:foobar martin/wait -p 3306 -t 300
```

read-only slave with server ID 24 will be available at port 12345.

## Check replication status

On master:

```bash
docker exec --tty --interactive mysql-master-42 \
  mysql --user=root --password --execute="SHOW SLAVE HOSTS \G"
```

On slave(s):

```bash
docker exec --tty --interactive mysql-slave-24 \
  mysql --user=root --password --execute="SHOW SLAVE STATUS \G"
```

## Build non-mainstream version

You may build non-mainstream version if you want:

```bash
VERSION=8.0.13 ./build.sh
```

## What's next?

- Check out [the official documentation](https://dev.mysql.com/doc/refman/8.0/en/replication.html).
- See similar [solution for MariaDB](https://github.com/alexanderfefelov/docker-mariadb-replication).

docker-mysql-replication

docker-mysql-replication Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

docker-mysql-replication

docker-mysql-replication Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README