linux版本:CentOS Linux release 7.8.2003 (Core)
mysql版本:Ver 8.0.18 for el7 on x86_64 (MySQL Community Server - GPL)
前提:
1、服務器規(guī)劃,都關閉防火墻,中控機能ssh到各個安裝節(jié)點,各個節(jié)點相互都配置ssh互信
192.168.17.170 linuxsinglemysql 中控機
192.168.17.175 mysql01? ? ?mysql主節(jié)點
192.168.17.176 mysql02? ? ?mysql從節(jié)點1
192.168.17.177 mysql03? ? ?mysql從節(jié)點1
192.168.17.169 mysqlmanager? ? ?mysql管理節(jié)點
2、中控機?/shell/installmha下文件
hostnameimport.txt installmha.sh master_ip_failover mha_conf.cnf mysqld mysql.local mysqlmasterslave.sh
hostnameip.txt? ? ? managerinstall.sh? master_ip_online_change? my.cnf? ? ? ? mysqlinstall.sh? mysqlmastercreteuser.sh
/soft下如下文件?mysql-8.0.18-el7-x86_64.tar.gz??mha4mysql-manager-0.58.tar.gz??mha4mysql-node-0.58.tar.gz
腳本執(zhí)行:
中控機/shell/installmha執(zhí)行??sh installmha.sh
等待3-5分鐘,搭建完畢!
腳本如下:
1、vim installmha.sh



2、vim mysqlinstall.sh



3、vim mysqlmasterslave.sh

4、vim managerinstall.sh

5、vim mysqlmastercreteuser.sh

6、vim hostnameimport.txt
192.168.17.169 mysqlmanager
192.168.17.175 mysql01
192.168.17.176 mysql02
192.168.17.177 mysql03
192.168.17.170 linuxsinglemysql
7、vim hostnameip.txt
192.168.17.175 mysql01? ? 0 0 1
192.168.17.176 mysql02? ? 1 0 0
192.168.17.177 mysql03? ? 1 0 0
192.168.17.169 mysqlmanager 0 1 0