如果安perl-DBD-MySQL-4.013-3.el6.x86_64.rpm在检查rep是报错则需要手动编译安装
| tar -zxvf DBD-mysql-4.027.tar.gz cd DBD-mysql-4.0.27 perl Makefile.PL make && make install |
节点服务器安装
| rpm -ivh ncftp-debuginfo-3.2.3-1.3.x86_64.rpm rpm -ivh perl-DBD-MySQL-4.013-3.el6.x86_64.rpm |
7、创建软连接
| ln -s /usr/local/mysql/bin/mysqlbinlog /usr/bin/mysqlbinlog ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql |
导出mysql库搜索路径
| vim /etc/ld.so.conf.d/mysql-x86_64.conf /usr/local/mysql/lib ldconfig |
8、在所有服务器上安装mha4mysql-node-0.54.tar.gz
| tar -zxvf mha4mysql-node-0.54.tar.gz cd mha4mysql-node-0.54 perl Makefile.PL make && make install |
9、在管理服务上安装 mha4mysql-manager-0.54.tar.gz
| tar -zxvf mha4mysql-manager-0.54.tar.gz cd mha4mysql-manager-0.54 perl Makefile.PL make && make install mkdir -pv /etc/masterha mkdir -pv /masterha/app1 cp samples/conf/* /etc/masterha cp samples/scripts/* /usr/local/bin |
| vim /etc/masterha/app1.cnf |
| [server default] manager_workdir=/masterha/app1 manager_log=/masterha/app1/manager.log user=root password=root ssh_user=root repl_user=slave repl_password=slave shutdown_script="" #master_ip_failover_script="/usr/local/bin/masterha_ip_failover" master_ip_online_change_script="/usr/local/bin/masterha_ip_failover " report_script="" [server1] hostname=192.168.216.50 master_binlog_dir="/data/mysql/" candidate_master=1 [server2] hostname=192.168.216.51 master_binlog_dir="/data/mysql/" candidate_master=1 [server3] hostname=192.168.216.52 master_binlog_dir="/data/mysql/" candidate_master=1 |
10、测试ssh连接
| masterha_check_ssh –conf=/etc/masterha/app1.cnf |
11、测试replication
| masterha_check_repl –conf=/etc/masterha/app1.cnf |
12、开启管理节点进程
| masterha_manager –conf=/etc/masterha/app1.cnf |
13、测试故障转移
关闭主库mysql，查看从库的的状态是否将同步ip切换到新的主库
14、设置故障转移的ip
