Mysql5.6.22双向复制+KeepAlived如何配置mysql的高能用
发布时间：2021-12-24 13:21:20 所属栏目：MySql教程 来源：互联网
导读：小编给大家分享一下Mysql5.6.22双向复制+KeepAlived如何配置mysql的高可用，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！ 1. 基础安装环境 ，采用mysql5.6.22和keepalived-1.2.15版本安装mysql高可用 此处)折叠或打开 [root@xxt01 ~]# gr
|
小编给大家分享一下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 statusG; 点击(此处)折叠或打开 [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/ （编辑：均轻资讯网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐