mysql> grant replication slave,file on *.* to 'root'@'*' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

log-bin=mysql-bin #必须要开启二进制日志
server-id = 1  #另外一台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

mysql> stop slave;
mysql> flush tables with read lock\G
mysql> show master status\G
*************************** 1. row ***************************
File: mysql-bin.00001
Position: 106
Binlog_Do_DB: jsdoc
Binlog_Ignore_DB: mysql
1 row in set (0.00 sec)
change master to master_host='192.168.1.83',master_user='root',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=106;
###注意这里红色部分,Node2上面运行的应该是Node2-2的信息,反之Node2-2上面运行上述语句,用Node2得出信息(当然File和Postion一样就只需要改改IP了)###
mysql> start slave;
mysql> show processlist\G
###在这里看到回显里面有State: Has sent all binlog to slave; waiting for binlog to be updated，说明主主复制基本OK了。###
mysql> unlock tables;

wget http://www.keepalived.org/software/keepalived-1.2.2.tar.gz
tar zxvf keepalived-1.2.2.tar.gz
cd keepalived-1.2.2
./configure
make&&make install

mv /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak
vim /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
      notification_email {
            admin@ajcheng.com
      }
      notification_email_from admin@ajcheng.com
      smtp_server 127.0.0.1
      smtp_connect_timeout 30
      router_id MySQL-ha
}
vrrp_instance VI_1 {
state BACKUP #两台配置此处均是BACKUP
interface eth0
virtual_router_id 61
priority 100 #优先级，另一台改为90
advert_int 1
nopreempt #不抢占，只在优先级高的机器上设置即可，优先级低的机器不设置
authentication {
      auth_type PASS
      auth_pass 111
}
virtual_ipaddress {
192.168.1.86
}
}
virtual_server 192.168.1.86 3306 {
      delay_loop 2 #每个2秒检查一次real_server状态
      lb_algo wrr #LVS算法
      lb_kind DR #LVS模式
      persistence_timeout 60 #会话保持时间
      protocol TCP
      real_server 192.168.1.83 3306 {
            weight 3
            notify_down /usr/local/mysql/bin/mysql.sh #检测到服务down后执行的脚本
            TCP_CHECK {
                  connect_timeout 10 #连接超时时间
                  nb_get_retry 3 #重连次数
                  delay_before_retry 3 #重连间隔时间
                  connect_port 3306 #健康检查端口
            }
      }
}
vim /usr/local/mysql/bin/mysql.sh
#!/bin/sh
pkill keepalived
service network restart
chmod -R 777 /usr/local/mysql/bin/mysql.sh
chkconfig keepalived on
service keepalived start
service keepalived stauts
ip add

May 13 15:06:07 Sql-1 Keepalived_vrrp: ip address associated with VRID not present in received packet : 192.168.1.86
May 13 15:06:07 Sql-1 Keepalived_vrrp: one or more VIP associated with VRID mismatch actual MASTER advert
May 13 15:06:07 Sql-1 Keepalived_vrrp: bogus VRRP packet received on eth0 !!!
May 13 15:06:07 Sql-1 Keepalived_vrrp: VRRP_Instance(VI_1) ignoring received advertisment…

--转自