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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- keepalived安裝
- centos7上keepalived的安裝和配置CentOS
- MySQL安裝配置MySql
- keepalived 安裝部署
- 【MySQL】安裝與配置MySql
- mysql安裝及配置MySql
- MySQL安裝與配置MySql
- MySQL-安裝配置篇MySql
- 【Mysql】Windows下安裝和配置MysqlMySqlWindows
- Mysql for Linux安裝配置之—— rpm（bundle）安裝MySqlLinux
- Mysql for Linux安裝配置之—— 原始碼安裝MySqlLinux原始碼
- MySQL安裝之二_安裝配置泥潭版MySql
- MYSQL5.7.22 原始碼安裝 主從搭建 + KEEPALIVED高可用MySql原始碼
- MySQL安裝之一_安裝配置順利版MySql
- Windows 安裝並配置 MySQL 5.6WindowsMySql
- Ubuntu 18.04 安裝配置 MySQL 5.7UbuntuMySql
- MySQL - 安裝時的安全配置MySql
- Mysql安裝及基礎配置MySql
- LNMP--mysql php安裝配置LNMPMySqlPHP
- MySQL主從配置及haproxy和keepalived搭建MySql
- Mysql for Linux安裝配置之——二進位制安裝MySqlLinux
- LINUX 環境 mysql to mysql OGG安裝配置（二）LinuxMySql
- windows安裝及配置mysql5.7WindowsMySql
- MySQL的下載、安裝和配置MySql
- Mysql安裝與配置_win10MySqlWin10
- MySQL - 下載與安裝配置（Linux）MySqlLinux
- ubuntu 20.04安裝配置mysql8.0UbuntuMySql
- MySQL 主從複製安裝部署配置MySql
- macOS下MySQL 8.0 安裝與配置教程MacMySql
- jdk+tomcat+mysql一鍵安裝配置JDKTomcatMySql
- MySQL的安裝與配置——詳細教程MySql
- centos7.6 安裝配置 mysql5.7CentOSMySql
- oracle & mysql 驅動程式安裝配置OracleMySql
- MySQL5.7.21免安裝版如何配置MySql
- 【MySQL資料庫】MySQL5.7安裝與配置、視覺化工具安裝和破解MySql資料庫視覺化
- 全面梳理 簡明安裝指南 mysql 8 安裝升級與配置MySql
- keepalived配置問題
- Linux-RHEL7環境MySQL安裝配置LinuxMySql
- Linux-CentOS7環境MySQL安裝配置LinuxCentOSMySql