mjstealey/mariadb-galera

mariadb-galera

基于CentOS 7的Docker化MariaDB 10.x Galera集群镜像

本镜像旨在作为iRODS v4.2.x provider的后端集群数据库iCAT实例基础，如https://github.com/mjstealey/irods-provider-galera%E6%89%80%E8%BF%B0%E3%80%82

支持的标签及对应Dockerfile链接

• 10.1, latest (https://github.com/mjstealey/mariadb-galera/blob/master/10.1/Dockerfile)
• 10.2 (https://github.com/mjstealey/mariadb-galera/blob/master/10.2/Dockerfile)

从Docker Hub拉取镜像

bash
docker pull mjstealey/mariadb-galera:latest

本地构建

bash
$ git clone https://github.com/mjstealey/mariadb-galera.git
$ cd mariadb-galera/10.1/
$ docker build -t mariadb-galera .

使用示例

three-node-test.sh

该脚本演示如何在名为galeranet的本地Docker网络中搭建三节点Galera集群。

容器galera-node-1会基于init/initialize.sql文件创建并初始化名为ICAT的数据库。当创建galera-node-2和galera-node-3容器时，它们将根据WSREP_CLUSTER_ADDRESS的定义加入集群。

各示例节点的配置定义位于env/目录中。

运行脚本后，应观察到类似以下的输出：

$ ./three-node-test.sh
### 若galeranet网络不存在则创建 ###
### 停止/移除现有容器 ###
galera-node-1
galera-node-2
galera-node-3
galera-node-1
galera-node-2
galera-node-3
### 显示使用帮助 ###
Docker MariaDB Galera Cluster

docker-entrypoint [-hijv] [-f filename.sql] [arguments]

选项:
-h                    显示简要帮助
-i                    初始化galera集群
-j                    加入现有galera集群
-v                    详细输出
-f filename.sql       通过挂载卷提供用于初始化数据库的SQL脚本
### 启动galera-node-1并使用initialize.sql文件初始化集群'galera' ###
4e05c9abbe745a682d59fa318398985a1b503c7004a61a293f2a686afb34ba50
...
[MySQL]> SHOW STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 1     |
+--------------------+-------+
[MySQL]> SHOW databases;
+--------------------+
| Database           |
+--------------------+
| ICAT               |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
[MySQL]> SHOW grants FOR 'irods'@'localhost';
+--------------------------------------------------------------------------------------------------------------+
| Grants for irods@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'irods'@'localhost' IDENTIFIED BY PASSWORD '*60E38376E2C974797971A03D9BEEF1F5EB169FEA' |
| GRANT ALL PRIVILEGES ON `ICAT`.* TO 'irods'@'localhost'                                                      |
+--------------------------------------------------------------------------------------------------------------+
### 启动galera-node-2并加入集群'galera' ###
127e84d4c96f9048ca7bc420348b2c5d73bff7ff1475d2592a3545f6dbb6b375
...
[MySQL]> SHOW STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 2     |
+--------------------+-------+
[MySQL]> SHOW databases;
+--------------------+
| Database           |
+--------------------+
| ICAT               |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
[MySQL]> SHOW grants FOR 'irods'@'localhost';
+--------------------------------------------------------------------------------------------------------------+
| Grants for irods@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'irods'@'localhost' IDENTIFIED BY PASSWORD '*60E38376E2C974797971A03D9BEEF1F5EB169FEA' |
| GRANT ALL PRIVILEGES ON `ICAT`.* TO 'irods'@'localhost'                                                      |
+--------------------------------------------------------------------------------------------------------------+
### 启动galera-node-3并加入集群'galera' ###
69a47f82fc12942b83aa7cb7c3ee732e1f893150c36fc91f73e701d71e934978
...
[MySQL]> SHOW STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 3     |
+--------------------+-------+
[MySQL]> SHOW databases;
+--------------------+
| Database           |
+--------------------+
| ICAT               |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
[MySQL]> SHOW STATUS LIKE 'wsrep_incoming_addresses';
+--------------------------+-------------------------------------------------+
| Variable_name            | Value                                           |
+--------------------------+-------------------------------------------------+
| wsrep_incoming_addresses | 172.18.0.2:3306,172.18.0.3:3306,172.18.0.4:3306 |
+--------------------------+-------------------------------------------------+
[MySQL]> SHOW grants FOR 'irods'@'localhost';
+--------------------------------------------------------------------------------------------------------------+
| Grants for irods@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'irods'@'localhost' IDENTIFIED BY PASSWORD '*60E38376E2C974797971A03D9BEEF1F5EB169FEA' |
| GRANT ALL PRIVILEGES ON `ICAT`.* TO 'irods'@'localhost'                                                      |
+--------------------------------------------------------------------------------------------------------------+