快捷導(dǎo)航

KubeSphere部署mysql的詳細(xì)步驟

更新時(shí)間：2024年10月14日 10:22:08 作者：Try:

本文介紹了在KubeSphere中部署Mysql的詳細(xì)步驟,包括創(chuàng)建mysql配置、pvc掛載、工作負(fù)載、服務(wù),并測(cè)試數(shù)據(jù)庫(kù)連接,步驟詳盡,包括yaml配置和環(huán)境變量設(shè)置,特別強(qiáng)調(diào)了路徑一致性和外部訪問(wèn)設(shè)置,還提到了使用NodePort模式解決自定義域名連接問(wèn)題

1.創(chuàng)建mysql基礎(chǔ)配置

項(xiàng)目中-配置-配置字典

mysql-conf

添加鍵值對(duì)

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
init_connect='SET collation_connection = utf8mb4_unicode_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
skip-name-resolve

貼一下yaml配置

kind: ConfigMap
apiVersion: v1
metadata:
  name: mysql-conf
  namespace: gitee
  annotations:
    kubesphere.io/creator: admin
data:
  my.cnf: |
    [client]
    default-character-set=utf8mb4
    [mysql]
    default-character-set=utf8mb4
    [mysqld]
    init_connect='SET collation_connection = utf8mb4_unicode_ci'
    init_connect='SET NAMES utf8mb4'
    character-set-server=utf8mb4
    collation-server=utf8mb4_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve

2.創(chuàng)建pvc掛載

項(xiàng)目-存儲(chǔ)-持久卷聲明

mysql-pvc

方式就選擇默認(rèn)
訪問(wèn)模式：?jiǎn)喂?jié)點(diǎn)讀寫
大小：根據(jù)自己需要的數(shù)值增加，這里選擇的是1Gb

然后直接下一步創(chuàng)建即可

yaml配置

kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: mysql-pvc
  namespace: gitee
  annotations:
    kubesphere.io/creator: admin
  finalizers:
    - kubernetes.io/pvc-protection
spec:
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 1Gi
  storageClassName: local
  volumeMode: Filesystem

3.創(chuàng)建工作負(fù)載

應(yīng)用負(fù)載-工作負(fù)載
名稱：

mysql

添加容器使用的是本地私有鏡像（私有鏡像使用的是harbor，也可以使用其他鏡像配置比較簡(jiǎn)單這里不詳細(xì)說(shuō)）

使用默認(rèn)鏡像端口并且同步主機(jī)時(shí)區(qū)

添加環(huán)境變量
設(shè)置數(shù)據(jù)庫(kù)密碼
MYSQL_ROOT_PASSWORD

首先掛載pvc做數(shù)據(jù)持久化
選擇我們一開始創(chuàng)建的pvc
模式：讀寫
路徑：/var/lib/mysql

注意：路徑要一致不能錯(cuò)?。?！

掛載配置文件
選擇本教程最開始創(chuàng)建的字典數(shù)值
模式：只讀
路徑：/etc/mysql/conf.d

注意：路徑要一致不能錯(cuò)！?。?/p>

下一步直接創(chuàng)建即可（如果創(chuàng)建失敗請(qǐng)檢查鏡像是否能正常拉?。?/p>

yaml配置

kind: Deployment
apiVersion: apps/v1
metadata:
  name: mysql
  namespace: gitee
  labels:
    app: mysql
  annotations:
    deployment.kubernetes.io/revision: '1'
    kubesphere.io/creator: admin
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      creationTimestamp: null
      labels:
        app: mysql
      annotations:
        kubesphere.io/creator: admin
        kubesphere.io/imagepullsecrets: '{"container-hrnhuh":"harbor"}'
        logging.kubesphere.io/logsidecar-config: '{}'
    spec:
      volumes:
        - name: host-time
          hostPath:
            path: /etc/localtime
            type: ''
        - name: volume-ve0oq2
          persistentVolumeClaim:
            claimName: mysql-pvc
        - name: volume-lg3r9w
          configMap:
            name: mysql-conf
            defaultMode: 420
      containers:
        - name: container-hrnhuh
          image: '192.168.21.234:81/tools/mysql:8.0.3'
          ports:
            - name: tcp-3306
              containerPort: 3306
              protocol: TCP
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: '123456'
          resources:
            limits:
              cpu: '1'
              memory: 1Gi
            requests:
              cpu: '1'
              memory: 1Gi
          volumeMounts:
            - name: host-time
              readOnly: true
              mountPath: /etc/localtime
            - name: volume-ve0oq2
              mountPath: /var/lib/mysql
            - name: volume-lg3r9w
              readOnly: true
              mountPath: /etc/mysql/conf.d
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          imagePullPolicy: IfNotPresent
      restartPolicy: Always
      terminationGracePeriodSeconds: 30
      dnsPolicy: ClusterFirst
      serviceAccountName: default
      serviceAccount: default
      securityContext: {}
      imagePullSecrets:
        - name: harbor
      schedulerName: default-scheduler
  strategy:
    type: RollingUpdate
    rollingUpdate:
      maxUnavailable: 25%
      maxSurge: 25%
  revisionHistoryLimit: 10
  progressDeadlineSeconds: 600

4.創(chuàng)建服務(wù)（創(chuàng)建服務(wù)后才能進(jìn)行外部訪問(wèn)）

工作負(fù)載-服務(wù)-指定工作負(fù)載

訪問(wèn)模式：虛擬ip地址
工作負(fù)載：選擇剛剛創(chuàng)建的mysql
端口：名字自己填寫容器端口3306 服務(wù)端口3306

勾選外部訪問(wèn)并且選擇NodePort模式

創(chuàng)建成功后這里的端口數(shù)據(jù)庫(kù)連接的時(shí)候會(huì)用到

5.測(cè)試mysql是否能正常訪問(wèn)

服務(wù)器地址：集群ip
端口：剛剛創(chuàng)建成功后的對(duì)外端口
數(shù)據(jù)庫(kù)：sys
用戶名：root
密碼：創(chuàng)建工作負(fù)載時(shí)設(shè)置的MYSQL_ROOT_PASSWORD值，當(dāng)時(shí)設(shè)置的是123456 所以這里就用123456登錄（如果忘記就去工作負(fù)載里找）