K8S快速部署mysql 集群

helm install my-mysql-cluster oci://registry-1.docker.io/bitnamicharts/mysql --set global.storageClass=nfspath --set architecture=replication --set secondary.replicaCount=2 --set primary.resources.requests.cpu="500m" --set secondary.resources.requests.memory="500Mi"


helm install my-mysql-cluster 
oci://registry-1.docker.io/bitnamicharts/mysql 
--set global.storageClass=nfspath #这里填写自己创建的sc
--set architecture=replication  #多实例模式   primary为主  
--set secondary.replicaCount=2 #2个副本及1主2从
--set primary.resources.requests.cpu="500m" 
--set secondary.resources.requests.memory="500Mi"

部署成功后执行

  echo Username: root  #先将ｍｙｓｑｌ密码写入环境变量中
  MYSQL_ROOT_PASSWORD=$(kubectl get secret --namespace default my-mysql-cluster -o jsonpath="{.data.mysql-root-password}" | base64 -d)

To connect to your database:

  1. Run a pod that you can use as a client:

      kubectl run my-mysql-cluster-client --rm --tty -i --restart='Never' --image  docker.io/bitnami/mysql:8.0.36-debian-12-r8 --namespace default --env MYSQL_ROOT_PASSWORD=$MYSQL_ROOT_PASSWORD --command -- bash

  2. To connect to primary service (read/write):

      mysql -h my-mysql-cluster-primary.default.svc.cluster.local -uroot -p"$MYSQL_ROOT_PASSWORD"

  3. To connect to secondary service (read-only):

      mysql -h my-mysql-cluster-secondary.default.svc.cluster.local -uroot -p"$MYSQL_ROOT_PASSWORD"