基于Docker 1.13.1之上构建的MySQL MHA Docker Compose Project
可快速启动GTID模式下的MasterHA集群, 主用于MySQL与Docker的学习研究
master
- Docker compose中名为master
的service, 主库容器默认映射端口3406
slave_1
- Docker compose中名为slave_1
的service, 从库容器默认映射端口3407
manager
- Docker compose中名为manager
的service, 作为MHA manager
mha_share
- 容器间的共享数据卷
account.env
保存容器间的公用环境变量, 如MySQL复制账户repl的账号密码
employees_db
master
启动时的MySQL初始化脚本
employees_master
master
主库容器中的配置文件, 日志与库存放位置
employees_slave_1
slave_1
从库容器中的配置文件, 日志与库存放位置
employees_share
容器间的共享数据卷
mha_manager
构建Docker镜像mha_manager
所需的Dockerfile及其依赖文件的存放目录, 在docker-compose.yml有定义
mha_node
构建Docker镜像mha_node
所需的Dockerfile及其依赖文件的存放目录, 在docker-compose.yml有定义
reset.sh
停止project并删除所有数据库的日志与库(配置文件除外)
shutdown.sh
单纯地停止project
start.sh
master
与slave_1
形成复制链路mha.log
首次运行时请先初始化MySQL, 否则容器将不接受连接
➜ mha git:(master) docker-compose up -d
Creating network "mha_default" with the default driver
Creating mha_mha_node_1
Creating mha_mha_share_1
Creating mha_mha_manager_1
Creating mha_master_1
Creating mha_slave_1_1
Creating mha_manager_1
待容器可接收宿主机的MySQL连接代表初始化完成
预热后运行start.sh脚本以构建MHA集群
➜ mha git:(master) ./start.sh
>>> Docker Compose starting...
Starting mha_mha_manager_1
Starting mha_mha_share_1
Starting mha_mha_node_1
mha_master_1 is up-to-date
mha_slave_1_1 is up-to-date
mha_manager_1 is up-to-date
>>> Setting ssh...
fd9686976e61 initializing SSH...
fd9686976e61 change the password of root successfully.
fd9686976e61 SSH service has been restarted.
fd9686976e61 succeed in generating ssh key.
...
fd9686976e61 copy ssh key to manager successfully.
fd9686976e61 copy ssh key to master successfully.
...
>>> Creating mysql user for replication named 'repl' on master container...
mysql: [Warning] Using a password on the command line interface can be insecure.
>>> Configuring replication with GTID mode...
configuring slave_1 754214d5bdfc ...
mysql: [Warning] Using a password on the command line interface can be insecure.
>>> Initializing MHA configuration...
mha configuration "/mha_share/application.cnf" is not initialized.
added host "master" to mha configuration file.
added host "slave_1" to mha configuration file.
**********************************************
checking mha ssh...
Wed Feb 15 11:04:08 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
...
Wed Feb 15 11:04:08 2017 - [debug] ok.
Wed Feb 15 11:04:09 2017 - [info] All SSH connection tests passed successfully.
**********************************************
checking mha repl to mysql...
Wed Feb 15 11:04:09 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
...
MySQL Replication Health is OK.
**********************************************
starting mha manager with file "/mha_share/application.cnf"...
nohup: redirecting stderr to stdout
>>> Done!
NOTE: 首次运行时如果不预热而直接调用start.sh脚本的话, 则会引起MySQL未完成初始化而造成构建主从复制链路出错, 如果是数据库已经经过初始化则不需要进行预热
docker-compose up -d
进行MySQL的初始化Two-way link with Docker Compose
How to configure MySQL master/slave replication with MHA automatic failover
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
1. 开源生态
2. 协作、人、软件
3. 评估模型