Example of how to build a Mysql cluster with docker

yum -y update

yum install -y docker

service docker start
service docker stop

docker search image name

docker pull image name

docker images

docker rmi image name

docker run startup parameter image name

docker ps -a

search:
[root@VM_71_225_centos ~]# docker search java
INDEX NAME DESCRIPTION STARS OFFICIAL AUTOMATED
docker.io docker.io/node Node.js is a JavaScript-based platform for... 5752 [OK]
docker.io docker.io/tomcat Apache Tomcat is an open source implemen... 1891 [OK]
docker.io docker.io/java Java is a concurrent, class-based, and obj... 1745 [OK]
docker.io docker.io/openjdk OpenJDK is an open-source implemen... 1031 [OK]

download:
[root@VM_71_225_centos ~]# docker pull docker.io/java
Using default tag: latest
Trying to pull repository docker.io/library/java ...
latest: Pulling from docker.io/library/java
5040bd298390: Downloading [=> ] 1.572 MB/51.36 MB

run:
[root@VM_71_225_centos ~]# docker run -it --name myjava docker.io/java bash
root@25623e12b759:/# java


-i: Run the container in interactive mode, usually used with -t;


-t: reallocate a pseudo input terminal for the container, usually used together with -i;

docker pull percona/percona-xtradb-cluster

[root@VM_71_225_centos ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
docker.io/hello-world latest e38bc07ac18e 2 months ago 1.85 kB
docker.io/percona/percona-xtradb-cluster latest f1439de62087 3 months ago 413 MB
docker.io/java latest d23bdf5b1b1b 17 months ago 643 MB

[root@VM_71_225_centos ~]# docker tag percona/percona-xtradb-cluster pxc
[root@VM_71_225_centos ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
docker.io/hello-world latest e38bc07ac18e 2 months ago 1.85 kB
docker.io/percona/percona-xtradb-cluster latest f1439de62087 3 months ago 413 MB
pxc latest f1439de62087 3 months ago 413 MB
docker.io/java latest d23bdf5b1b1b 17 months ago 643 MB

docker network create --subnet=172.18.0.0/16 net1

docker volume create v1
docker volume create v2
docker volume create v3
docker volume create v4
docker volume create v5

[root@VM_71_225_centos code]# docker inspect v1
[
  {
    "Driver": "local",
    "Labels": {},
    "Mountpoint": "/var/lib/docker/volumes/v1/_data",
    "Name": "v1",
    "Options": {},
    "Scope": "local"
  }
]

#Create the first MySQL node docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=abc123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=abc123456 -v v1:/var/lib/mysql -v backup:/data --privileged --name=node1 --net=net1 --ip 172.18.0.2 pxc

#Create the second MySQL node docker run -d -p 3307:3306 -e MYSQL_ROOT_PASSWORD=abc123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=abc123456 -e CLUSTER_JOIN=node1 -v v2:/var/lib/mysql -v backup:/data --privileged --name=node2 --net=net1 --ip 172.18.0.3 pxc
#Create the third MySQL node docker run -d -p 3308:3306 -e MYSQL_ROOT_PASSWORD=abc123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=abc123456 -e CLUSTER_JOIN=node1 -v v3:/var/lib/mysql --privileged --name=node3 --net=net1 --ip 172.18.0.4 pxc
#Create the fourth MySQL node docker run -d -p 3309:3306 -e MYSQL_ROOT_PASSWORD=abc123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=abc123456 -e CLUSTER_JOIN=node1 -v v4:/var/lib/mysql --privileged --name=node4 --net=net1 --ip 172.18.0.5 pxc
#Create the fifth MySQL node docker run -d -p 3310:3306 -e MYSQL_ROOT_PASSWORD=abc123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=abc123456 -e CLUSTER_JOIN=node1 -v v5:/var/lib/mysql -v backup:/data --privileged --name=node5 --net=net1 --ip 172.18.0.6 pxc

mysql -h 172.18.0.3 -uroot -pabc123456

mysql> create database test;
Query OK, 1 row affected (0.03 sec)

docker pull haproxy

vi /home/soft/haproxy.cfg

global
  #Working directory chroot /usr/local/etc/haproxy
  #Log file, use the local5 log device (/var/log/local5) in the rsyslog service, level info
  log 127.0.0.1 local5 info
  #Daemon process running daemon
​
defaults
  log global
  mode http
  #Log format option httplog
  #Do not record the heartbeat detection record of load balancing in the log option dontlognull
  #Connection timeout (milliseconds)
  timeout connect 5000
  #Client timeout (milliseconds)
  timeout client 50000
  #Server timeout (milliseconds)
  timeout server 50000
​
#Monitoring interface listen admin_stats
  #Monitoring interface access IP and port bind 0.0.0.0:8888
  #Access protocol mode http
  #URI relative address stats uri /dbs
  #Statistics report formatstats realm Global\ statistics
  #Login account information stats auth admin:abc123456
#Database load balancing listen proxy-mysql
  #Access IP and port bind 0.0.0.0:3306 
  #Network protocol mode tcp
  #Load balancing algorithm (round robin algorithm)
  # Polling algorithm: roundrobin
  #Weight algorithm: static-rr
  # Least connection algorithm: leastconn
  #Request source IP algorithm: source 
  Balance Round Robin
  #Log format option tcplog
  #Create a haproxy user with no permissions in MySQL and set the password to empty. Haproxy uses this account to perform heartbeat detection on the MySQL database option mysql-check user haproxy
  server MySQL_1 172.18.0.2:3306 check weight 1 maxconn 2000 
  server MySQL_2 172.18.0.3:3306 check weight 1 maxconn 2000 
  server MySQL_3 172.18.0.4:3306 check weight 1 maxconn 2000 
  server MySQL_4 172.18.0.5:3306 check weight 1 maxconn 2000
  server MySQL_5 172.18.0.6:3306 check weight 1 maxconn 2000
  #Use keepalive to detect dead links option tcpka

docker exec -it h1 bash
haproxy -f /usr/local/etc/haproxy/haproxy.cfg