k8s搭建MySQL主从同步

最新推荐文章于 2024-05-08 10:20:21 发布

weixin_42500998

最新推荐文章于 2024-05-08 10:20:21 发布

阅读量161

点赞数

文章标签： kubernetes mysql adb

本文链接：https://blog.csdn.net/weixin_42500998/article/details/134234297

版权

env

k8s: v1.28.2
mysql: v8.0.34

搭建nfs服务器

1. 分别在3台机器上执行安装命令
yum install -y nfs-utils

2. 在主节点创建3个目录，并写入/etc/exports中
mkdir -p /data/nfs/{mysql-master,mysql-slaver-01,mysql-slaver-01}
cat >> /etc/exports << EOF
/data/nfs/mysql-master *(rw,sync,no_root_squash)
/data/nfs/mysql-slaver-01 *(rw,sync,no_root_squash)
/data/nfs/mysql-slaver-02 *(rw,sync,no_root_squash)

3. 开启nfs server服务器
systemctl enable --now nfs-server  // 启动命令，在主节点执行
showmount -e 192.168.10.200  // 检查目录是否暴漏成功，在3台服务器上都可以执行

创建命名空间

- 命令创建
  kubectl create namespace deploy-test
- yaml文件创建(推荐)
  cat > ./namespace.yaml << EOF
  apiVersion: v1
  kind: Namespace
  metadata:
   name: deploy-test
  spec: {}
  status: {}
  EOF

创建MySQL密码的secret

kubectl create secret generic mysql-password \
    --namespace=deploy-test \
    --from-literal=mysql_root_password=root \
    --dyr-run=client \
    -o yaml \
    > mysql_root_password_secret.yaml
kubectl apply -f mysql_root_password_secret.yaml  // 执行yaml文件
kubectl get secret -n deploy-test  // 查看创建的secret

创建master结点的pv和pvc

1. 创建yaml文件
cat > ./master/pv-pvc.yaml << EOF
apiVersion: v1
kind: PersistentVolume
metadata:
  name: deploy-mysql-master-nfs-pv
  namespace: deploy-test
spec:
  capacity: 
    storage: 1Gi
  accessModes:
    - ReadWriteMany
  nfs:
    server: 192.168.10.200
    path: /data/nfs/mysql-master
  storageClassName: nfs
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: deploy-mysql-master-nfs-pvc
  namespace: deploy-test
spec:
  accessModes: 
    - ReadWriteMany
  storageClassName: nfs
  resources:
    requests:
      storage: 1Gi
  volumeName: deploy-mysql-master-nfs-pv
EOF

2. 应用yaml文件
kubectl apply -f ./master/pv-pvc.yaml

3. 查看pv, pvc
kubectl get pv,pvc -n deploy-test

为主节点准备一个配置文件

cat > ./master/my.cnf << EOF
[mysqld]
skip-host-cache
skip-name-resolve
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock
secure-file-priv = /var/lib/mysql-files
pid-file = /var/run/mysqld/mysqld.pid
user = mysql
secure-file-priv = NULL
server-id = 1
log-bin = master-bin
log_bin_index = master-bin.index
binlog_do_db = xiaohh_user
binlog_ignore_db = information_schema
binlog_ignore_db = mysql
binlog_ignore_db = performance_schema
binlog_ignore_db = sys
binlog-format = ROW

[client]
socket = /var/run/mysqld/mysqld.sock

!include /etc/mysql/conf.d/
EOF

根据第5步的配置文件，创建一个ConfigMap存储这个配置文件

1. 使用kubectl生成yaml配置文件
kubectl create configmap mysql-master-cm \
    -n deploy-test \
    --from-file=./master/my.cnf \
    --dry-run=client \
    -o yaml \
    > ./master/mysql-master.yaml
    
2. 继续补充这个yaml文件
cat >> ./master/mysql-master.yaml << EOF
---
apiVersion: v1
kind: Service
metadata:
  name: deploy-mysql-master-svc
  namespace: deploy-test
  labels: 
    app: mysql-master
spec:
  ports:
  - port: 3306
    name: mysql
    targetPort: 3306
    nodePort: 30306
  selector:
    app: mysql-master
  type: NodePort
  sessionAffinity: ClientIP
---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: deploy-mysql-master
  namespace: deploy-test
spec:
  selector: 
    matchLabels:
      app: mysql-master
  serviceName: "deploy-mysql-master-svc"
  replicas: 1
  template:
    metadata:
      labels:
        app: mysql-master
    spec: 
      terminationGracePeriodSeconds: 10
      containers:
      - args:
        - --character-set-server=utf8mb4
        - --collation-server=utf8mb4_unicode_ci
        - --lower_case_table_names=1
        - --default-time_zone=+8:00
        name: mysql
        image: docker.io/library/mysql:8.0.34
        ports:
        - containerPort: 3306
          name: mysql
        volumeMounts:
        - name: mysql-data
          mountPath: /var/lib/mysql
        - name: mysql-conf
          mountPath: /etc/my.cnf
          readOnly: true
          subPath: my.cnf
        env: 
        - name: MYSQL_ROOT_PASSWORD
          valueFrom: 
            secretKeyRef:
              key: mysql_root_password
              name: mysql-password
      volumes:
      - name: mysql-data
        persistentVolumeClaim:
          claimName: deploy-mysql-master-nfs-pvc
      - name: mysql-conf
        configMap:
          name: mysql-master-cm
          items: 
          - key: my.cnf
            mode: 0644
            path: my.cnf
EOF

应用此配置文件

kubectl apply -f ./master/mysql-master.yaml

查看应用状态

kubectl get all -o wide -n deploy-test

进入容器查看

kubectl exec -itn deploy-test pod/deploy-mysql-master-0 -- mysql -u root -p

在MySQL交互式环境中，验证logbin是否成功

show master status;

在这里插入图片描述
11. 为第一个从节点创建pv，pvc

1. 新建slave-01文件夹
mkdir slave-01

2. 创建pv-pvc.yaml
cat > ./slave-01/pv-pvc.yaml << EOF
apiVersion: v1
kind: PersistentVolume
metadata:
  name: deploy-mysql-slave-01-nfs-pv
  namespace: deploy-test
spec:
  capacity:
    storage: 1Gi
  accessModes:
  - ReadWriteMany
  nfs:
    server: 192.168.10.200
    path: /data/nfs/mysql-slaver-01
  storageClassName: "nfs"
  
---

apiVersion: v1
kind: PersistentVolumeClaim
metadata: 
  name: deploy-mysql-slave-01-nfs-pvc
  namespace: deploy-test
spec:
  accessModes:
  - ReadWriteMany
  storageClassName: "nfs"
  resources:
    requests:
      storage: 1Gi
  volumeName: deploy-mysql-slave-01-nfs-pv
EOF

3. 应用pv-pvc.yaml文件
kubectl apply -f slave-02/pv-pvc.yaml

创建./slave-01/my.cnf文件

cat > ./slave-01/my.cnf << EOF
[mysqld]
skip-host-cache
skip-name-resolve
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock
secure-file-priv = /var/lib/mysql-files
pid-file = /var/run/mysqld/mysqld.pid
user = mysql
secure-file-priv = NULL
server-id = 2
log-bin = slave-bin
relay-log = slave-relay-bin
relay-log-index = slave-relay-bin.index

[client]
socket = /var/run/mysqld/mysqld.sock

!includedir /etc/mysql/conf.d/
EOF

根据上一步创建的文件生成configmap的yaml文件

kubectl create configmap mysql-slave-01-cm \
    -n deploy-test \
    --from-file=./slave-01/my.cnf \
    --dry-run=client \
    -o yaml \
    > ./slave-01/mysql-slave-01.yaml

补充上一步创建的yaml文件

cat >> ./slave-01/mysql-slave-01.yaml << EOF
---
apiVersion: v1
kind: Service
metadata:
  name: deploy-mysql-slave-svc
  namespace: deploy-test
  labels: 
    app: mysql-slave
spec:
  ports:
  - port: 3306
    name: mysql
    targetPort: 3306
    nodePort: 30308
  selector:
    app: mysql-slave
  type: NodePort
  sessionAffinity: ClientIP
---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: deploy-mysql-slave-01
  namespace: deploy-test
spec:
  selector:
    matchLabels:
      app: mysql-slave
  serviceName: "deploy-mysql-slave-svc"
  replicas: 1
  template:
    metadata:
      labels:
        app: mysql-slave
    spec:
      terminationGracePeriodSeconds: 10
      containers:
      - args:
        - --character-set-server=utf8mb4
        - --collation-server=utf8mb4_unicode_ci
        - --lower_case_table_names=1
        - --default-time_zone=+8:00
        name: mysql
        image: docker.io/library/mysql:8.0.34
        ports:
        - containerPort: 3306
          name: mysql
        volumeMounts:
        - name: mysql-data
          mountPath: /var/lib/mysql
        - name: mysql-conf
          mountPath: /etc/my.cnf
          readOnly: true
          subPath: my.cnf
        env:
        - name: MYSQL_ROOT_PASSWORD
          valueFrom:
            secretKeyRef:
              key: mysql_root_password
              name: mysql-password
      volumes:
      - name: mysql-data
        persistentVolumeClaim:
          claimName: deploy-mysql-slave-01-nfs-pvc
      - name: mysql-conf
        configMap:
          name: mysql-slave-01-cm
          items:
          - key: my.cnf
            mode: 0644
            path: my.cnf
EOF

应用上一步生成的yaml文件

1. 应用yaml文件
kubectl apply -f slave-01/mysql-slave-01.yaml

2. 查看状态
kubectl get all -o wide -n deploy-test

为第二个从节点创建pv, pvc

1. 创建slave-02文件夹
mkdir slave-02

2. 创建pv-pvc.yaml
cat > ./slave-02/pv-pvc.yaml << EOF
apiVersion: v1
kind: PersistentVolume
metadata:
  name: deploy-mysql-slave-02-nfs-pv
  namespace: deploy-test
spec:
  capacity:
    storage: 1Gi
  accessModes:
  - ReadWriteMany
  nfs:
    server: 192.168.10.200
    path: /data/nfs/mysql-slaver-02
  storageClassName: "nfs"
  
---

apiVersion: v1
kind: PersistentVolumeClaim
metadata: 
  name: deploy-mysql-slave-02-nfs-pvc
  namespace: deploy-test
spec:
  accessModes:
  - ReadWriteMany
  storageClassName: "nfs"
  resources:
    requests:
      storage: 1Gi
  volumeName: deploy-mysql-slave-02-nfs-pv
EOF

3. 应用pv-pvc.yaml文件
kubectl apply -f slave-01/pv-pvc.yaml

创建./slave-02/my.cnf

cat > ./slave-02/my.cnf << EOF
[mysqld]
skip-host-cache
skip-name-resolve
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock
secure-file-priv = /var/lib/mysql-files
pid-file = /var/run/mysqld/mysqld.pid
user = mysql
secure-file-priv = NULL
server-id = 3
log-bin = slave-bin
relay-log = slave-relay-bin
relay-log-index = slave-relay-bin.index

[client]
socket = /var/run/mysqld/mysqld.sock

!includedir /etc/mysql/conf.d/
EOF

根据上一步创建的文件生成configmap的yaml文件

kubectl create configmap mysql-slave-02-cm \
    -n deploy-test \
    --from-file=./slave-02/my.cnf \
    --dry-run=client \
    -o yaml \
    > ./slave-02/mysql-slave-02.yaml

补充上一步创建的yaml文件

cat >> ./slave-02/mysql-slave-02.yaml << EOF
---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: deploy-mysql-slave-02
  namespace: deploy-test
spec:
  selector:
    matchLabels:
      app: mysql-slave
  serviceName: "deploy-mysql-slave-svc"
  replicas: 1
  template:
    metadata:
      labels:
        app: mysql-slave
    spec:
      terminationGracePeriodSeconds: 10
      containers:
      - args:
        - --character-set-server=utf8mb4
        - --collation-server=utf8mb4_unicode_ci
        - --lower_case_table_names=1
        - --default-time_zone=+8:00
        name: mysql
        image: docker.io/library/mysql:8.0.34
        ports:
        - containerPort: 3306
          name: mysql
        volumeMounts:
        - name: mysql-data
          mountPath: /var/lib/mysql
        - name: mysql-conf
          mountPath: /etc/my.cnf
          readOnly: true
          subPath: my.cnf
        env:
        - name: MYSQL_ROOT_PASSWORD
          valueFrom:
            secretKeyRef:
              key: mysql_root_password
              name: mysql-password
      volumes:
      - name: mysql-data
        persistentVolumeClaim:
          claimName: deploy-mysql-slave-02-nfs-pvc
      - name: mysql-conf
        configMap:
          name: mysql-slave-02-cm
          items:
          - key: my.cnf
            mode: 0644
            path: my.cnf
EOF

应用slave-02/mysql-slave-02.yaml

kubectl apply -f slave-02/mysql-slave-02.yaml

登录到两个从节点的MySQL

kubectl exec -itn deploy-test pod/pod/deploy-mysql-slave-01-0 -- mysql -uroot -p
kubectl exec -itn deploy-test pod/pod/deploy-mysql-slave-02-0 -- mysql -uroot -p

在两个从节点分别执行主从同步的命令

1. 设置主从同步的参数
// master_host = pod name + service name + namespace + '.svc.cluster.local'
change master to \
    master_host='deploy-mysql-master-0.deploy-mysql-master-svc.deploy-test.svc.cluster.local', \
    master_port=3306, \
    master_user='root', \
    master_password='root', \
    master_log_file='master-bin.000003', \
    master_log_pos=157, \
    master_connect_retry=30, \
    get_master_public_key=1;
   
2. 开启主从同步 
start slave;

3.查看节点状态
show master status; // 主节点
show slave status\G; // 从节点

验证主从同步

在主节点创建数据库xiaohh_user;
创建数据表
插入数据

weixin_42500998

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
k8s搭建MySQL主从同步

11. 为第一个从节点创建pv，pvc。
复制链接

扫一扫

k8s搭建MySQL主从同步

env

“相关推荐”对你有帮助么？