MySQL 9.0.1 InnoDB Cluster with Docker Compose

Installation

Install docker if you don't have docker on your linux machine

curl -fsSL https://get.docker.com -o docker.sh
chmod +x docker.sh
sudo ./docker.sh

• Clone Project files

git clone https://github.com/mahmoud-eskandari/mysql-cluster.git

• Change Directory to the project directory

cd mysql-cluster

• Up databases

docker compose up -d s1 s2 s3

• Initialize cluster (just before first use not more)

chmod +x up.sh

docker compose exec -it s1 mysqlsh "root@s1:3306" --password=mysql -f "/var/initialize.js" 

Note:

When propt shows:
Please select a recovery method [C]lone/[I]ncremental recovery/[A]bort (default Clone):

Then insert: C

When it shows:
Waiting for server restart...

First time run: `docker compose restart s2`
Then: `docker compose restart s3`

mkdir ./data/mysqlrouter
sudo chmod 7777 ./data/mysqlrouter -R

• Up router

docker compose up -d router

view logs:

docker compose logs -f

Log in to cluster

mysql root@localhost:6446 -p
Password: mysql

After reboot/Turn on cluster

./up.sh

Check Cluster Status:

  docker compose exec -it s1 /bin/sh
  mysqlsh
  mysqlsh > \js
  mysqlsh > shell.connect('root@s1:3306', "mysql")
  mysqlsh > dba.getCluster().status();
  mysqlsh > \quit

• Change data directory for each server to another disks by editing docker-compose.yml

Like:

  s1:
    env_file:
      - server.env
    volumes:
      - ./data/s1:/var/lib/mysql

Change last line to:

    volumes:
      - ./mnt/disk1:/var/lib/mysql

Architecture:

graph TD;
    SQLQueries-->Router;
    Router-->S1:Primary;
    Router-->S2:Secondary;
    Router-->S3:Secondary;

    AdminAPI-->S1:Primary;

Loading