建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
replication-managerforMySQLha安裝測(cè)試筆記
1、配置yum源
成都創(chuàng)新互聯(lián)從2013年成立，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項(xiàng)目網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作網(wǎng)站策劃，項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢(mèng)想脫穎而出為使命，1280元伊通做網(wǎng)站,已為上家服務(wù),為伊通各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:18982081108
[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安裝過(guò)程
[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、啟動(dòng)
[root@mgr1?~]#?/etc/init.d/replication-manager?restart Restarting?replication-manager?(via?systemctl):????????????[??OK??] [root@mgr1?~]#
5、切換測(cè)試
6、結(jié)合中間件maxscale，proxysql
maxscale，proxysql負(fù)責(zé)讀寫分離，因?yàn)檫@兩個(gè)中間件本身就有識(shí)別發(fā)現(xiàn)主的功能，所以replication-manager負(fù)責(zé)管理主從failover的主庫(kù)選舉和從庫(kù)指向新主。 發(fā)現(xiàn)replication-manager可以對(duì)maxscale，proxysql管理，我覺(jué)得這個(gè)兩個(gè)中間件主動(dòng)發(fā)現(xiàn)模式已經(jīng)夠用了，不需要被動(dòng)接收replication-manager發(fā)送信息。
7、特別說(shuō)明：
shutdown的主節(jié)點(diǎn)上線后，replication-manager會(huì)自動(dòng)把其加入集群。 replication-manager不需要在MySQL節(jié)點(diǎn)安裝客戶端
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]#
當(dāng)前標(biāo)題：replication-managerforMySQLha安裝測(cè)試筆記
當(dāng)前URL：http://fisionsoft.com.cn/article/jjgghd.html
