Replication-manager 集群管理组件

replication-manager是signal18开源的一款数据库高可用工具，采用go语言开发。支持MySQL、MariaDB、Percona，其包含一下功能特性：

• 复制监控
• 复制拓扑检测
• 主从切换(switchover)
• 主节点故障切换(failover)
• 大多数场景下数据零丢失
• 多群集管理
• 支持proxy(proxysql,haproxy等)

下载安装介质 http://ci.signal18.io/mrm/builds/2.0/

rpm -ivh replication-manager-osc-2.0.2-1.x86_64.rpm

创建数据目录

mkdir manager
chown -R mysql.mysql manager

编辑配置文件

cat /etc/replication-manager/config.toml
[mysql-luhx]
title = "mysql-luhx"
db-servers-hosts = "10.0.139.161:33006,10.0.139.162:33006,10.0.139.163:33006"
db-servers-prefered-master = "10.0.139.161:33006"
db-servers-ignored-hosts = "10.0.139.162:33006"
db-servers-credential = "dba:Abcd123#"
replication-credential = "repl:Abcd123#"
failover-mode = "automatic"
[Default]
monitoring-datadir = "/service/mysql/manager"
monitoring-sharedir = "/service/mysql/manager"
log-level=7
log-file = "/service/mysql/manager/replication-manager.log"
replication-multi-master = false
replication-multi-tier-slave = false
failover-readonly-state = true
http-server = true
http-bind-address = "0.0.0.0"
http-port = "8000"

启动replication-manager

service replication-manager restart

访问dashboard

switchover

switchover可以在web控制台直接点击switchover

failover

当主节点关闭时，Fail count超过5次即立刻进行切换，当恢复时会自动加入新群集成为主节点