k8s下部署mysql(nfs存储,配置文件采用ConfigMap的方式)

环境:
Os:Centos 7
mysql:5.7

############################nfs配置################################
1.安装nfs
yum install -y nfs-utils rpcbind

 

2.创建mysql相应目录
mkdir -p /data/nfs/mysql/data
mkdir -p /data/nfs/mysql/mysqllog/binlog
mkdir -p /data/nfs/mysql/mysqllog/logfile
mkdir -p /data/nfs/mysql/mysqllog/relaylog
mkdir -p /data/nfs/mysql/mysql-files

 

3.授权权限
chmod -R 755 /data/nfs/mysql/data
chmod -R 755 /data/nfs/mysql/mysqllog
chmod -R 755 /data/nfs/mysql/mysql-files
chown -R 999:999 /data/nfs/mysql

4.配置 NFS 共享
echo "/data/nfs/mysql *(rw,sync,no_root_squash,no_all_squash)" >> /etc/exports

 

5.启动服务
systemctl enable rpcbind nfs-server
systemctl restart rpcbind
systemctl restart nfs-server

 

6.验证
showmount -e localhost

 

###################################k8s部署#############################

1.打标签
k8s master节点上执行
kubectl get nodes
kubectl label nodes test-k8s-192.168.1.162 mysql=allowed
kubectl get nodes --show-labels

 

2.各组件yaml文件
cd /root/hxl/mysql_single
1-namespace.yaml

apiVersion: v1
kind: Namespace
metadata:name: mysql

 

2-configmap.yaml

apiVersion: v1
kind: ConfigMap
metadata:name: cm-mysql-confignamespace: mysql
data:my.cnf: |[mysqld]datadir=/var/lib/mysqlsocket=/var/run/mysqld/mysqld.sockdefault-storage-engine=INNODBmax_connections=1000init_connect='SET collation_connection = utf8mb4_general_ci'init_connect='SET NAMES utf8mb4'interactive_timeout=86400wait_timeout=86400max_connections = 5000character-set-server=utf8mb4collation-server=utf8mb4_general_ciskip-character-set-client-handshakeskip-name-resolveserver_id=1replicate-ignore-db=mysqlreplicate-ignore-db=sysreplicate-ignore-db=information_schemareplicate-ignore-db=performance_schemagtid_mode=ONenforce_gtid_consistency = ONlower_case_table_names=1sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'# binloglog_bin=/var/log/mysql/binlog/mysql-binbinlog_format=ROWexpire_logs_days=7sync_binlog=1# slow queryslow_query_log=1slow_query_log_file=/var/log/mysql/logfile/slow-query.loglong_query_time=2##relay-logrelay-log-index=/var/log/mysql/relaylog/slave-relay-bin.indexrelay-log=/var/log/mysql/relaylog/relaylog-binloglog-error=/var/log/mysql/logfile/mysql-err.logsecure_file_priv=/var/lib/mysql-files

 

3-pv.yaml

apiVersion: v1
kind: PersistentVolume
metadata:name: pv-mysql
spec:capacity:storage: 5GiaccessModes:- ReadWriteOncenfs:server: 192.168.1.134path: /data/nfs/mysqlpersistentVolumeReclaimPolicy: Retain

 

4-pvc.yaml

apiVersion: v1
kind: PersistentVolumeClaim
metadata:name: pvc-mysqlnamespace: mysql
spec:accessModes:- ReadWriteOnceresources:requests:storage: 5GivolumeName: pv-mysqlstorageClassName: ""

 

5-headless.yaml

apiVersion: v1
kind: Service
metadata:name: mysql-headlessnamespace: mysql
spec:clusterIP: Noneports:- port: 3306targetPort: 3306name: redisselector:app: mysql

 

6-statefulset.yaml

apiVersion: apps/v1
kind: StatefulSet
metadata:name: mysqlnamespace: mysql
spec:serviceName: mysql-headlessreplicas: 1selector:matchLabels:app: mysqltemplate:metadata:labels:app: mysqlspec:nodeSelector:mysql: allowedcontainers:- name: mysqlimage: registry.cn-shenzhen.aliyuncs.com/hxlk8s/mysql:5.7.30ports:- containerPort: 3306env:- name: MYSQL_ROOT_PASSWORDvalue: "123456"- name: TZvalue: Asia/ShanghaivolumeMounts:- name: mysql-datamountPath: /var/lib/mysqlsubPath: data- name: mysql-datamountPath: /var/log/mysqlsubPath: mysqllog- name: mysql-datamountPath: /var/lib/mysql-filessubPath: mysql-files# 挂载 ConfigMap 配置文件- name: mysql-configmountPath: /etc/mysql/my.cnfsubPath: my.cnfvolumes:- name: mysql-datapersistentVolumeClaim:claimName: pvc-mysql- name: mysql-configconfigMap:name: cm-mysql-config

 

7-nodeport.yaml

apiVersion: v1
kind: Service
metadata:name: mysqlnamespace: mysql
spec:type: NodePortports:- port: 3306targetPort: 3306nodePort: 30006selector:app: mysql

 

3.部署
cd /root/hxl/mysql_single
kubectl apply -f 1-namespace.yaml
kubectl apply -f 2-configmap.yaml
kubectl apply -f 3-pv.yaml
kubectl apply -f 4-pvc.yaml
kubectl apply -f 5-headless.yaml
kubectl apply -f 6-statefulset.yaml
kubectl apply -f 7-nodeport.yaml

kubectl get pods -n mysql
kubectl logs mysql-0 -n mysql
kubectl describe pods mysql-0 -n mysql

 

4.查看svc

[root@yunwei-k8s-master1-test mysql_single]# kubectl get svc -n mysql
NAME             TYPE        CLUSTER-IP      EXTERNAL-IP   PORT(S)          AGE
mysql            NodePort    10.17.183.227   <none>        3306:30006/TCP   75s
mysql-headless   ClusterIP   None            <none>        3306/TCP         32m

 

5.k8s外连接
/opt/mysql57/bin/mysql -h 192.168.1.162 -p123456 -P30006

 

6.登录pod
kubectl exec -it mysql-0 -n mysql -- bash
root@mysql-0:/# hostname -f
mysql-0.mysql-headless.mysql.svc.cluster.local
root@mysql-0:/# hostname -i
10.10.10.70