search

hcymysql / MHA-Re-Edition

MySQL (MHA)重构版
73 stars 36 forks source link

binlog server配置 #5

Open zjg90325 opened 2 years ago

zjg90325 commented 2 years ago

app1.cnf能不能新增binlog server配置，来解决主库物理破坏导致binlog不能用导致切换数据不一致的问题

hcymysql commented 2 years ago

app1.cnf能不能新增binlog server配置，来解决主库物理破坏导致binlog不能用导致切换数据不一致的问题

确保每台机器都开启参数 log_slave_updates = 1 sync_binlog = 1 innodb_flush_log_at_trx_commit = 1 rpl_semi_sync_master_enabled = 1 rpl_semi_sync_slave_enabled = 1 expire_logs_days = 7