Need log_slave_update enabled
Bug #1479473 reported by
Paul Halmos
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack-Ansible |
Fix Released
|
Wishlist
|
Christopher H. Laco | ||
Juno |
Fix Released
|
Wishlist
|
Christopher H. Laco | ||
Kilo |
Fix Released
|
Wishlist
|
Jesse Pretorius | ||
Trunk |
Fix Released
|
Wishlist
|
Christopher H. Laco |
Bug Description
Each of the galera nodes needs to have "log_slave_update" enabled. Currently, the node that gets the write request from the LB will log to it's own binary log. The binary logs can be spread across all 3 nodes making recovery difficult. By enabling this feature, all nodes will have the same binary logs.
To post a comment you must log in.
More details can be found here: https:/ /dev.mysql. com/doc/ refman/ 5.5/en/ replication- options- slave.html
tl;dr
"Normally, a slave does not log to its own binary log any updates that are received from a master server. This option tells the slave to log the updates performed by its SQL thread to its own binary log."
Add:
[mysqld]
log_slave_update=1