Skip to content

Instantly share code, notes, and snippets.

@lemonlatte
Created August 20, 2019 01:35
Show Gist options
  • Save lemonlatte/bfcea4db7925bd6307241415b869f3ea to your computer and use it in GitHub Desktop.
Save lemonlatte/bfcea4db7925bd6307241415b869f3ea to your computer and use it in GitHub Desktop.
MySQL Cluster (1 master, 2 slave)
version: '2'
services:
master:
image: twang2218/mysql:5.7-replica
restart: unless-stopped
ports:
- 3306:3306
environment:
- MYSQL_ROOT_PASSWORD=master_passw0rd
- MYSQL_REPLICA_USER=replica
- MYSQL_REPLICA_PASS=replica_Passw0rd
command: ["mysqld", "--log-bin=mysql-bin", "--server-id=1"]
slave:
image: twang2218/mysql:5.7-replica
restart: unless-stopped
ports:
- 3307:3306
environment:
- MYSQL_ROOT_PASSWORD=slave_passw0rd
- MYSQL_REPLICA_USER=replica
- MYSQL_REPLICA_PASS=replica_Passw0rd
- MYSQL_MASTER_SERVER=master
- MYSQL_MASTER_WAIT_TIME=10
command: ["mysqld", "--log-bin=mysql-bin", "--server-id=2", "--read-only=ON"]
slave2:
image: twang2218/mysql:5.7-replica
restart: unless-stopped
ports:
- 3308:3306
environment:
- MYSQL_ROOT_PASSWORD=slave_passw0rd2
- MYSQL_REPLICA_USER=replica
- MYSQL_REPLICA_PASS=replica_Passw0rd
- MYSQL_MASTER_SERVER=master
- MYSQL_MASTER_WAIT_TIME=10
command: ["mysqld", "--log-bin=mysql-bin", "--server-id=3", "--read-only=ON"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment