wsrep_slave_threads and deprecated variable innodb_locks_unsafe_for_binlog


In the documentation for ​the Galera Cluster,, it’s stated that you need to set the following two variables:

innodb_autoinc_lock_mode = 2
innodb_locks_unsafe_for_binlog = 1

Now it turns out that the second variable is deprecated.

Should one set innodb_locks_unsafe_for_binlog = 0? In a master-slave configuration, will it then have any effect to set wsrep_slave_threads > 1?

Best regards


It is deprecated in 5.7.
In Percona XtraDB Cluster 5.6 you should keep

Hi again and sorry for the late reply!

Thank you for your answer.!topic/codership-team/dY0KFiu-1r8
By this page one can see that this setting is no longer (since 2014) a requirement, neither recommended to be used anymore.

The question is answered by a member of the CoderShip team who develop the Galera Cluster, so I assume it’s safe to assume he’s correct.

Best regards