MySQL8 Keepalived+双主

; set password for ‘root‘@‘localhost‘=‘123456‘; grant all privileges on *.* to root@‘localhost‘ with grant option; create user ‘repl‘@‘win88.inno.com‘ identified WITH mysql_native_password by ‘123456‘ PASSWORD EXPIRE NEVER ; grant replication slave on *.* to ‘repl‘@‘win88.inno.com‘ with grant option; create user ‘repl‘@‘win89.inno.com‘ identified WITH mysql_native_password by ‘123456‘ PASSWORD EXPIRE NEVER ; grant replication slave on *.* to ‘repl‘@‘win89.inno.com‘ with grant option; create user ‘repl‘@‘192.168.68.88‘ identified WITH mysql_native_password by ‘123456‘ PASSWORD EXPIRE NEVER ; grant replication slave on *.* to ‘repl‘@‘192.168.68.88‘ with grant option; create user ‘repl‘@‘192.168.68.89‘ identified WITH mysql_native_password by ‘123456‘ PASSWORD EXPIRE NEVER ; grant replication slave on *.* to ‘repl‘@‘192.168.68.89‘ with grant option; flush privileges; SET SQL_LOG_BIN=1;

配置主从

设win88.inno.com 的主机

change master to master_host=‘win89.inno.com‘,master_port=3308,master_user=‘repl‘,master_password=‘123456‘,master_auto_position=1; 
start slave; 
show slave status\G

设win89.inno.com 的主机

 

change master to master_host=‘win88.inno.com‘,master_port=3308,master_user=‘repl‘,master_password=‘123456‘,master_auto_position=1; 
start slave; 
show slave status\G

 

设置mysql 开机自启

cp -p /data/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
cp -p /data/3308/my.cnf    /etc/my.cnf.d/my.cnf
chkconfig --list

安装keepalive

yum -y install keepalived

win89.inno.com 的keepalived 设定

[root@win89 ~]# cat /etc/keepalived/keepalived.conf
! Configuration File for keepalived

global_defs {
   router_id mysql_slave_
   vrrp_skip_check_adv_addr
   vrrp_script check_run {
   script "/data/mysql_check.sh"
   interval 10
}
   vrrp_garp_interval 0
   vrrp_gna_interval 0
}

vrrp_instance VI_1 {
    state BACKUP
    interface ens160
    virtual_router_id 51
    priority 90
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.68.188
    }
    track_script {
    check_run
    }
}

virtual_server 192.168.68.188 3308 {
    delay_loop 6
    lb_algo wrr
    lb_kind DR
    nat_mask 255.255.255.0
    persistence_timeout 50
    protocol TCP

    real_server 192.168.68.89 3308 {
        weight 1
        TCP_CHECK {
            connect_timeout 3
            nb_get_retry 3
            connect_port 3308
        }
    }
}

win88.inno.com 的keepalived 设定

[root@win88 ~]# cat /etc/keepalived/keepalived.conf
! Configuration File for keepalived

global_defs {
   router_id mysql_master_
   vrrp_skip_check_adv_addr
   vrrp_script check_run {
   script "/data/mysql_check.sh"
   interval 10
}
   vrrp_garp_interval 0
   vrrp_gna_interval 0
}

vrrp_instance VI_1 {
    state BACKUP
    interface ens160
    virtual_router_id 51
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.68.188
    }
    track_script {
    check_run
    }
}

virtual_server 192.168.68.188 3308 {
    delay_loop 6
    lb_algo wrr
    lb_kind DR
    nat_mask 255.255.255.0
    persistence_timeout 50
    protocol TCP

    real_server 192.168.68.88 3308 {
        weight 1
        TCP_CHECK {
            connect_timeout 3
            nb_get_retry 3
            connect_port 3308
        }
    }
}

 设置keepalived 开机自启

 systemctl enable keepalived
 systemctl start keepalived

 

MySQL8 Keepalived+双主

标签：replica   serve   ica   tar   sql   ati   track   port   user