【mysql】【20】mha （未完成）

1.免密码登录
ssh-keygen -t rsa
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.20
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.21
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.22

ssh-keygen -t rsa
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.19
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.21
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.22

ssh-keygen -t rsa
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.19
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.20
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.22

ssh-keygen -t rsa
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.19
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.20
ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.56.21

chmod 700 ~/.ssh
chmod 600 ~/.ssh/authorized_keys

创建mha管理用的复制账号，每台数据库（master，slave01，slave02）上都要创建账号
create user ‘mha_rep’@‘192.168.56.%’ IDENTIFIED BY ‘Ydfoie@df1213%’;
grant replication slave on . to ‘mha_rep’@‘192.168.56.%’;
flush privileges;

wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

rpm -ivh epel-release-6-8.noarch.rpm
rpm -ivh remi-release-6.rpm

ls -1 /etc/yum.repos.d/epel* /etc/yum.repos.d/remi.repo

vi /etc/yum.repos.d/remi.repo

编辑[remi]下的enabled选项从0设为1

vi /etc/yum.repos.d/epel.repo
编辑[epel]下的baseurl前的#号去掉，mirrorlist前添加#号。正确配置如下：

yum makecache

yum install perl-DBD-MySQL -y
rpm -ivh https://downloads.mariadb.com/files/MHA/mha4mysql-node-0.54-0.el6.noarch.rpm

yum install perl cpan perl-DBD-MySQL perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Net-Telnet -y
rpm -ivh https://downloads.mariadb.com/files/MHA/mha4mysql-node-0.54-0.el6.noarch.rpm
wget https://downloads.mariadb.com/files/MHA/mha4mysql-manager-0.56.tar.gz
tar zvxf mha4mysql-manager-0.56.tar.gz
cd mha4mysql-manager-0.56
perl Makefile.PL
make && make install

mkdir -p /usr/local/mha/scripts
cp samples/conf/app1.cnf /usr/local/mha/mha.cnf
cp samples/scripts/* /usr/local/mha/scripts/

vim /usr/local/mha/mha.cnf

[root@manager ~]# cat /usr/local/mha/mha.cnf

[server default]
user=mha_rep #MHA管理mysql的用户名
password=Ydfoie@df1213% #MHA管理mysql的密码
manager_workdir=/usr/local/mha #MHA的工作目录
manager_log=/usr/local/mha/manager.log #MHA的日志路径
ssh_user=root #免秘钥登陆的用户名
repl_user=backup #主从复制账号，用来在主从之间同步数据
repl_password=backup
ping_interval=1 #ping间隔时间，用来检查master是否正常

[server1]
hostname=192.168.56.19
master_binlog_dir=/var/lib/mysql/
candidate_master=1 #master宕机后，优先启用这台作为master

[server2]
hostname=192.168.56.20
master_binlog_dir=/var/lib/mysql/
candidate_master=1

masterha_check_ssh --conf=/usr/local/mha/mha.cnf

masterha_check_repl --conf=/usr/local/mha/mha.cnf

nohup masterha_manager --conf=/usr/local/mha/mha.cnf > /tmp/mha_manager.log 2>&1 &

masterha_check_status --conf=/usr/local/mha/mha.cnf

masterha_stop masterha_check_status --conf=/usr/local/mha/mha.cnf

rm -rf /usr/local/mha/mha.failover.complete

grep MASTER_HOST /usr/local/mha/manager.log