Ubuntu搭建Mysql+Keepalived高可用(双主热备)

Mysql5.5双机热备

实现方案

安装两台Mysql

安装Mysql5.5

sudo apt-get update

apt-get install aptitude
aptitude install mysql-server-5.5
或
sudo apt-cache search mariadb-server
apt-get install -y mariadb-server-5.5

卸载

sudo apt-get remove mysql-*
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P

配置权限

vim /etc/mysql/my.cnf
#bind-address = 127.0.0.1

mysql -u root -p
grant all on *.* to root@'%' identified by 'root' with grant option;
flush privileges;

###配置两台Mysql主主同步
配置节点1

vim /etc/mysql/my.cnf

server-id       = 1                                            #节点ID
log_bin         = mysql-bin.log               #日志 
binlog_format   = "ROW"                                    #日志格式
auto_increment_increment = 2                        #自增ID间隔(=节点数，防止ID冲突)
auto_increment_offset  = 1                            #自增ID起始值(节点ID)
binlog_ignore_db=mysql                                    #不同步的数据库
binlog_ignore_db=information_schema
binlog_ignore_db=performance_schema

重启mysql

service mysql restart
mysql -u root -p

记录节点1的binlog日志位置

show master status;

mysql-bin.000001    245        mysql,information_schema,performance_schema

配置节点2

vim /etc/mysql/my.cnf

server-id       = 2
log_bin         = mysql-bin.log                    
relay_log       = mysql-relay-bin.log        #中继日志
log_slave_updates = ON                                  #中继日志执行后，变化计入日志
read_