主主+ lvs keepalived 配置文件

主主+ lvs keepalived 配置文件

主主搭建

rpm -qa | grep mysql 

yum remove -y 

yum install -y

/etc/init.d/mysql stop

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

use mysql;

UPDATE user SET Password=PASSWORD('mysql') where USER='root';

/etc/init.d/mysql restart

mysql -uroot -pmysql

SET PASSWORD=password('mysql');

GRANT all privileges on *.* TO 'root'@'%' identified by 'mysql' WITH GRANT OPTION;

SET PASSWORD FOR 'root'@'%' = PASSWORD('mysql');

grant replication slave on *.* to 'rep'@'%' identified by 'rep';

grant replication slave on *.* to 'rep'@'172.16.15.%' identified by 'rep';

change master to master_host='172.16.15.28',master_user='rep',master_password='rep',

master_log_file='mysql-bin.000001',master_log_pos=317;

1 搭建keepalived

! Configuration File for keepalived

global_defs {

   router_id mm1

}

vrrp_sync_group VG1 {

     group {

       VI_1

     }

}

vrrp_instance VI_1 {

    state BACKUP

    interface eth0

    virtual_router_id 60

    priority 80

    advert_int 1

    authentication {

        auth_type PASS

        auth_pass 1111

    }

    virtual_ipaddress {

        172.16.15.29

    }

}

virtual_server 172.16.15.29 3306 {

    delay_loop 6

    lb_algo wrr

    lb_kind DR

    nat_mask 255.255.254.0

    persistence_timeout 50

    protocol TCP

    real_server 172.16.15.28 3306 {

        weight 1

notify_down /usr/local/mysql/bin/mysql.sh

     TCP_CHECK {

         connect_timeout 10

         nb_get_retry 3

         connect_port 3306

         }

        }

}

2主机

! Configuration File for keepalived

global_defs {

   router_id mm2

}

vrrp_sync_group VG1 {

     group {

       VI_1

     }

}

vrrp_instance VI_1 {

    state BACKUP

    interface eth1

    virtual_router_id 60

    priority 100

    advert_int 1

    nopreempt

    authentication {

        auth_type PASS

        auth_pass 1111

    }

    virtual_ipaddress {

        172.16.15.29

    }

}

virtual_server 172.16.15.29 3306 {

    delay_loop 6

    lb_algo wrr

    lb_kind DR

    nat_mask 255.255.254.0

    persistence_timeout 50

    protocol TCP

    real_server 172.16.15.27 3306 {

        weight 1

notify_down /usr/local/mysql/bin/mysql.sh

     TCP_CHECK {

         connect_timeout 10

         nb_get_retry 3

         connect_port 3306

         }

        }

}