Not the answer you need?
Register and ask your own question!

wsrep_slave_threads and deprecated variable innodb_locks_unsafe_for_binlog

mrdrmrdr EntrantCurrent User Role Beginner

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



  • vadimtkvadimtk Contributor Percona Staff Role
    It is deprecated in 5.7.
    In Percona XtraDB Cluster 5.6 you should keep
  • mrdrmrdr Entrant Current User Role Beginner
    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

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.