mha实现mysql主从数据库手动切换的方法_2

MHA 实现mysql 主从数据库手动切换的方法
本文实例讲述了MHA 实现mysql 主从数据库手动切换的方法，分享给大家供大家参考。具
体方法如下：
一、准备工作
1、分别在Master 和Slave 执行如下,方便mha 检查复制:
复制代码 代码如下:grant all privileges on *.* toidentified by 'rootpass';
grant all privileges on *.* to identified by 'rootpass';
grant replication slave on *.* to identified by 'jppasswd';
grant replication slave on *.* to identified by 'jppasswd';
flush privileges;
2、将master 设置为只读
复制代码 代码如下:mysql set global read_only=1;
Query OK, 0 rows affected (0.00 sec)
mysql show variables like 'read_only';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| read_only | ON |
+---------------+-------+
1 row in set (0.00 sec)
交互模式:
复 制 代 码 代 码 如 下 :#masterha_master_switch --master_state=alive
--conf=/etc/masterha/http://wendang.chazidian.comf --new_master_host=10.1.1.231 --new_master_port=63306
或非交互模式:
复 制 代 码 代 码 如 下 :#masterha_master_switch --master_state=alive
--conf=/etc/masterha/http://wendang.chazidian.comf --new_master_host=10.1.1.231 --new_master_port=63306 —
interactive=0
二、切换完以后，如何让10.1.1.231 为主，10.1.1.234 为从，操作步骤:
1、主上执行:
复制代码 代码如下:mysql show master status;
+-------------------------+----------+--------------+--------------------------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------------+----------+--------------+--------------------------------------+-------------------+
| mysql-master-bin.000013 | 120 | denovo_ng | mysql,denovo,test,information_schema | |
+-------------------------+----------+--------------+--------------------------------------+-------------------+
1 row in set (0.00 sec)
2、在10.1.1.234 上执行如下sql 命令；
复 制 代 码 代 码 如 下 :change master to
master_host='10.1.1.231',master_port=63306,master_user='jpsy nc',
master_password='jppasswd', master_log_file='mysql-master-bin.000013',master_log_pos=120;
mysql show slave status＼G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.1.1.231