怎么在k8s上部署mysql 8.0 MGR

53次阅读
没有评论

共计 12975 个字符,预计需要花费 33 分钟才能阅读完成。

本篇内容介绍了“怎么在 k8s 上部署 mysql 8.0 MGR”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让丸趣 TV 小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!

一。环境概述

  k8s 环境:1 台 master 节点,3 台 node 节点。

  在三个节点上搭建 MGR 集群。mysql 的数据文件是挂载在本地存储,在镜像制作完成后,需要把初始化后的数据文件 copy 到三个节点本地的挂载点 /data/mysql/data/,另外需要修改 auto.cnf 里面的 uuid,让三个节点的 uuid 不同。

二。搭建步骤

制作 mysql 8.0.15 镜像

此步骤略过,参照 mysql 官方的二进制包安装步骤,
https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html。
  安装完毕后制作成镜像。

准备生成三个节点 pod 的相关 yaml 文件。

— 创建 namespace 的文件 namespace.yaml:

apiVersion: v1
kind: Namespace
metadata:
  name: mysqldb

— 节点 1 的 configmap 文件 mysql-mgr-cnf-0.yaml:

apiVersion: v1
data:
  mysql-mgr-0.cnf: |
  [mysqld]
  port = 3306
  character_set_server = utf8
  socket = /tmp/mysql.sock
  basedir = /usr/local/mysql
  log-error = /data/mysql/data/mysql.err
  pid-file = /data/mysql/data/mysql.pid
  datadir = /data/mysql/data
  server_id = 092832
  log_bin = mysql-bin
  relay-log = relay-bin
  #back_log = 500
  #max_connections = 3000
  #wait_timeout = 5022397
  interactive_timeout = 5022397
  max_connect_errors = 1000
  relay-log-recovery=1
  #max_allowed_packet = 32M
  sort_buffer_size = 4M
  read_buffer_size = 4M
  join_buffer_size = 8M
  thread_cache_size = 64
  #tmp_table_size = 256M
  log_slave_updates=1
  long_query_time = 1
  slow_query_log = 1
  slow_query_log_file = /data/mysql/data/slow_sql.log
  skip-name-resolve
  sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  innodb_buffer_pool_size=700M
  #innodb_data_file_path = ibdata1:1024M:autoextend
  innodb_flush_log_at_trx_commit=1
  innodb_log_buffer_size = 16M
  innodb_log_file_size = 256M
  innodb_log_files_in_group = 2
  innodb_max_dirty_pages_pct = 50
  sync_binlog=1
  master_info_repository=TABLE
  relay_log_info_repository=TABLE
  log_timestamps=SYSTEM
  gtid_mode = ON
  enforce_gtid_consistency = ON
  master_info_repository = TABLE
  relay_log_info_repository = TABLE
  log_slave_updates = ON
  binlog_checksum = NONE
  log_slave_updates = ON
  slave_parallel_type=LOGICAL_CLOCK
  slave_parallel_workers=8
  slave-preserve-commit-order=on
  #group_replication_compression_threshold=200000
  transaction_write_set_extraction = XXHASH64
  loose-group_replication_group_name= 01e5fb97-be64-41f7-bafd-3afc7a6ab555
  loose-group_replication_start_on_boot=off
  loose-group_replication_local_address= mysql-mgr-0.mgrtest.mysqldb.svc.cluster.local.:13306
  loose-group_replication_group_seeds= mysql-mgr-0.mgrtest.mysqldb.svc.cluster.local.:13306,mysql-mgr-1.mgrtest.mysqldb.svc.cluster.local.:13306,mysql-mgr-2.mgrtest.mysqldb.svc.cluster.local.:13306
  loose-group_replication_bootstrap_group = off
  loose-group_replication_ip_whitelist= 10.244.0.0/16,172.17.0.0/16,10.229.0.0/16,10.228.0.0/16
  report_host = mysql-mgr-0.mgrtest.mysqldb.svc.cluster.local
  [mysqldump]
  quick
  max_allowed_packet = 32M
kind: ConfigMap
metadata:
  name: mysql-mgr-0-cnf
  namespace: mysqldb

— 节点 2 的 configmap 文件 mysql-mgr-cnf-1.yaml:

apiVersion: v1
data:
  mysql-mgr-1.cnf: |
  [mysqld]
  port = 3306
  character_set_server = utf8
  socket = /tmp/mysql.sock
  basedir = /usr/local/mysql
  log-error = /data/mysql/data/mysql.err
  pid-file = /data/mysql/data/mysql.pid
  datadir = /data/mysql/data
  server_id = 092231
  log_bin = mysql-bin
  relay-log = relay-bin
  #back_log = 500
  #max_connections = 3000
  #wait_timeout = 5022397
  interactive_timeout = 5022397
  max_connect_errors = 1000
  relay-log-recovery=1
  #max_allowed_packet = 32M
  sort_buffer_size = 4M
  read_buffer_size = 4M
  join_buffer_size = 8M
  thread_cache_size = 64
  #tmp_table_size = 256M
  log_slave_updates=1
  long_query_time = 1
  slow_query_log = 1
  slow_query_log_file = /data/mysql/data/slow_sql.log
  skip-name-resolve
  sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  innodb_buffer_pool_size=700M
  #innodb_data_file_path = ibdata1:1024M:autoextend
  innodb_flush_log_at_trx_commit=1
  innodb_log_buffer_size = 16M
  innodb_log_file_size = 256M
  innodb_log_files_in_group = 2
  innodb_max_dirty_pages_pct = 50
  sync_binlog=1
  master_info_repository=TABLE
  relay_log_info_repository=TABLE
  log_timestamps=SYSTEM
  gtid_mode = ON
  enforce_gtid_consistency = ON
  master_info_repository = TABLE
  relay_log_info_repository = TABLE
  log_slave_updates = ON
  binlog_checksum = NONE
  log_slave_updates = ON
  slave_parallel_type=LOGICAL_CLOCK
  slave_parallel_workers=8
  slave-preserve-commit-order=on
  #group_replication_compression_threshold=200000
  transaction_write_set_extraction = XXHASH64
  loose-group_replication_group_name= 01e5fb97-be64-41f7-bafd-3afc7a6ab555
  loose-group_replication_start_on_boot=off
  loose-group_replication_local_address= mysql-mgr-1.mgrtest.mysqldb.svc.cluster.local.:13306
  loose-group_replication_group_seeds= mysql-mgr-0.mgrtest.mysqldb.svc.cluster.local.:13306,mysql-mgr-1.mgrtest.mysqldb.svc.cluster.local.:13306,mysql-mgr-2.mgrtest.mysqldb.svc.cluster.local.:13306
  loose-group_replication_bootstrap_group = off
  loose-group_replication_ip_whitelist= 10.244.0.0/16,172.17.0.0/16,10.229.0.0/16,10.228.0.0/16
  report_host = mysql-mgr-1.mgrtest.mysqldb.svc.cluster.local
  [mysqldump]
  quick
  max_allowed_packet = 32M
kind: ConfigMap
metadata:
  name: mysql-mgr-1-cnf
  namespace: mysqldb

— 节点 3 的 configmap 文件 mysql-mgr-cnf-2.yaml:

apiVersion: v1
data:
  mysql-mgr-2.cnf: |
  [mysqld]
  port = 3306
  character_set_server = utf8
  socket = /tmp/mysql.sock
  basedir = /usr/local/mysql
  log-error = /data/mysql/data/mysql.err
  pid-file = /data/mysql/data/mysql.pid
  datadir = /data/mysql/data
  server_id = 092132
  log_bin = mysql-bin
  relay-log = relay-bin
  #back_log = 500
  #max_connections = 3000
  #wait_timeout = 5022397
  interactive_timeout = 5022397
  max_connect_errors = 1000
  relay-log-recovery=1
  #max_allowed_packet = 32M
  sort_buffer_size = 4M
  read_buffer_size = 4M
  join_buffer_size = 8M
  thread_cache_size = 64
  #tmp_table_size = 256M
  log_slave_updates=1
  long_query_time = 1
  slow_query_log = 1
  slow_query_log_file = /data/mysql/data/slow_sql.log
  skip-name-resolve
  sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  innodb_buffer_pool_size=700M
  #innodb_data_file_path = ibdata1:1024M:autoextend
  innodb_flush_log_at_trx_commit=1
  innodb_log_buffer_size = 16M
  innodb_log_file_size = 256M
  innodb_log_files_in_group = 2
  innodb_max_dirty_pages_pct = 50
  sync_binlog=1
  master_info_repository=TABLE
  relay_log_info_repository=TABLE
  log_timestamps=SYSTEM
  gtid_mode = ON
  enforce_gtid_consistency = ON
  master_info_repository = TABLE
  relay_log_info_repository = TABLE
  log_slave_updates = ON
  binlog_checksum = NONE
  log_slave_updates = ON
  slave_parallel_type=LOGICAL_CLOCK
  slave_parallel_workers=8
  slave-preserve-commit-order=on
  #group_replication_compression_threshold=200000
  transaction_write_set_extraction = XXHASH64
  loose-group_replication_group_name= 01e5fb97-be64-41f7-bafd-3afc7a6ab555
  loose-group_replication_start_on_boot=off
  loose-group_replication_local_address= mysql-mgr-2.mgrtest.mysqldb.svc.cluster.local.:13306
  loose-group_replication_group_seeds= mysql-mgr-0.mgrtest.mysqldb.svc.cluster.local.:13306,mysql-mgr-1.mgrtest.mysqldb.svc.cluster.local.:13306,mysql-mgr-2.mgrtest.mysqldb.svc.cluster.local.:13306
  loose-group_replication_bootstrap_group = off
  loose-group_replication_ip_whitelist= 10.244.0.0/16,172.17.0.0/16,10.229.0.0/16,10.228.0.0/16
  report_host = mysql-mgr-2.mgrtest.mysqldb.svc.cluster.local
  [mysqldump]
  quick
  max_allowed_packet = 32M
kind: ConfigMap
metadata:
  name: mysql-mgr-2-cnf
  namespace: mysqldb

—- 节点 1 的 pod 的 yaml 文件:
apiVersion: v1
kind: Pod
metadata:
  name: mysql-mgr-0
  namespace: mysqldb
  labels:
  name: mysql-mgr
spec:
  affinity:
  nodeAffinity:
  requiredDuringSchedulingIgnoredDuringExecution:
  nodeSelectorTerms:
  – matchExpressions:
  – key: mysqlrole
  operator: In
  values: [mysql-mgr-0]
  hostname: mysql-mgr-0
  subdomain: mgrtest
  containers:
  – image: 172.16.110.102:5000/mysql8.0:latest
  name: mysql-mgr-0
  imagePullPolicy: IfNotPresent
  command: [/bin/bash , -ce , cd /usr/local/mysql bin/mysqld_safe –defaults-file=/etc/my.cnf tail -f /dev/null]
  #env:

  #- name: MYSQL_ROOT_PASSWORD
  #  value: noc-mysql
  ports:
  – containerPort: 3306
  volumeMounts:
  – name: tz-config
  mountPath: /etc/localtime
  – name: mysql-data
  mountPath: /data/mysql/data/
  – name: mysql-config
  mountPath: /etc/my.cnf
  subPath: my.cnf
  env:
  – name: INNODB_BUFFER_POOL_SIZE
  value: 500M
  #- name: REPORT_HOST
  #  value: mysql-mgr-0.mgrtest.mysqldb.svc.cluster.local
  volumes:
  – name: tz-config
  hostPath:
  path: /etc/localtime
  – name: mysql-data
  hostPath:
  path: /data/mysql/data/
  – name: mysql-config
  configMap:
  name: mysql-mgr-0-cnf
  items:
  – key: mysql-mgr-0.cnf
  path: my.cnf
—- 节点 2 的 pod 的 yaml 文件:

apiVersion: v1
kind: Pod
metadata:
  name: mysql-mgr-1
  namespace: mysqldb
  labels:
  name: mysql-mgr
spec:
  affinity:
  nodeAffinity:
  requiredDuringSchedulingIgnoredDuringExecution:
  nodeSelectorTerms:
  – matchExpressions:
  – key: mysqlrole
  operator: In
  values: [mysql-mgr-1]
  hostname: mysql-mgr-1
  subdomain: mgrtest
  containers:
  – image: 172.16.110.102:5000/mysql8.0:latest
  name: mysql-mgr-1
  imagePullPolicy: IfNotPresent
  command: [/bin/bash , -ce , cd /usr/local/mysql bin/mysqld_safe –defaults-file=/etc/my.cnf tail -f /dev/null]
  #env:

  #- name: MYSQL_ROOT_PASSWORD
  #  value: noc-mysql
  ports:
  – containerPort: 3306
  volumeMounts:
  – name: tz-config
  mountPath: /etc/localtime
  – name: mysql-data
  mountPath: /data/mysql/data
  – name: mysql-config
  mountPath: /etc/my.cnf
  subPath: my.cnf
  env:
  – name: INNODB_BUFFER_POOL_SIZE
  value: 500M
  volumes:
  – name: tz-config
  hostPath:
  path: /etc/localtime
  – name: mysql-data
  hostPath:
  path: /data/mysql/data/
  – name: mysql-config
  configMap:
  name: mysql-mgr-1-cnf
  items:
  – key: mysql-mgr-1.cnf
  path: my.cnf

— 节点 3 的 pod 的 yaml 文件:

apiVersion: v1
kind: Pod
metadata:
  name: mysql-mgr-2
  namespace: mysqldb
  labels:
  name: mysql-mgr
spec:
  affinity:
  nodeAffinity:
  requiredDuringSchedulingIgnoredDuringExecution:
  nodeSelectorTerms:
  – matchExpressions:
  – key: mysqlrole
  operator: In
  values: [mysql-mgr-2]
  hostname: mysql-mgr-2
  subdomain: mgrtest
  containers:
  – image: 172.16.110.102:5000/mysql8.0:latest
  name: mysql-mgr-2
  imagePullPolicy: IfNotPresent
  command: [/bin/bash , -ce , cd /usr/local/mysql bin/mysqld_safe –defaults-file=/etc/my.cnf tail -f /dev/null]
  #env:

  #- name: MYSQL_ROOT_PASSWORD
  #  value: noc-mysql
  ports:
  – containerPort: 3306
  volumeMounts:
  – name: tz-config
  mountPath: /etc/localtime
  – name: mysql-data
  mountPath: /data/mysql/data
  – name: mysql-config
  mountPath: /etc/my.cnf
  subPath: my.cnf
  env:
  – name: INNODB_BUFFER_POOL_SIZE
  value: 500M
  volumes:
  – name: tz-config
  hostPath:
  path: /etc/localtime
  – name: mysql-data
  hostPath:
  path: /data/mysql/data/
  – name: mysql-config
  configMap:
  name: mysql-mgr-2-cnf
  items:
  – key: mysql-mgr-2.cnf
  path: my.cnf

— 为三个 pod 创建的 service 的 yaml 文件

apiVersion: v1
kind: Service
metadata:
  name: mgrtest
  namespace: mysqldb
spec:
  selector:
  name: mysql-mgr
  clusterIP:  None
  ports:
  – name:  foo
  port:  3306
  targetPort: 3306

  创建 namespace,service,configmap,pod

kubectl create -f namespace.yaml

kubectl create -f mysql-mgr-svc.yaml

kubectl create -f mysql-mgr-cnf-0.yaml

kubectl create -f mysql-mgr-cnf-1.yaml

kubectl create -f mysql-mgr-cnf-2.yaml

kubectl create -f mysql-mgr-0-pod.yaml

kubectl create -f mysql-mgr-1-pod.yaml

kubectl create -f mysql-mgr-2-pod.yaml

创建后如下图所示:

  配置节点 1:

root@dkm:/app/mgr# kubectl exec -it mysql-mgr-0 -n mysqldb /bin/bash

root@mysql-mgr-0:/# /usr/local/mysql/bin/mysql -uroot -p

alter user root @ localhost identified by Mysql123!@#
set sql_log_bin=0;
create user rpl_user@ % identified by Rpl_pass@123
grant replication slave on *.* to rpl_user@ %
flush privileges;
set sql_log_bin=1;
change master to master_user= rpl_user ,master_password= Rpl_pass@123 for channel group_replication_recovery
install PLUGIN group_replication SONAME group_replication.so

reset master;
set global group_replication_single_primary_mode=FALSE;
set global group_replication_enforce_update_everywhere_checks=TRUE;
set global group_replication_bootstrap_group=ON;
start group_replication;
set global group_replication_bootstrap_group=OFF;
select * from performance_schema.replication_group_members;

配置节点 2:

set sql_log_bin=0;
create user rpl_user@ % identified by Rpl_pass@123
grant replication slave on *.* to rpl_user@ %
flush privileges;
set sql_log_bin=1;
change master to master_user= rpl_user ,master_password= Rpl_pass@123 for channel group_replication_recovery
install PLUGIN group_replication SONAME group_replication.so

reset master;
set global group_replication_single_primary_mode=FALSE;
set global group_replication_enforce_update_everywhere_checks=TRUE;
set global group_replication_recovery_get_public_key=on;
start group_replication;
select * from performance_schema.replication_group_members;

  配置节点 3:

set sql_log_bin=0;
create user rpl_user@ % identified by Rpl_pass@123
grant replication slave on *.* to rpl_user@ %
flush privileges;
set sql_log_bin=1;
change master to master_user= rpl_user ,master_password= Rpl_pass@123 for channel group_replication_recovery
install PLUGIN group_replication SONAME group_replication.so

reset master;
set global group_replication_single_primary_mode=FALSE;
set global group_replication_enforce_update_everywhere_checks=TRUE;
set global group_replication_recovery_get_public_key=on;
start group_replication;
select * from performance_schema.replication_group_members;

 

总结:

(1)节点之间是通过域名互相通讯,域名的构成: hostname.service.namespace.svc.cluster.local.

(2)注意在每个节点的配置文件里配置 report_host 为该节点的域名,也就是 hostname.service.namespace.svc.cluster.local。否则会报错:

2019-04-10T09:16:53.607069+08:00 55 [ERROR] [MY-010584] [Repl] Slave I/O for channel group_replication_recovery : error connecting to master rpl_user@mysql-mgr-0:3306 – retry-time: 60  retries: 1, Error_code: MY-002005

2019-04-10T09:17:53.682099+08:00 24 [ERROR] [MY-011582] [Repl] Plugin group_replication reported: There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.

“怎么在 k8s 上部署 mysql 8.0 MGR”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注丸趣 TV 网站,丸趣 TV 小编将为大家输出更多高质量的实用文章!

正文完
 
丸趣
版权声明:本站原创文章,由 丸趣 2023-08-01发表,共计12975字。
转载说明:除特殊说明外本站除技术相关以外文章皆由网络搜集发布,转载请注明出处。
评论(没有评论)