本篇內容主要講解“+keepalived的安裝配置方法”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強。下面就讓小編來(lái)帶大家學(xué)習“mysql+keepalived的安裝配置方法”吧!
注意：keepalived在每一臺的上都需要安裝
環(huán)境介紹：
master_mysql: 10.20.20.51
slave_mysql : 10.20.20.61
virtual_ip : 10.20.20.201
注意：關(guān)閉防火墻、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、啟動(dòng)keepalived服務(wù)
service keepalived start
二、配置mysql的AB復制（互相的AB復制）
1、1.主庫配置（master服務(wù)器）
#vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin //[必須]啟用二進(jìn)制日志
server-id=51 //[必須]服務(wù)器唯一ID，默認是1，一般取IP最后一段
2.修改從服務(wù)器slave:
#vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin //[必須]啟用二進(jìn)制日志
server-id=61 //[必須]服務(wù)器唯一ID，默認是1，一般取IP最后一段
3、重啟兩臺服務(wù)器的mysql
/etc/init.d/mysql restart
4、在主服務(wù)器上建立帳戶(hù)并授權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、登錄主服務(wù)器的mysql，查詢(xún)master的狀態(tài)
mysql>show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000004 | 308 | | |
+------------------+----------+--------------+------------------+
6、配置從服務(wù)器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、啟動(dòng)從服務(wù)器復制功能
mysql>start slave;
8、檢查從服務(wù)器復制功能狀態(tài)：
mysql> show slave status\G
免責聲明：本站發(fā)布的內容（圖片、視頻和文字）以原創(chuàng )、來(lái)自本網(wǎng)站內容采集于網(wǎng)絡(luò )互聯(lián)網(wǎng)轉載等其它媒體和分享為主，內容觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng)，如侵犯了原作者的版權，請告知一經(jīng)查實(shí)，將立刻刪除涉嫌侵權內容，聯(lián)系我們QQ:712375056，同時(shí)歡迎投稿傳遞力量。
Copyright ? 2009-2022 56dr.com. All Rights Reserved. 特網(wǎng)科技 特網(wǎng)云 版權所有 特網(wǎng)科技 粵ICP備16109289號
域名注冊服務(wù)機構:阿里云計算有限公司（萬(wàn)網(wǎng)） 域名服務(wù)機構：煙臺帝思普網(wǎng)絡(luò )科技有限公司（DNSPod） CDN服務(wù)：阿里云計算有限公司 百度云 中國互聯(lián)網(wǎng)舉報中心 增值電信業(yè)務(wù)經(jīng)營(yíng)許可證B2
建議您使用Chrome、Firefox、Edge、IE10及以上版本和360等主流瀏覽器瀏覽本網(wǎng)站
