解决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
评论