MySQL cluster using docker

.env

MYSQL_ROOT_PASSWORD=rootpass

.gitignore

NOTES.md

README.md

TL;DR

To start this cluster, run:

git clone https://gist.github.com/fb6c887fe205583a97077e8b900f98d8.git
cd fb6c887fe205583a97077e8b900f98d8
docker-compose up -d

Wait a few seconds, and check the status of the cluster:

# docker exec -it fb6c887fe205583a97077e8b900f98d8_mysql-tester_1 ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: mysql-manager-1:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=11   @172.25.0.3  (mysql-8.0.22 ndb-8.0.22, Nodegroup: 0, *)
id=12   @172.25.0.5  (mysql-8.0.22 ndb-8.0.22, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @172.25.0.4  (mysql-8.0.22 ndb-8.0.22)
id=2    @172.25.0.2  (mysql-8.0.22 ndb-8.0.22)

[mysqld(API)]   2 node(s)
id=21   @172.25.0.6  (mysql-8.0.22 ndb-8.0.22)
id=22   @172.25.0.8  (mysql-8.0.22 ndb-8.0.22)

ndb_mgm>

docker-compose.yml

version:          "3.4"

x-env-files:      &env-files
  env_file:
    - .env

x-logging:        &logging
  driver:         "json-file"
  options:
    max-size:     "100m"
    max-file:     "5"

services:
  mysql-manager-1:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      ndb_mgmd

  mysql-manager-2:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      ndb_mgmd

  data-node-1:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      ndbd

  data-node-2:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      ndbd

  mysql-server-1:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      mysqld
    ports:
      - 3306:3306

  mysql-server-2:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      mysqld
    ports:
      - 3307:3306

  mysql-tester:
    image:        mysql/mysql-cluster:8.0.22-1.1.18-cluster
    <<:           *env-files
    logging:      *logging
    networks:
      - db-network
    restart:      always
    volumes:
      - ./my.cnf:/etc/my.cnf
      - ./mysql-cluster.cnf:/etc/mysql-cluster.cnf
    command:      sleep infinity

networks:
  db-network:

my.cnf

[mysqld]
ndbcluster
ndb-connectstring=mysql-manager-1;mysql-manager-2
user=mysql
default_storage_engine=ndbcluster                   # store your data in data nodes (and not in mysql servers) if we don't specify the db engine in CREATE TABLE

[mysql_cluster]
ndb-connectstring=mysql-manager-1;mysql-manager-2

mysql-cluster.cnf

[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[ndb_mgmd]
NodeId=1
hostname=mysql-manager-1
datadir=/var/lib/mysql

[ndb_mgmd]
NodeId=2
hostname=mysql-manager-2
datadir=/var/lib/mysql

[ndbd]
NodeId=11
hostname=data-node-1
datadir=/var/lib/mysql

[ndbd]
NodeId=12
hostname=data-node-2
datadir=/var/lib/mysql

[mysqld]
NodeId=21
hostname=mysql-server-1

[mysqld]
NodeId=22
hostname=mysql-server-2