mysql + keepalived 安裝配置
注意：keepalived在每一臺的伺服器上都需要安裝
環境介紹：
master_mysql: 10.20.20.51
slave_mysql : 10.20.20.61
virtual_ip : 10.20.20.201
注意：關閉防火牆、selinux
一、安裝keepalived
下載地址：
1、
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
環境介紹：
master_mysql: 10.20.20.51
slave_mysql : 10.20.20.61
virtual_ip : 10.20.20.201
注意：關閉防火牆、selinux
一、安裝keepalived
下載地址：
1、
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
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
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30345407/viewspace-2088053/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MYSQL + MHA +keepalive + VIP安裝配置(三)--keepalived安裝配置MySql
- saltstack之keepalived的安裝配置
- mha+keepalived安裝配置過程
- keepalived安裝
- MySQL安裝配置MySql
- Mysql 安裝 配置MySql
- centos7上keepalived的安裝和配置CentOS
- MYSQL + MHA +keepalive + VIP安裝配置(一)--MYSQL安裝配置MySql
- Nginx+Keepalived 主備高可用 安裝與配置Nginx
- 【MySQL】安裝與配置MySql
- mysql安裝及配置MySql
- MySQL安裝與配置MySql
- 3安裝配置mysqlMySql
- MySQL-安裝配置篇MySql
- mac MYSQL安裝和配置MacMySql
- MySQL免安裝版配置MySql
- solaris 10 mysql 安裝 配置MySql
- MySQL 免安裝版配置MySql
- 【mysql】CentOS離線安裝配置MySqlMySqlCentOS
- MySQL安裝之二_安裝配置泥潭版MySql
- Mysql for Linux安裝配置之—— 原始碼安裝MySqlLinux原始碼
- MySQL安裝之一_安裝配置順利版MySql
- Keepalived+Mysql配置主主複製MySql
- keepalived+mysql+centos6.4 簡單配置MySqlCentOS
- Windows 安裝並配置 MySQL 5.6WindowsMySql
- LNMP--mysql php安裝配置LNMPMySqlPHP
- Centos7 安裝配置MysqlCentOSMySql
- Mysql安裝及基礎配置MySql
- mysql 非安裝版的配置MySql
- MySql綠色版安裝配置MySql
- Mysql for Linux安裝配置之—— rpm（bundle）安裝MySqlLinux
- MYSQL5.7.22 原始碼安裝 主從搭建 + KEEPALIVED高可用MySql原始碼
- MySQL主從配置及haproxy和keepalived搭建MySql
- 基於keepalived Mysql雙主熱備配置MySql
- Ubuntu 18.04 安裝配置 MySQL 5.7UbuntuMySql
- Mysql安裝與配置_win10MySqlWin10
- windows安裝及配置mysql5.7WindowsMySql
- 【Mysql】keepalive的安裝與配置MySql