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
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

Comments

  • 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.

    https://groups.google.com/forum/#!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

    David
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.