环境主节点:172.19.2.50
从节点:
172.19.2.51
172.19.2.140
部署完成后通过各节点的30336端口访问mysql账号root,密码abcd1234
如:
mysql -h 172.19.2.50 -P 30336 -uroot -pabcd1234
部署完成后通过galera可以让集群3个节点间的数据一致
容器内访问mysql时,可以通过所有k8s节点的30336端口访问,也可以使用k8s服务中的内部入口访问,如mysql.mysql:3306,dns会自动解析mysql.mysql到对应的服务集群
一、在主节点创建目录mkdir -pv /mysql_data/datadir-mariadb-0
mkdir -pv /mysql_data/datadir-mariadb-1
mkdir -pv /mysql_data/datadir-mariadb-2
二、修改部署文件cd /opt/kubernetes-mysql-cluster
命名空间部署文件vim 00namespace.yml
---
apiVersion: v1
kind: Namespace
metadata:
name: mysql
pvc部署文件vim 10pvc.yml
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
name: mysql-mariadb-0
namespace: mysql
spec:
accessModes:
- ReadWriteOnce#这里为pvc的访问模式
resources:
requests:
storage: 10Gi#这里调整要挂载的pvc大小
selector:
matchLabels:#这里要和pv的标签对应
app: mariadb
podindex: "0"
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
name: mysql-mariadb-1
namespace: mysql
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
selector:
matchLabels:
app: mariadb
podindex: "1"
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
name: mysql-mariadb-2
namespace: mysql
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
selector:
matchLabels:
app: mariadb
podi