k8s mysql主从搭建_k8s部署mysql主从复制

Mysql主从

准备环境

一,准备软件

官方docker_image :Mysql5.7.28

Docker Version:        19.03.4

K8s api-version:        apps/v1

二,具体制作流程

1根据docker-image编写Dockerfile制作mysql-master镜像2.1根据docker-image编写Dockerfile制作mysql-salve镜像

From mysql:latest                                                     #基础镜像

ENV MYSQL_ALLOW_EMPTY_PASSWORD yes  #设置无密码登录

COPY conf.sh /mysql/conf.sh                                  #复制配置文件

COPY set.sql /mysql/set.sql                                  #复制配置文件

CMD ["sh", "/mysql/conf.sh"]                                      #容器启动时执行脚本

2.1配置文件conf.sh

#! /bin/bash

set -e

echo "1,设置mysql_server_ID....."

sed -i '/\[mysqld\]/a server-id=1\nlog-bin=/var/lib/mysql/mysql-bin\ngtid-mode=ON\nenforce-gtid-consistency=ON' /etc/mysql/mysql.conf.d/mysqld.cnf

echo "2.启动MySQL 。。。"

service mysql start

echo "3,设置密码。。。"

sed -i 's/MYSQLROOTPASSWOED/'$MYSQL_ROOT_PASSWORD'/' mysql/set.sql

sed -i 's/MYSQLREPLICATIONPASSWORD/'$MYSQL_REPLICATION_PASSWORD'/' mysql/set.sql

sed -i 's/MYSQLREPLICATIONUSER/'$MYSQL_REPLICATION_USER'/' mysql/set.sql

mysql < /mysql/set.sql

echo "4 service mysql status"

tail -f /dev/null

2.2配置文件set.sql 设置mysql——root密码  创建复制用户及密码

use mysql;

set password for root@'localhost' = password("MYSQLROOTPASSWORD");

grant all on *.* to "MYSQLREPLICATIONUSER"@'%' identified by "MYSQLREPLICATIONPASSWORD" with grant option;

grant all on *.* to 'root'@'%' identified by "MYSQLREPLICATIONPASSWORD" with grant option;

flush privileges;

1.3将三个文件放在同级目录构建mysql-master-image

执行命令

#docker build -t mysql5.7-master:001 .

创建完image后在本地docker环境配置容器看是否有无复制用户

#docker run --name mysql-master -e MYSQL_ROOT_PASSWORD="123456" -e MYSQL_REPLICATION_USER="rep1" -e MYSQL_REPLICATION_PASSWORD="123456" -d mysql5.7-master:01

进入容器>进去mysql>查看用户

#docker exec -it mysql-master bash

2.1根据docker-image编写Dockerfile制作mysql-salve镜像

From mysql:latest                                                     #基础镜像

ENV MYSQL_ALLOW_EMPTY_PASSWORD yes  #设置无密码登录

COPY conf.sh /mysql/conf.sh                                  #复制配置文件

COPY set.sql /mysql/set.sql                                  #复制配置文件

CMD ["sh", "/mysql/conf.sh"]                                      #容器启动时执行脚本

2.1配置文件conf.sh

#! /bin/bash

set -e

echo "1,设置mysql_server_ID....."

sed -i '/\[mysqld\]/a server-id=1\nlog-bin=/var/lib/mysql/mysql-bin\ngtid-mode=ON\nenforce-gtid-consistency=ON' /etc/mysql/mysql.conf.d/mysqld.cnf

echo "2.启动MySQL 。。。"

service mysql start

echo "3,设置密码。。。"

sed -i 's/MYSQLROOTPASSWOED/'$MYSQL_ROOT_PASSWORD'/' mysql/set.sql

sed -i 's/MYSQLREPLICATIONPASSWORD/'$MYSQL_REPLICATION_PASSWORD'/' mysql/set.sql

sed -i 's/MYSQLREPLICATIONUSER/'$MYSQL_REPLICATION_USER'/' mysql/set.sql

mysql < /mysql/set.sql

echo "4 service mysql status"

tail -f /dev/null

2.2配置文件set.sql 设置mysql——root密码  创建复制用户及密码

use mysql;

set password for root@'localhost' = password("MYSQLROOTPASSWORD");

grant all on *.* to 'root'@'%' identified by "MYSQLREPLICATIONPASSWORD" with grant option;

flush privileges;

2.3将三个文件放在同级目录构建mysql-slave-image

执行命令

#docker build -t mysql5.7-slave:001 .

2.4创建完image后在配置slave容器

2.4.1先查看master容器IP

# docker inspect mysql-master | grep IPAddr

2.5创建slave容器

docker run --name mysql-slave -e MYSQL_ROOT_PASSWORD="123456" -e MYSQL_MASTER_SERVICE_HOST="172.17.0.10" -e MYSQL_REPLICATION_USER="rep1" -e MYSQL_REPLICATION_PASSWORD="123456" -d mysql5.7-slave:001

2.6进入容器>进去mysql>slave状态

#docker exec -it mysql-slave bash

三,将所创建mysql-images转入k8s镜像库作为底层pod基础

1 在本地环境docker保存刚刚创建的两个mysql镜像

#docker save -o mysql5.7-master.tar mysql5.7-master:001

#docker save -o mysql5.7-slave.tar mysql5.7-slave:001

2导入至k8s环境

# docker load -i mysql5.7-master.tar

# docker load -i mysql5.7-slave.tar

3编写mysql-master-deploy.yaml

apiVersion: apps/v1                            #版本号

kind: Deployment                               #创建的资源类型

metadata:                                      #该资源的元数据，name必选项

name: mysql-master                           #name描述

spec:                                          #deployment的规格说明

replicas: 1                                  #副本数量

selector:

matchLabels:

name: mysql-master

template:                                   #定义pod的模板，配置文件的重要部分

metadata:                                  #定义pod的元数据，至少定义一个label

labels:

name: mysql-master

track: stable

spec:           #描述pod的规格，定义pod中每个容器的属性，name和image必须

containers:                            #容器描述

- image: mysql5.7-master:001          #镜像来源名字

name: mysql-master

imagePullPolicy: IfNotPresent

ports:

- containerPort: 3306

env:

- name: MYSQL_ROOT_PASSWORD

value: "123456"

- name: MYSQL_REPLICATION_USER

value: "rep1"

- name: MYSQL_REPLICATION_PASSWORD

value: "123456"

4编写mysql-mater-svc.yaml  映射端口为集群：31111

apiVersion: v1

kind: Service

metadata:

name: mysql-master

labels:

name: mysql-master

spec:

type: NodePort

ports:

- port: 3306

targetPort: 3306

nodePort: 31111

protocol: TCP

selector:

name: mysql-master

5编写mysql-slave-deploy.yaml

apiVersion: apps/v1

kind: Deployment

metadata:

name: mysql-slave

spec:

replicas: 3

selector:

matchLabels:

name: mysql-slave

template:

metadata:

labels:

name: mysql-slave

spec:

#      hostNetwork: true

#      endpoint-pod-names: mysql-master

containers:

- name: mysql-slave

image: mysql5.7-slave:001

imagePullPolicy: IfNotPresent

env:

-  name: MYSQL_ROOT_PASSWORD

value: "123456"

-  name: MYSQL_REPLICATION_USER

value: "rep1"

-  name: MYSQL_REPLICATION_PASSWORD

value: "123456"

-  name: MYSQL_MASTER_SERVICE_HOST

value: 192.168.226.183

ports:

- name:

containerPort: 3306

查看pods状态

#kubectl  get pods -o wide

验证 再master创建一张表看slave是否同步