MySQL双主同步部署（Rancher）

最新推荐文章于 2024-08-16 22:58:37 发布

阿啄debugIT

最新推荐文章于 2024-08-16 22:58:37 发布

阅读量1.1k

点赞数

分类专栏： # mysql Rancher # Dockerfile 文章标签： MySQL双主同步部署（Rancher）

本文链接：https://blog.csdn.net/as4589sd/article/details/104151824

版权

本文档详细介绍了如何在Rancher环境中部署MySQL双主同步，包括配置configmap、创建主从节点、设置双主同步状态检查、负载均衡实现以及验证过程。通过kubectl生成配置，使用Docker和yaml文件部署，并提供了启动和验证步骤。

摘要由CSDN通过智能技术生成

前言

参考文章,需要把自己笔记本的hosts改成

如：https://rancher （192.168.108.131） admin/admin

所有文件列表

[root@master mysql]# tree --du -f
├── [ 1564] ./configmap.sh
├── [ 1649] ./mysql-master.yaml
├── [ 1639] ./mysql-slave.yaml
└── [ 2161] ./repl.sql

MySQL主从configmap配置

使用kubctl 工具生成mysql主从配置configmap

configmap.sh

#!/usr/bin/env bash
 
echo '
[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
#log-error      = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address   = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
# 双主配置
server_id = 1
log-bin= mysql-bin
 
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
 
read-only=0
relay_log=mysql-relay-bin
log-slave-updates=on
auto-increment-offset=1
auto-increment-increment=2
 
' > master.cnf
 
echo '
[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
#log-error      = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address   = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
# 双主配置
server_id = 2
log-bin= mysql-bin
 
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
 
read-only=0
relay_log=mysql-relay-bin
log-slave-updates=on
auto-increment-offset=2
auto-increment-increment=2
' > slave.cnf
kubectl --namespace=demo create configmap mysql-master --from-file=master.cnf
kubectl --namespace=demo create configmap mysql-slave --from-file=slave.cnf