sysopsid/mariadb-maxscale repository overview

⁠Load Balancing MariaDB Galera Cluster With MariaDB Maxscale on Docker Swarm Cluster

⁠Docker MariaDB 10.10 Galera Cluster With Based Image Ubuntu 22.04 LTS

Create Network overlay on role manager

docker network create -d overlay mydbnet

Download image mariadb-cluster

docker push sysopsid/mariadb-cluster

Deploy service dbcluster

docker service create --name dbcluster --network mydbnet --replicas=1 \
--env DB_SERVICE_NAME=dbcluster \
--env MYSQL_ROOT_PASSWORD=rootpass \
--env MYSQL_DATABASE=opsdb \
--env MYSQL_USER=opsdbuser \
--env MYSQL_PASSWORD=opsdbpass sysopsid/mariadb-cluster:latest

Cek service

docker service ls

Scaling service

docker service scale dbcluster=3

Cek status service

docker service ps dbcluster

Cek status database opsdb

docker ps -a
docker exec -it dbcluster.2.q7grb4ve8o7eigqjxl8lkfw27 \
mysql -u root -p -e "show databases;"

⁠Docker MariaDB Maxscale 6.4 With Based Image RockyLinux 8

Download image mariadb-maxscale

docker push sysopsid/mariadb-maxscale

Deploy service maxscale

docker service create --name maxscale --network mydbnet \
--env DB_SERVICE_NAME=dbcluster \
--env ENABLE_ROOT_USER=1 \
--publish 3306:3306 --publish 3307:3307 \
--constraint node.role==manager sysopsid/mariadb-maxscale:latest

Cek service

docker service ls
docker ps -a

Cek status load balancer maxscale

docker exec -it maxscale.1.g9gfc777jza8lurm1ij8ux5dk maxctrl list servers

⁠

Testing With Database Client

Deploy service mariadb 10.10

docker service create --name dbclient --network mydbnet --replicas=1 \
--env MYSQL_ROOT_PASSWORD=123456 \
--constraint node.role==manager mariadb:10.10

Cek service

docker service ls

Cek docker container on node manager

docker ps -a

CONTAINER ID	IMAGE	COMMAND	CREATED	STATUS	PORTS	NAMES
b012bde6dadf	mariadb:10.10	docker-entrypoint.s…	4 minutes ago	Up 4 minutes	3306/tcp	dbclient.1.bofe403ga5itdq7ztgf515uej
8c48758629b0	sysopsid/mariadb-maxscale:latest	/usr/bin/tini -- do…	43 minutes ago	Up 43 minutes	3306-3307/tcp, 8989/tcp	maxscale.1.g9gfc777jza8lurm1ij8ux5dk
6d779f58da53	sysopsid/mariadb-cluster:latest	docker-entrypoint.s…	About an hour ago	Up About an hour	3306/tcp, 4444/tcp, 4567-4568/tcp	dbcluster.2.q7grb4ve8o7eigqjxl8lkfw27

Access mariadb galera cluster from database client via maxscale load balancer

docker exec -it dbclient.1.bofe403ga5itdq7ztgf515uej \
mysql -u supergalera -h maxscale.1.g9gfc777jza8lurm1ij8ux5dk -p -P3307

Open new ssh connection to node manager then access container maxscale. You can using port 3306 or 3307 to access dbcluster via maxscale

docker exec -it maxscale.1.g9gfc777jza8lurm1ij8ux5dk maxctrl list servers

Server	Address	Port	Connections	State	GTID
10.0.1.43	10.0.1.43	3306	1	Slave, Synced, Running
10.0.1.42	10.0.1.42	3306	1	Slave, Synced, Running
10.0.1.40	10.0.1.40	3306	1	Master, Synced, Running

⁠

TO DO

Auto recovery maxscale (refresh config) if container galera cluster fail or restarted

⁠ Thank You