Kubernetes（簡稱K8s）是現(xiàn)代化DevOps架構(gòu)的代表之一，而MySQL在Web應(yīng)用開發(fā)中占據(jù)了重要地位。使用K8s管理MySQL，能夠快速部署、快速升級(jí)、高可用、高性能，提高M(jìn)ySQL的運(yùn)維效率。

下面介紹如何使用K8s進(jìn)行MySQL運(yùn)維。

K8s MySQL運(yùn)維步驟

1. 創(chuàng)建配置文件

apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-config
data:
# MySQL配置文件
my.cnf: |
[mysqld]
server-id=1
log-bin=mysql-bin
binlog-format=ROW
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
sql_mode="NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES"

2. 創(chuàng)建MySQL服務(wù)

apiVersion: v1
kind: Service
metadata:
name: mysql-service
spec:
ports:
- name: mysql-port
port: 3306
targetPort: 3306
selector:
app: mysql

3. 創(chuàng)建MySQL Pod

apiVersion: v1
kind: Pod
metadata:
name: mysql-pod
spec:
containers:
- name: mysql
image: mysql:5.7
ports:
- containerPort: 3306
env:
- name: MYSQL_ROOT_PASSWORD
value: "123456"
volumeMounts:
- name: mysql-persistent-storage
mountPath: /var/lib/mysql
- name: mysql-config
mountPath: /etc/mysql/conf.d/my.cnf
subPath: my.cnf
volumes:
- name: mysql-persistent-storage
persistentVolumeClaim:
claimName: mysql-pv-claim
- name: mysql-config
configMap:
name: mysql-config

4. 創(chuàng)建MySQL數(shù)據(jù)卷

apiVersion: v1
kind: PersistentVolume
metadata:
name: mysql-pv
spec:
capacity:
storage: 5Gi
accessModes:
- ReadWriteOnce
hostPath:
path: /data/mysql-pv/
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
name: mysql-pv-claim
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 5Gi

K8s MySQL運(yùn)維總結(jié)

使用K8s進(jìn)行MySQL運(yùn)維，除了能夠?qū)崿F(xiàn)快速部署、快速升級(jí)、高可用、高性能之外，還可以實(shí)現(xiàn)靈活的擴(kuò)容、靈活的存儲(chǔ)，避免了傳統(tǒng)的手動(dòng)運(yùn)維帶來的不便，提高了MySQL運(yùn)維效率。