tonyli71/mariadb-galera Docker 镜像 - 轩辕镜像 | Docker 镜像高效稳定拉取服务

MariaDB Galera集群Docker镜像文档

镜像概述

本镜像（adfinissygroup/k8s-mariadb-galera-centos:v004）用于在OpenShift环境中部署持久化的MariaDB Galera集群。通过StatefulSet实现多节点高可用配置，支持数据自动复制和持久化存储，适用于需要高可靠性数据库的企业级应用场景。

核心功能与特性

• Galera集群支持：基于MariaDB Galera实现多节点数据同步复制，确保集群数据一致性
• 持久化存储：通过VolumeClaimTemplates配置持久化存储，支持指定存储容量
• 自动参数配置：通过模板参数自动配置数据库用户、密码、数据库名称等关键信息
• 多端口支持：开放MySQL服务端口（3306）、SST端口（4444）、复制端口（4567）和IST端口（4568）
• 就绪探针：内置就绪探针脚本，确保Pod就绪状态检测
• StatefulSet部署：采用StatefulSet管理集群节点，保证稳定的网络标识和存储挂载

使用场景

• 企业级应用的高可用数据库服务
• 需要数据冗余和故障自动恢复的业务系统
• 基于OpenShift/Kubernetes的容器化数据库部署
• 要求数据实时同步的多节点数据库集群场景

使用方法与配置说明

模板部署准备

1. 将以下模板保存为mariadb-galera-persistent-template.yml文件：

yaml
kind: Template
apiVersion: v1
metadata:
  name: mariadb-galera-persistent
  annotations:
    description: MariaDB Galera cluster persistent (ODF)
    iconClass: icon-mariadb
    tags: database,mysql,replication,mariadb,galera,nfs
parameters:
- name: MYSQL_SERVICE_NAME
  description: Service name for the MariaDB service
  value: galera
- name: GALERA_PETSET_NAME
  description: PetSet name
  value: mysql
- name: NUMBER_OF_GALERA_MEMBERS
  description: Number of Galera Nodes
  value: "3"
  required: true
- name: VOLUME_PV_NAME
  description: Volume PV basename. If the name is "datadir", it you need to create datadir-GALERA_PETSET_NAME-number
  value: datadir
  required: true
- name: VOLUME_CAPACITY
  description: Volume space available for data, e.g. 512Mi, 2Gi.
  required: true
  value: 2Gi
- name: MYSQL_USER
  description: The username that clients will use to connect to the server
  value: user
- name: MYSQL_PASSWORD
  description: The password for the MYSQL_USER
  generate: expression
  from: "[a-zA-Z0-9]{12}"
- name: MYSQL_DATABASE
  description: The name of the database that will be created and replicated
  value: userdb
- name: MYSQL_ROOT_PASSWORD
  description: The password for the root user
  generate: expression
  from: "[a-zA-Z0-9]{12}"

objects:
- apiVersion: v1
  kind: Service
  metadata:
    annotations:
      service.alpha.kubernetes.io/tolerate-unready-endpoints: "true"
    name: "${MYSQL_SERVICE_NAME}"
    labels:
      app: "${GALERA_PETSET_NAME}"
  spec:
    ports:
    - port: 3306
      name: "${GALERA_PETSET_NAME}"
    clusterIP: None
    selector:
      app: "${GALERA_PETSET_NAME}"


- apiVersion: apps/v1beta1
  kind: StatefulSet
  metadata:
    name: "${GALERA_PETSET_NAME}"
  spec:
    serviceName: "${MYSQL_SERVICE_NAME}"
    replicas: "${NUMBER_OF_GALERA_MEMBERS}"
    template:
      metadata:
        labels:
          app: "${GALERA_PETSET_NAME}"
        annotations:
          pod.alpha.kubernetes.io/initialized: "true"
      spec:
        containers:
        - name: "${GALERA_PETSET_NAME}"
          image: adfinissygroup/k8s-mariadb-galera-centos:v004
          imagePullPolicy: IfNotPresent
          ports:
          - containerPort: 3306
            name: mysql
          - containerPort: 4444
            name: sst
          - containerPort: 4567
            name: replication
          - containerPort: 4568
            name: ist
          readinessProbe:
            exec:
              command:
              - /usr/share/container-scripts/mysql/readiness-probe.sh
            initialDelaySeconds: 15
            timeoutSeconds: 5
          volumeMounts:
          - name: "${VOLUME_PV_NAME}"
            mountPath: /var/lib/mysql
            subPath: data
          env:
            - name: POD_NAMESPACE
              valueFrom:
                fieldRef:
                  apiVersion: v1
                  fieldPath: metadata.namespace
            - name: MYSQL_USER
              value: "${MYSQL_USER}"
            - name: MYSQL_PASSWORD
              value: "${MYSQL_PASSWORD}"
            - name: MYSQL_DATABASE
              value: "${MYSQL_DATABASE}"
            - name: MYSQL_ROOT_PASSWORD
              value: "${MYSQL_ROOT_PASSWORD}"
            - name: GALERA_PETSET_NAME
              value: "${GALERA_PETSET_NAME}"
    volumeClaimTemplates:
    - metadata:
        name: "${VOLUME_PV_NAME}"
      spec:
        accessModes: [ "ReadWriteOnce" ]
        resources:
          requests:
            storage: "${VOLUME_CAPACITY}"

参数说明

部署步骤

1. 使用OpenShift命令行工具部署模板：

   bash
   oc create -f mariadb-galera-persistent-template.yml
   

2. 基于模板创建应用，指定必要参数：

   bash
   oc new-app --template=mariadb-galera-persistent \
     -p NUMBER_OF_GALERA_MEMBERS=3 \
     -p VOLUME_PV_NAME=datadir \
     -p VOLUME_CAPACITY=5Gi \
     -p MYSQL_DATABASE=myappdb
   

环境变量说明

容器运行时会自动注入以下环境变量：

• POD_NAMESPACE：当前Pod所在的命名空间（从Pod元数据获取）
• MYSQL_USER：数据库普通用户
• MYSQL_PASSWORD：普通用户密码
• MYSQL_DATABASE：默认数据库名称
• MYSQL_ROOT_PASSWORD：root用户密码
• GALERA_PETSET_NAME：StatefulSet名称

端口说明

存储配置

通过volumeClaimTemplates自动创建持久化存储声明，默认使用ReadWriteOnce访问模式，存储容量由VOLUME_CAPACITY参数指定。存储卷名称格式为${VOLUME_PV_NAME}-${GALERA_PETSET_NAME}-<number>，例如datadir-mysql-0、datadir-mysql-1等。