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_