共計 3182 個字符，預計需要花費 8 分鐘才能閱讀完成。
本篇內容主要講解“mysql+keepalived 的安裝配置方法”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓丸趣 TV 小編來帶大家學習“mysql+keepalived 的安裝配置方法”吧!
注意：keepalived 在每一臺的服務器上都需要安裝
環境介紹：
master_mysql: 10.20.20.51
slave_mysql : 10.20.20.61
virtual_ip : 10.20.20.201
注意：關閉防火墻、selinux
一、安裝 keepalived
下載地址：
1、http://www.keepalived.org/software/keepalived-1.1.20.tar.gz
3、安裝 C 編譯器
yum install popt-devel openssl-devel popt-devel
yum install gcc gcc-c++ autoconf automake
4、編譯安裝
[root@node1 ~]# tar zxvf keepalived-1.2.13.tar.gz
[root@node1 keepalived-1.2.13]# cd keepalived-1.2.13
[root@node1 keepalived-1.2.13]# ./configure –prefix=/usr/local/keepalived –disable-fwmark
[root@node1 keepalived-1.2.13]# make
[root@node1 keepalived-1.2.13]# make install
[root@node1 keepalived-1.2.13]# cp /usr/local/keepalived/sbin/keepalived /usr/sbin/
[root@node1 keepalived-1.2.13]# cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
[root@node1 keepalived-1.2.13]# cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/
[root@node1 keepalived-1.2.13]# cd /etc/init.d/
[root@node1 init.d]# chkconfig –add keepalived
[root@node1 init.d]# chkconfig keepalived on
[root@node1 init.d]# mkdir -p /etc/keepalived
5、配置 keepalived 文件
1）主庫的 keepalived 配置文件
vim /etc/keepalived/keepalived.conf
global_defs {
router_id Hadb_1
}
vrrp_sync_group VGM {
group {
VI_HA
}
}
vrrp_script chk_mysql {
script
interval 1
}
# vvrp_instance define #
vrrp_instance VI_HA {
state MASTER
interface eth0
virtual_router_id 54
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass hamysql
}
virtual_ipaddress {
10.20.20.201
}
track_script {
chk_mysql
}
}
2）從庫的 keepalived 的配置文件
vim /etc/keepalived/keepalived.conf
global_defs {
router_id Hadb_1
}
vrrp_sync_group VGM {
group {
VI_HA
}
}
vrrp_script chk_mysql {
script
interval 1
}
# vvrp_instance define #
vrrp_instance VI_HA {
state BACKUP
interface eth0
virtual_router_id 54
priority 50
advert_int 1
authentication {
auth_type PASS
auth_pass hamysql
}
virtual_ipaddress {
10.20.20.201
}
track_script {
chk_mysql
}
}
6、啟動 keepalived 服務
service keepalived start
二、配置 mysql 的 AB 復制（互相的 AB 復制）
1、1. 主庫配置（master 服務器）
#vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin //[必須]啟用二進制日志
server-id=51 //[必須] 服務器唯一 ID，默認是 1，一般取 IP 最后一段
2. 修改從服務器 slave:
#vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin //[必須]啟用二進制日志
server-id=61 //[必須] 服務器唯一 ID，默認是 1，一般取 IP 最后一段
3、重啟兩臺服務器的 mysql
/etc/init.d/mysql restart
4、在主服務器上建立帳戶并授權 slave:
10.20.20.51：
mysql GRANT REPLICATION SLAVE ON *.* to repler @ % identified by 123.com
10.20.20.61：
mysql GRANT REPLICATION SLAVE ON *.* to repler @ % identified by 123.com
5、登錄主服務器的 mysql，查詢 master 的狀態
mysql show master status;
+——————+———-+————–+——————+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+——————+———-+————–+——————+
| mysql-bin.000004 | 308 | | |
+——————+———-+————–+——————+
6、配置從服務器 Slave：
10.20.20.61：
mysql change master to master_host= 10.20.20.51 ,master_user= repler ,master_password= 123.com ,
master_log_file= mysql-bin.000004 ,master_log_pos=308;
10.20.20.51：
mysql change master to master_host= 10.20.20.61 ,master_user= repler ,master_password= 123.com ,
master_log_file= mysql-bin.000004 ,master_log_pos=308;
7、啟動從服務器復制功能
mysql start slave;
8、檢查從服務器復制功能狀態：
mysql show slave status\G
到此，相信大家對“mysql+keepalived 的安裝配置方法”有了更深的了解，不妨來實際操作一番吧！這里是丸趣 TV 網站，更多相關內容可以進入相關頻道進行查詢，關注我們，繼續學習！
