快捷導(dǎo)航

使用Kubernetes集群環(huán)境部署MySQL數(shù)據(jù)庫的實(shí)戰(zhàn)記錄

更新時間：2022年05月27日 11:33:01 作者：Redrose2100

這篇文章主要介紹了使用Kubernetes集群環(huán)境部署MySQL數(shù)據(jù)庫，主要包括編寫 mysql.yaml文件，執(zhí)行如下命令創(chuàng)建，通過相關(guān)命令查看創(chuàng)建結(jié)果,對Kubernetes部署MySQL數(shù)據(jù)庫的過程感興趣的朋友一起看看吧

1 編寫 mysql.yaml文件
2 執(zhí)行如下命令創(chuàng)建
3 通過如下命令查看創(chuàng)建結(jié)果
4 命令行進(jìn)入Pod并登錄mysql
5 至此，數(shù)據(jù)庫已經(jīng)安裝完成，然后即可通過ip+端口，這里是30001，進(jìn)行數(shù)據(jù)庫鏈接了

1 編寫 mysql.yaml文件

編寫yaml如下

apiVersion: v1
kind: Namespace
metadata:
  name: devops   # Namespace 的名稱
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: devops-mysql   # deployment控制器名稱
  namespace: devops
spec:
  replicas: 1
  revisionHistoryLimit: 5
  strategy:
    type: RollingUpdate
  selector:
    matchLabels:
      app: devops-mysql
  template:
    metadata:
      labels:
        app: devops-mysql
    spec:
      volumes:
        - name: devops-mysql
          nfs:
            server: xx.xx.xx.xx  # 修改為掛載存儲的服務(wù)器ip
            path: /root/data/nfs/mysql/devops   # 修改為存儲服務(wù)器的存儲掛載路徑
      containers:
        - name: devops-mysql
          image: mysql:5.7
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: xxxxxxxx     # 設(shè)置MySQL數(shù)據(jù)庫登錄密碼
          imagePullPolicy: Always
          ports:
            - containerPort: 3306
          volumeMounts:
            - name: devops-mysql
              mountPath: /var/lib/mysql
---
apiVersion: v1
kind: Service
metadata:
  name: devops-mysql    # 數(shù)據(jù)庫服務(wù)的名稱
  namespace: devops
spec:
  ports:
    - port: 3306
      protocol: TCP
      targetPort: 3306
      nodePort: 30001    # 對外訪問的端口
  selector:
    app: devops-mysql
  type: NodePort
  sessionAffinity: ClientIP

2 執(zhí)行如下命令創(chuàng)建

kubectl apply -f mysql.yaml

3 通過如下命令查看創(chuàng)建結(jié)果

使用如下命令查看

kubectl get pod -n devops | grep mysql

如：

[root@master ~]# kubectl get pod -n devops | grep mysql
devops-mysql-59b68c47d4-ttbng               1/1     Running   0          23h
[root@master ~]#

4 命令行進(jìn)入Pod并登錄mysql

如下;

[root@master ~]# kubectl exec -it devops-mysql-59b68c47d4-ttbng bash -n devops
kubectl exec [POD] [COMMAND] is DEPRECATED and will be removed in a future version. Use kubectl exec [POD] -- [COMMAND] instead.
root@devops-mysql-59b68c47d4-ttbng:/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.01 sec)

mysql>