一、解决问题
Master挂掉不会影响业务
实现心跳
二、双主配置,基于主从复制( MySQL的一主二从异步复制(半同步复制))配置上进一步设置
1、Master:
//master配置
log_bin = /usr/local/mysql/binarylog/mysql_bin.index
binlog_format=mixed
expire_logs_days = 7
server_id = 1
//slave 配置
relay_log = /usr/local/mysql/binarylog/relay_log
relay_log_index = /usr/local/mysql/binarylog/relay_log.index
log_slave_updates=1 //此项代表,把relay_log写入到log_bin中,保证Master的binary log与Slave的bin log 一致
2、Slave:
//master配置
log_bin = /usr/local/mysql/binarylog/mysql_bin.index
binlog_format=mixed
log_slave_updates=1 //此项代表,把relay_log写入到log_bin中,保证slave的binary log与Master的bin log 一致
//slave
Master挂掉不会影响业务
实现心跳
二、双主配置,基于主从复制( MySQL的一主二从异步复制(半同步复制))配置上进一步设置
1、Master:
//master配置
log_bin = /usr/local/mysql/binarylog/mysql_bin.index
binlog_format=mixed
expire_logs_days = 7
server_id = 1
//slave 配置
relay_log = /usr/local/mysql/binarylog/relay_log
relay_log_index = /usr/local/mysql/binarylog/relay_log.index
log_slave_updates=1 //此项代表,把relay_log写入到log_bin中,保证Master的binary log与Slave的bin log 一致
2、Slave:
//master配置
log_bin = /usr/local/mysql/binarylog/mysql_bin.index
binlog_format=mixed
log_slave_updates=1 //此项代表,把relay_log写入到log_bin中,保证slave的binary log与Master的bin log 一致
//slave