MySQL Galera集群的心跳间隔调整
当在两个数据中心之间部署galera的集群时,由于经常WAN的不稳定而导致galera产生脑裂而引发
集群重新选举,所在在网络不稳定的情况下,我们可以适当调整检查的间隔和心跳超时的参数.
150503 20:21:25 [Note] WSREP: (96ccaff4-f176-11e4-a670-d2ca25a9d25b, 'tcp://0.0.0.0:4567')
reconnecting to 10b99ae6-f18a-11e4-8e94-c37e3464d18c (tcp://192.168.10.215:4567), attempt 0
150503 20:21:26 [Note] WSREP: evs::proto(96ccaff4-f176-11e4-a670-d2ca25a9d25b, OPERATIONAL,
view_id(REG,10b99ae6-f18a-11e4-8e94-c37e3464d18c,6))
suspecting node: 10b99ae6-f18a-11e4-8e94-c37e3464d18c
...............................................
150503 20:21:36 [Note] WSREP: evs::proto(96ccaff4-f176-11e4-a670-d2ca25a9d25b, GATHER,
view_id(REG,10b99ae6-f18a-11e4-8e94-c37e3464d18c,6)) detected inactive
node: 10b99ae6-f18a-11e4-8e94-c37e3464d18c
150503 20:21:37 [Note] WSREP: view(view_id(NON_PRIM,10b99ae6-f18a-11e4-8e94-c37e3464d18c