Mysql5.6.22双向复制+KeepAlived如何配置mysql的高能用

小编给大家分享一下Mysql5.6.22双向复制+KeepAlived如何配置mysql的高可用，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！
 
1. 基础安装环境  ，采用mysql5.6.22和keepalived-1.2.15版本安装mysql高可用
此处)折叠或打开
 
[root@xxt01 ~]# groupadd mysql
[root@xxt01 ~]#useradd -g mysql -s /sbin/nologin -d /opt/mysql mysql
2.3  检查 mysql账号
 
此处
 
)折叠或打开
 
[root@xxt01 ~]#mkdir -p /usr/local/mysql
[root@xxt01 ~]#mkdir -p /usr/local/mysql/data
 2.4.1 执行cmake：       
 
此处
 
)折叠或打开
 
mysql> show master status;
+---------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------------+----------+--------------+------------------+-------------------+
| mysql-binlog.000002 | 624556 | | | |
+---------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
mysql>
    master 同步操作，参数Slave_IO_Running和Slave_SQL_Running为YES时表示成功，同时无其他错误
 
点击(此处)折叠或打开
 
mysql> grant replication slave on *.* to 'slave'@'10.6.0.203' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql>  flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_host='10.6.0.204',master_user='slave',master_password='123456',master_log_file='mysql-binlog.000002',master_log_pos=624556;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> start slave;
Query OK, 0 rows affected (0.01 sec)
mysql> show slave status\G;
 
点击(此处)折叠或打开
 
[root@xxt01 ~]# tar zxf keepalived-1.2.15.tar.gz
[root@xxt01 keepalived-1.2.15]# ./configure --prefix=/usr/local/keepalived
[root@xxt01 keepalived-1.2.15]# make && make install
[root@xxt01 etc]# cp -a /usr/local/keepalived/etc/rc.d/init.d/keepalived  /etc/init.d/
[root@xxt01 etc]# cp -a /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
[root@xxt01 etc]#   mkdir /etc/keepalived/
[root@xxt01 etc]# cp -a /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
[root@xxt01 etc]# cp -a /usr/local/keepalived/sbin/keepalived /usr/sbin/