Ubuntu MySQL集群搭建教程-linux运维-PHP中文网

Ubuntu MySQL集群搭建教程

星降

发布： 2025-04-25 09:16:09

原创

1008人浏览过

在ubuntu上搭建mysql集群可以通过多种方式实现，包括使用mysql cluster、kubernetes的statefulset等。以下是使用kubernetes的statefulset部署mysql主从集群的详细步骤：

准备工作

创建Namespace

apiVersion: v1
kind: Namespace
metadata:
  name: mysql
labels:
  app: mysql

登录后复制

配置密码Secret

apiVersion: v1
kind: Secret
metadata:
  name: mysql-secret
namespace: mysql
labels:
  app: mysql
type: Opaque
data:
  password: MTIzNDU2  # base64编码的密码，生产环境建议使用更复杂的密码

登录后复制

主从配置分离

创建ConfigMap

主节点配置（master.cnf）

apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql
namespace: mysql
data:
  master.cnf: |
    [mysqld]
    log-bin=mysql-bin
    skip-name-resolves

登录后复制

从节点配置（slave.cnf）

apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql
namespace: mysql
data:
  slave.cnf: |
    [mysqld]
    super-read-only
    log-bin=mysql-bin
    replicate-ignore-db=mysql

登录后复制

网络服务配置

Headless Service

apiVersion: v1
kind: Service
metadata:
  name: mysql
namespace: mysql
labels:
  app: mysql
spec:
  ports:
  - name: mysql
    port: 3306
  clusterIP: None
  selector:
    app: mysql

登录后复制

读写分离Service

apiVersion: v1
kind: Service
metadata:
  name: mysql-read
namespace: mysql
labels:
  app: mysql
spec:
  ports:
  - name: mysql
    port: 3306
  selector:
    app: mysql

登录后复制

核心StatefulSet部署

apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: mysql
namespace: mysql
spec:
  selector:
    matchLabels:
      app: mysql
  serviceName: "mysql"
  replicas: 2
  template:
    metadata:
      labels:
        app: mysql
    spec:
      initContainers:
      - name: init-mysql
        image: mysql:5.7
        env:
        - name: MYSQL_ROOT_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mysql-secret
              key: password
        command:
        - bash
        - "-c"
        - |
          set -ex
          ordinal=$(hostname | awk '{print $NF}')
          echo "[mysqld] > /mnt/conf.d/server-id.cnf"
          echo "server-id=$((100   $ordinal))" >> /mnt/conf.d/server-id.cnf
          if [ $ordinal -eq 0 ]; then
            echo "server-id=100" >> /mnt/conf.d/server-id.cnf
          else
            echo "server-id=$((100   $ordinal))" >> /mnt/conf.d/server-id.cnf
          fi
      containers:
      - name: mysql
        image: mysql:5.7
        env:
        - name: MYSQL_ROOT_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mysql-secret
              key: password
        ports:
        - containerPort: 3306
        volumeMounts:
        - name: mysql-persistent-data
          mountPath: /var/lib/mysql
  volumeClaimTemplates:
  - metadata:
      name: mysql-persistent-data
    spec:
      accessModes: [ "ReadWriteOnce" ]
      resources:
        requests:
          storage: 10Gi

登录后复制