mysql上k8s_在k8s上部署mysql 8.0 MGR

准备生成三个节点pod的相关yaml文件。---创建namespace的文件namespace.yaml:apiVersion: v1kind: Namespacemetadata:name: mysqldb---节点1的configmap文件mysql-mgr-cnf-0.yaml：apiVersion: v1data:mysql-mgr-0.cnf: |[mysqld]port = 3306c

weixin_39573136

513人浏览 · 2021-01-18 18:41:41

weixin_39573136 · 2021-01-18 18:41:41 发布

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

---创建namespace的文件namespace.yaml:

apiVersion: v1

kind: Namespace

metadata:

---节点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:

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:

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:

namespace: mysqldb

----节点1的pod的yaml文件:

apiVersion: v1

kind: Pod

metadata:

namespace: mysqldb

labels:

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

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:

items:

- key: mysql-mgr-0.cnf

path: my.cnf

----节点2的pod的yaml文件:

apiVersion: v1

kind: Pod

metadata:

namespace: mysqldb

labels:

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

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:

items:

- key: mysql-mgr-1.cnf

path: my.cnf

---节点3的pod的yaml文件:

apiVersion: v1

kind: Pod

metadata:

namespace: mysqldb

labels:

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

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:

items:

- key: mysql-mgr-2.cnf

path: my.cnf

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

apiVersion: v1

kind: Service

metadata:

namespace: mysqldb

spec:

selector:

clusterIP: None

ports:

- name: foo

port: 3306

targetPort: 3306

K8S/Kubernetes

K8S/Kubernetes社区为您提供最前沿的新闻资讯和知识内容

更多推荐

【深度】阿里巴巴万级规模 K8s 集群全局高可用体系之美

作者 | 韩堂、柘远、沉醉来源 | 阿里巴巴云原生公众号前言台湾作家林清玄在接受记者采访的时候，如此评价自己 30 多年写作生涯：“第一个十年我才华横溢，‘贼光闪现’，令周边黯然失色；第二个十年，我终于‘宝光现形’，不再去抢风头，反而与身边的美丽相得益彰；进入第三个十年，繁华落尽见真醇，我进入了‘醇光初现’的阶段，真正体味到了境界之美”。长夜有穷，真水无香。领略过了 K8s“身在江

K8S/Kubernetes

如何基于 K8s 构建下一代 DevOps 平台？

作者 | 孙健波（天元）导读：当前云原生 DevOps 体系现状如何？面临哪些挑战？如何通过 OAM 解决云原生 DevOps 场景下的诸多问题？云原生开发应用模型 OAM(Open Application Model) 社区核心成员孙健波将为大家一一解答，并分享如何基于 OAM 和 Kubernetes 打造无限能力的下一代 DevOps 平台。什么是 DevOps？为什么基于 Kub