1、配置yum源

宜秀ssl適用于網(wǎng)站、小程序/APP、API接口等需要進行數(shù)據(jù)傳輸應(yīng)用場景，ssl證書未來市場廣闊！成為成都創(chuàng)新互聯(lián)的ssl證書銷售渠道，可以享受市場價格4-6折優(yōu)惠！如果有意向歡迎電話聯(lián)系或者加微信：028-86922220（備注：SSL證書合作）期待與您的合作！[root@mgr1?~]#?cat?/etc/yum.repos.d/signal18.repo [signal18] name=Signal18?repositories baseurl=http://repo.signal18.io/centos/$releasever/$basearch/ gpgcheck=0 enabled=1

2、yum安裝過程

[root@mgr1?~]#?yum?install?replication-manager-osc Loaded?plugins:?fastestmirror Loading?mirror?speeds?from?cached?hostfile ?*?base:?mirror.dal.nexril.net ?*?epel:?mirrors.yun-idc.com ?*?extras:?mirrors.huaweicloud.com ?*?updates:?mirrors.tuna.tsinghua.edu.cn github_orchestrator/x86_64/signature??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|??833?B??00:00:00????? github_orchestrator/x86_64/signature??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|?1.0?kB??00:00:00?!!!? github_orchestrator-source/signature??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|??819?B??00:00:00????? github_orchestrator-source/signature??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|??951?B??00:00:00?!!!? signal18??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|?2.9?kB??00:00:00????? signal18/7/x86_64/primary_db??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|?5.8?kB??00:00:01????? Resolving?Dependencies -->?Running?transaction?check --->?Package?replication-manager-osc.x86_64?1560253855:2.0.1_28_gf072-1?will?be?installed -->?Finished?Dependency?Resolution Dependencies?Resolved ================================================================================================================================================================================================= ?Package??????????????????????????????????????????????Arch????????????????????????????????Version????????????????????????????????????????????????????Repository?????????????????????????????Size ================================================================================================================================================================================================= Installing: ?replication-manager-osc??????????????????????????????x86_64??????????????????????????????1560253855:2.0.1_28_gf072-1????????????????????????????????signal18???????????????????????????????26?M Transaction?Summary ================================================================================================================================================================================================= Install??1?Package Total?download?size:?26?M Installed?size:?192?M Is?this?ok?[y/d/N]:?y Downloading?packages: replication-manager-osc-2.0.1_28_gf072-1.x86_64.rpm???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????|??26?MB??00:22:57????? Running?transaction?check Running?transaction?test Transaction?test?succeeded Running?transaction ??Installing?:?1560253855:replication-manager-osc-2.0.1_28_gf072-1.x86_64????????????????????????????????????????????????????????????????????????????????????????????????????????????????????1/1? ??Verifying??:?1560253855:replication-manager-osc-2.0.1_28_gf072-1.x86_64????????????????????????????????????????????????????????????????????????????????????????????????????????????????????1/1? Installed: ??replication-manager-osc.x86_64?1560253855:2.0.1_28_gf072-1????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? Complete!

3、配置文件修改

[root@mgr1?~]#?find?/?-name?*.toml /etc/replication-manager/cluster.d/cluster01.toml /etc/replication-manager/cluster.d/cluster02.toml [root@mgr1?~]#?vim?/etc/replication-manager/cluster.d/cluster01.toml [root@mgr1?~]#?mkdir?-p?/data/replication-manager [root@mgr1?~]#?mkdir?-p?/data/share_replication-manager [root@mgr1?~]#?vim?/etc/replication-manager/config.toml?????????????????????????????????????????????????????????????????????????????????????????????????????????????????? [root@mgr1?~]#?cat?/etc/replication-manager/config.toml [Cluster01] title?=?"Cluster01" db-servers-hosts?=?"192.168.56.14:3306,192.168.56.15:3306,192.168.56.16:3306" db-servers-prefered-master?=?"192.168.56.15:3306" db-servers-credential?=?"orchestrator:123456" db-servers-connect-timeout?=?1 replication-credential?=?"orchestrator:123456" failover-mode?=?"automatic" [Default] monitoring-datadir?=?"/data/replication-manager" monitoring-sharedir?=?"/data/share_replication-manager" log-level=1 log-file?=?"/var/log/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?=?"10001"

4、啟動

[root@mgr1?~]#?/etc/init.d/replication-manager?restart Restarting?replication-manager?(via?systemctl):????????????[??OK??] [root@mgr1?~]#

5、切換測試

6、結(jié)合中間件maxscale，proxysql

maxscale，proxysql負責(zé)讀寫分離，因為這兩個中間件本身就有識別發(fā)現(xiàn)主的功能，所以replication-manager負責(zé)管理主從failover的主庫選舉和從庫指向新主。 發(fā)現(xiàn)replication-manager可以對maxscale，proxysql管理，我覺得這個兩個中間件主動發(fā)現(xiàn)模式已經(jīng)夠用了，不需要被動接收replication-manager發(fā)送信息。

7、特別說明：

shutdown的主節(jié)點上線后，replication-manager會自動把其加入集群。 replication-manager不需要在MySQL節(jié)點安裝客戶端

8、我的環(huán)境：

mgr安裝的是replication-manager es1-3安裝的是MySQL5.7?gtid主從 [root@mgr1?maxscale]#?cat?/etc/hosts 127.0.0.1???localhost?localhost.localdomain?localhost4?localhost4.localdomain4 ::1?????????localhost?localhost.localdomain?localhost6?localhost6.localdomain6 192.168.56.13?mgr 192.168.56.14?es1 192.168.56.15?es2 192.168.56.16?es3 [root@mgr1?maxscale]#? [root@es3?bin]#?cat?/etc/my.cnf?|grep?-v?^#[mysqld]datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid gtid-mode?=?ON enforce-gtid-consistency?=?ON log-slave-updates?=?ON log-bin=mysqlbin server-id=3 report_host=es3[root@es3?bin]#

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機、免備案服務(wù)器”等云主機租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

分享標(biāo)題：replication-managerforMySQLha安裝測試筆記-創(chuàng)新互聯(lián)
標(biāo)題來源：http://weahome.cn/article/dohopg.html