keepalive mysql_MySQL高可用解决方案之keepalive+lvs+mysql

解决configure: error: Popt

libraries is required

这个错误是因为没有安装popt的开发包导致的，解决方法也很简单，只要yum install popt-devel,就可以安装好popt的开发包了。重新./configure.

Grant replication slave,file on *.* to ‘slave’@’%’identified by ‘slave’;

Master-master配置

Master1:192.168.2.54

nano

/etc/my.cnf

log-bin=mysql-bin

server-id=1

binlog-do-db=test

binlog-ignore-db=mysql

replicate-do-db=test

replicate-ignore-db=mysql

log-slave-updates

slave-skip-errors=all

sync_binlog=1

auto_increment_increment=2

auto_increment_offset=1

master2:192.168.2.60

log-bin=mysql-bin

server-id=2

binlog-do-db=test

binlog-ignore-db=mysql

replicate-do-db=test

replicate-ignore-db=mysql

log-slave-updates

slave-skip-errors=all

sync_binlog=1

auto_increment_increment=2

auto_increment_offset=1

操作master1 ,同时作为master2的slave

change

master to master_host='192.168.2.60',master_user=’slave’,master_password='slave',master_log_file='mysql-bin.000001',

master_log_pos=98;

对master2进行操作

change

master to master_host='192.168.2.54',master_user=’slave’,master_password='slave',master_log_file='mysql-bin.000001',

master_log_pos=98;

查看master状态show master status\G

查看slave状态show slave status\G

Slave stop,slave

start

show processlist 查看执行状态

安装keepalived

./configure

Make&&make

install

在主备节点上都执行

/etc/keepalived

/usr/local/etc/keepalived/keepalived.conf

/etc/keepalived/keepalived.conf

cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/keepalived

cp /usr/local/sbin/keepalived  /usr/sbin/keepalived

cp

/usr/local/etc/rc.d/init.d/keepalived  /etc/init.d/keepalived

在主节点上：

vi /etc/keepalived/keepalived.conf

! Configuration File for keepalived

global_defs {

notification_email {

ethnicitybeta@126.com

}

notification_email_from Alexandre.Cassen@firewall.loc

smtp_server 192.168.1.195

smtp_connect_timeout 30

router_id LVS_DEVEL

}

vrrp_script chk_mysql {

script

"killall -0 mysqld"

interval

5

}

vrrp_instance VI_1 {

state MASTER

interface eth0

virtual_router_id 51

priority 100

advert_int 1

authentication {

auth_typePASS

auth_pass 1111

}

virtual_ipaddress {

192.168.1.200

}

track_script {

chk_mysql

}

}

在备用节点上

vi /etc/keepalived/keepalived.conf

! Configuration File for keepalived

global_defs {

notification_email {

ethnicitybeta@126.com

}

notification_email_from

Alexandre.Cassen@firewall.loc

smtp_server 192.168.1.195

smtp_connect_timeout 30

router_id LVS_DEVEL

}

vrrp_script chk_mysql {

script

"killall -0 mysqld"

interval

5

}

vrrp_instance VI_1 {

state BACKUP

interface eth0

virtual_router_id 51

priority 90

advert_int 1

authentication {

auth_typePASS

auth_pass 1111

}

virtual_ipaddress {

192.168.1.200

}

track_script {

chk_mysql

}

}

分享到：

2012-03-08 17:53

浏览 4439

评论