wsrep_slave_threads and deprecated variable innodb_locks_unsafe_for_binlog

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi!

In the documentation for ​the Galera Cluster, galeracluster.com/documentation-webpages/performance.html#setting-parallel-slave-threads, 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.

dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_locks_unsafe_for_binlog

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

David

2

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

3

Hi again and sorry for the late reply!

Thank you for your answer.

[url]Redirecting to Google Groups
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

David