KubeSphere - 搭建 mysql 主从复制结构

KubeSphere - 搭建 mysql 主从复制结构

以project-regular登入系统

mysql 主节点

创建 PVC 存储卷

1. 登入系统，点击进入项目按钮
   

2. 点击存储卷
   

3. 点击创建
   

4. 选择存储类型与访问模式后，点击下一步，创建
   

5. mysql-master-pvc 创建成功
   

创建 my.cnf 配制

1. 创建 mysql-master-cnf
2. 基本信息
   
3. 配置设置
   配置文件的内容

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8mb4' 
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci 
skip-character-set-client-handshake
skip-name-resolve

server_id=1
log-bin=mysql-bin
read-only=0
binlog-do-db=gulimall_ums
binlog-do-db=gulimall_pms
binlog-do-db=gulimall_oms
binlog-do-db=gulimall_sms
binlog-do-db=gulimall_wms
binlog-do-db=gulimall_admin
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

注意： 此配置文件只同步这些表（！！！！！！！！）
binlog-do-db=gulimall_ums
binlog-do-db=gulimall_pms
binlog-do-db=gulimall_oms
binlog-do-db=gulimall_sms
binlog-do-db=gulimall_wms
binlog-do-db=gulimall_admin

4. mysql-master-cnf 配置成功

创建 mysql master 服务

1. 点击创建按钮
   
2. 选择有状态服务
   3. 基本信息配置
   
3. 容器镜像： mysql:5.7
   
   把内存调大一点
   
   选择提前配好的mysql秘钥， 点击下一步
   **
   **
4. 挂载存储卷: /var/log/mysql
   
   配置文件和秘钥： /etc/mysql
   
5. 点击对号–下一步–创建即可
   
   
   

mysql 从节点搭建

创建pvc,与主节点类似：mysql-slave-pvc

创建 mysql-slave-cnf

配置内容

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8mb4' 
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci 
skip-character-set-client-handshake
skip-name-resolve


server_id=2
log-bin=mysql-bin
read-only=1
binlog-do-db=gulimall_ums
binlog-do-db=gulimall_pms
binlog-do-db=gulimall_oms
binlog-do-db=gulimall_sms
binlog-do-db=gulimall_wms
binlog-do-db=gulimall_admin
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

创建mysql的从节点

1. 创建
   
2. 与mysql主节点类似，其余步骤省略，创建成功
   

mysql 主从配制

1. 进入mysql主节点，点击终端，进入容器内部
   
2. 输入用户用户名和密码，进入mysql
   
3. 输入

GRANT REPLICATION SLAVE ON *.* to 'backup'@'%' identified by '123456';

4. 查看主节点的状态

show master  status 

mysql-bin.000003文件，后面的从节点要同步这个文件。

从节点配制

1. 进入从节点，输入命令

change master to master_host='mysql-master.demo-project',master_user='backup',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=439,master_port=3306;

开始同步：

查看同步的状态：

测试主从，主从成功（此处就补贴图片了）