ITPub博客

首页 > 数据库 > MySQL > kubernetes使用StatefulSet部署mysql一主多从

kubernetes使用StatefulSet部署mysql一主多从

原创 MySQL 作者:口壤迅坎 时间:2020-11-30 14:57:26 0 删除 编辑

  有状态服务一般数据需要永久保存,先创建动态存储卷(这里存储使用nfs)

  rabc文件

  (base)[root nlp-test-server-no~]#cat nfs-rbac.yaml

  apiVersion:v1

  kind:ServiceAccount

  metadata:

  name:nfs-client-provisioner

  namespace:default

  ---

  kind:ClusterRole

  apiVersion:rbac.authorization.k8s.io/v1

  metadata:

  name:nfs-client-provisioner-runner

  rules:

  -apiGroups:[""]

  resources:["persistentvolumes"]

  verbs:["get","list","watch","create","delete"]

  -apiGroups:[""]

  resources:["persistentvolumeclaims"]

  verbs:["get","list","watch","update"]

  -apiGroups:["storage.k8s.io"]

  resources:["storageclasses"]

  verbs:["get","list","watch"]

  -apiGroups:[""]

  resources:["events"]

  verbs:["list","watch","create","update","patch"]

  -apiGroups:[""]

  resources:["endpoints"]

  verbs:["create","delete","get","list","watch","patch","update"]

  ---

  kind:ClusterRoleBinding

  apiVersion:rbac.authorization.k8s.io/v1

  metadata:

  name:run-nfs-client-provisioner

  subjects:

  -kind:ServiceAccount

  name:nfs-client-provisioner

  namespace:default

  roleRef:

  kind:ClusterRole

  name:nfs-client-provisioner-runner

  apiGroup:rbac.authorization.k8s.io

  StorageClass文件

  (base)[root nlp-test-server-no~]#cat nfs-storageclass.yaml

  apiVersion:storage.k8s.io/v1

  kind:StorageClass

  metadata:

  name:course-nfs-storage

  namespace:default

  provisioner:fuseim.pri/ifs

  nfs-provisioner文件

  (base)[root nlp-test-server-no~]#cat nfs-provisioner.yaml

  kind:Deployment

  apiVersion:extensions/v1beta1

  metadata:

  name:nfs-client-provisioner

  namespace:default

  spec:

  replicas:1

  strategy:

  type:Recreate

  template:

  metadata:

  labels:

  app:nfs-client-provisioner

  spec:

  serviceAccountName:nfs-client-provisioner

  containers:

  -name:nfs-client-provisioner

  image:quay.io/external_storage/nfs-client-provisioner:latest

  volumeMounts:

  -name:nfs-client-root

  mountPath:/persistentvolumes

  env:

  -name:PROVISIONER_NAME

  value:fuseim.pri/ifs

  -name:NFS_SERVER

  value:172.31.243.224#这里写nfs服务器地址

  -name:NFS_PATH

  value:/home/k8s/data#nfs共享目录

  volumes:

  -name:nfs-client-root

  nfs:

  server:172.31.243.224#这里写nfs服务器地址

  path:/home/k8s/data#nfs共享目录

  至此动态存储卷创建好了,开始部署mysql集群

  StatefulSet文件

  (base)[root nlp-test-server-no~]#cat mysql.yaml

  apiVersion:apps/v1

  kind:StatefulSet

  metadata:

  name:mysql

  namespace:default

  spec:

  selector:

  matchLabels:

  app:mysql

  serviceName:mysql

  replicas:3

  template:

  metadata:

  labels:

  app:mysql

  spec:

  initContainers:

  -name:init-mysql

  image:mysql:5.7

  command:

  -bash

  -"-c"

  -|

  set-ex

  #Generate mysql server-id from pod ordinal index.

  [[`hostname`=~-([0-9]+)$]]||exit 1

  ordinal=${BASH_REMATCH[1]}

  echo[mysqld]>/mnt/conf.d/server-id.cnf

  #Add an offset to avoid reserved server-id=0 value.

  echo server-id=$((100+$ordinal))>>/mnt/conf.d/server-id.cnf

  #Copy appropriate conf.d files from config-map to emptyDir.

  if[[$ordinal-eq 0]];then

  cp/mnt/config-map/master.cnf/mnt/conf.d/

  else

  cp/mnt/config-map/slave.cnf/mnt/conf.d/

  fi

  volumeMounts:

  -name:conf

  mountPath:/mnt/conf.d

  -name:config-map

  mountPath:/mnt/config-map

  -name:clone-mysql

  image:ist0ne/xtrabackup:1.0

  command:

  -bash

  -"-c"

  -|

  set-ex

  #Skip the clone if data already exists.

  [[-d/var/lib/mysql/mysql]]&&exit 0

  #Skip the clone on master(ordinal index 0).

  [[`hostname`=~-([0-9]+)$]]||exit 1

  ordinal=${BASH_REMATCH[1]}

  [[$ordinal-eq 0]]&&exit 0

  #Clone data from previous peer.

  ncat--recv-only mysql-$(($ordinal-1)).mysql 3307|xbstream-x-C/var/lib/mysql

  #Prepare the backup.

  xtrabackup--prepare--target-dir=/var/lib/mysql

  volumeMounts:

  -name:data

  mountPath:/var/lib/mysql

  subPath:mysql

  -name:conf

  mountPath:/etc/mysql/conf.d

  containers:

  -name:mysql

  image:mysql:5.7

  env:

  -name:MYSQL_ALLOW_EMPTY_PASSWORD

  value:"1"

  ports:

  -name:mysql

  containerPort:3306

  volumeMounts:

  -name:data

  mountPath:/var/lib/mysql

  subPath:mysql

  -name:conf

  mountPath:/etc/mysql/conf.d

  resources:

  requests:

  cpu:500m

  memory:1Gi

  livenessProbe:

  exec:

  command:["mysqladmin","ping"]

  initialDelaySeconds:30

  periodSeconds:10

  timeoutSeconds:5

  readinessProbe:

  exec:

  #Check we can execute queries over TCP(skip-networking is off).

  command:["mysql","-h","127.0.0.1","-e","SELECT 1"]

  initialDelaySeconds:5

  periodSeconds:2

  timeoutSeconds:1

  -name:xtrabackup

  image:ist0ne/xtrabackup:1.0

  ports:

  -name:xtrabackup

  containerPort:3307

  command:

  -bash

  -"-c"

  -|

  set-ex

  cd/var/lib/mysql

  #Determine binlog position of cloned data,if any.

  if[[-f xtrabackup_slave_info&&"x$(<xtrabackup_slave_info)"!="x"]];then

  #XtraBackup already generated a partial"CHANGE MASTER TO"query

  #because we're cloning from an existing slave.(Need to remove the tailing semicolon!)

  cat xtrabackup_slave_info|sed-E's/;$//g'>change_master_to.sql.in

  #Ignore xtrabackup_binlog_info in this case(it's useless).

  rm-f xtrabackup_slave_info xtrabackup_binlog_info

  elif[[-f xtrabackup_binlog_info]];then

  #We're cloning directly from master.Parse binlog position.

  [[`cat xtrabackup_binlog_info`=~^(.*?)[[:space:]]+(.*?)$]]||exit 1

  rm-f xtrabackup_binlog_info xtrabackup_slave_info

  echo"CHANGE MASTER TO MASTER_LOG_FILE='${BASH_REMATCH[1]}',

  MASTER_LOG_POS=${BASH_REMATCH[2]}">change_master_to.sql.in

  fi

  #Check if we need to complete a clone by starting replication.

  if[[-f change_master_to.sql.in]];then

  echo"Waiting for mysqld to be ready(accepting connections)"

  until mysql-h 127.0.0.1-e"SELECT 1";do sleep 1;done

  echo"Initializing replication from clone position"

  mysql-h 127.0.0.1

  -e"$(<change_master_to.sql.in),

  MASTER_HOST='mysql-0.mysql',

  MASTER_USER='root',

  MASTER_PASSWORD='',

  MASTER_CONNECT_RETRY=10;

  START SLAVE;"||exit 1

  #In case of container restart,attempt this at-most-once.

  mv change_master_to.sql.in change_master_to.sql.orig

  fi

  #Start a server to send backups when requested by peers.

  exec ncat--listen--keep-open--send-3307-c

  "xtrabackup--backup--slave-info--stream=xbstream--host=127.0.0.1--user=root"

  volumeMounts:

  -name:data

  mountPath:/var/lib/mysql

  subPath:mysql

  -name:conf

  mountPath:/etc/mysql/conf.d

  resources:

  requests:

  cpu:100m

  memory:100Mi

  volumes:

  -name:conf

  emptyDir:{}

  -name:config-map

  configMap:

  name:mysql

  volumeClaimTemplates:

  -metadata:

  name:data

  namespace:default

  annotations:

  volume.beta.kubernetes.io/storage-class:"course-nfs-storage"

  spec:

  accessModes:["ReadWriteOnce"]

  resources:

  requests:

  storage:1Gi

  server文件

  (base)[root nlp-test-server-no~]#cat mysql_server.yaml

  #Headless service for stable DNS entries of StatefulSet members.

  apiVersion:v1

  kind:Service

  metadata:

  name:mysql

  namespace:default

  labels:

  app:mysql

  spec:

  ports:

  -name:mysql

  port:3306

  clusterIP:None

  selector:

  app:mysql

  ---

  #Client service for connecting to any MySQL instance for reads.

  #For writes,you must instead connect to the master:mysql-0.mysql.

  apiVersion:v1

  kind:Service

  metadata:

  name:mysql-read

  namespace:default

  labels:

  app:mysql

  spec:

  ports:

  -name:mysql

  port:3306

  selector:

  app:mysql


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69920894/viewspace-2738147/,如需转载,请注明出处,否则将追究法律责任。

上一篇: grep跨行匹配
请登录后发表评论 登录
全部评论

注册时间:2020-09-21

  • 博文量
    11
  • 访问量
    4300