keepalive mysql vip

修改 hostname
cat /etc/redhat-release
cenos7.4 hostnamectl set-hostname nacos_db_8.221

从库修改
vi /etc/my.cnf
server_id=65

vi /u01/my3306/data/auto.cnf
server-uuid=a229ccb2-9b24-11ea-b7b1-005056a2b318

service mysqld restart

show variables like ‘%id%’;

利用GTID 搭建主从
主库
–主库创建复制用户repl

GRANT REPLICATION SLAVE ON . TO ‘repl’@’%’ identified by ‘123456’;

mysqldump --defaults-file=/etc/my.cnf -uroot -p’12wsxCDE#’ --socket=’/u01/my3306/run/mysql.sock --master-data=2 --single-transaction=on --set-gtid-purged=on --log-error=all.log -A >all.sql
mysqldump --defaults-file=/etc/my.cnf -uroot -p --socket=’/u01/my3306/run/mysql.sock’ --master-data=2 --single-transaction=on --set-gtid-purged=on --log-error=all.log -A >all.sql

scp -P9822 all.sql shdy@192.168.8.221:/tmp

从库
mv /tmp/all.sql ./
chown root. all.sql
导入前需要在从库执行reset master清空GTID_EXECUTED
reset master;
source /root/all.sql

change master to
master_host=‘192.168.8.220’,
master_port=3306,
master_user=‘repl’,
master_password=‘123456’,
master_auto_position=1;

show slave status\G;
start slave;

配置vip
vi /etc/keepalived/keepalived.conf
修改
virtual_router_id 226
priority 100
virtual_ipaddress {
192.168.8.226
}

global_defs {
router_id MySQL-HA
}

vrrp_script check_run {
script “/u01/my3306/script/mysql_check.sh”
interval 30
}

vrrp_sync_group VG1 {
group {
VI_1
}
}

vrrp_instance VI_1 {
state BACKUP
interface ens192
virtual_router_id 225
priority 50
advert_int 1
nopreempt
authentication {
auth_type PASS
auth_pass 1234
}
track_script {
check_run
}

notify_master /data/script/master.sh

notify_backup /data/script/backup.sh

notify_stop /data/script/stop.sh

virtual_ipaddress {
    192.168.8.225
}

systemctl start keepalived
systemctl start keepalived