szunaj13pl / docker-mysql-cluster

Cluster MySQL with Docker

Image contains nodes

• Management Node
• Data Node
• SQL Node

---

Introduction

Build

git clone https://github.com/szunaj13pl/docker-mysql-cluster.git
cd docker-mysql-cluster

Requirements

To set up the MySQL Cluster you need:

• Docker Run command docker run hello-world to check if tou have Docker instaled on yout machine Install Docker

• Proper network setup. Every machines need to see each other. Run command from HOST to REMOTE_HOST ping -c 3 <remote_host_address> && echo "SUCCESS! - $(hostname) can connect to $_"

Commands explanation

Docker basic commands

• stop -- Stops choosen container

• run -- Run a command in a new container

  • --detach -- Detached mode: leave the container running in the background

  • --name -- Container name

  • --rm -- Remove intermediate containers when it exits

  • --net -- Connect a container to a network

  • --publish           -- Expose a container's port to the host

• -v -- Bind mount a volume

  • :ro -- Volume is in read only mode

• ps -- List containers running containers

  • -a -- List all containers

• rm -- Remove one or more containers

• rmi -- Remove one or more images

Parameters

szunaj13/mysql-cluster -- Name of image repository

ndb_mgmd -- Management Node

ndbd -- Data Node

mysqld -- SQL Node

Instalation

Management Node

---

docker run --detach --name <container_name> --net=host --publish <ip_managment_node>:1186:1186 -v <patch_to_config>:/etc/mysql-cluster.ini:ro szunaj13/mysql-cluster ndb_mgmd

example:

docker run --detach --name ndb_mgmd01 --net=host --publish 192.168.0.1:1186:1186 -v config.ini:/etc/mysql-cluster.ini:ro szunaj13/mysql-cluster ndb_mgmd

---

Data Node

docker run ---detach --name <container_name> --net=host szunaj13/mysql-cluster ndbd <ip_managment_node>

example:

docker run ---detach --name ndbd01 --net=host szunaj13/mysql-cluster ndbd 192.168.0.1

---

SQL Node

docker run --detach --name <container_name> --net=host --publish <ip_sql_node>:3306:3306 szunaj13/mysql-cluster mysqld <ip_managment_node>

example:

docker run --detach --name mysqld01 --net=host --publish 192.168.0.100:3306:3306 szunaj13/mysql-cluster mysqld 192.168.0.1

---

Connect to management console

docker run -it --rm --name <container_name> szunaj13/mysql-cluster ndb_mgm <ip_managment_node>

example:

docker run -it --rm --name ndb_mgm h3nrik/mysql-cluster ndb_mgm 192.168.0.1

Configuration

config.ini:

   [NDBD DEFAULT]

   NoOfReplicas=2

   DataMemory=80M

   IndexMemory=18M

   datadir=/usr/local/mysql/data


   [NDB_MGMD DEFAULT]

   datadir=/var/lib/mysql-cluster


   [NDB_MGMD]

   NodeId=1

   hostname=192.168.0.1


   [NDBD]

   NodeId=10

   hostname=192.168.0.10


   [NDBD]

   NodeId=11

   hostname=192.168.0.11


   [MYSQLD]

   NodeId=100

   hostname=192.168.0.100


   [MYSQLD]

   NodeId=101

   hostname=192.168.0.101

You can easily change configuration

1. Update config.ini
2. Stop the management node docker restart <container_name>
3. Start the new SQL/data nodes on the hosts configured in the config.ini file.

ENV:

variable name	value
MYSQL_CLUSTER_VERSION	7.4
MYSQL_CLUSTER_MICRO_VERSION	12
MYSQL_CLUSTER_ARCH	x86_64
MYSQL_CLUSTER_HOME	/usr/local/mysql
MYSQL_CLUSTER_DATA	${MYSQL_CLUSTER_HOME}/data
MYSQL_CLUSTER_LOG	/var/lib/mysql-cluster
MYSQL_CLUSTER_CONFIG	/etc/mysql-cluster.ini