Is STRICT_TRANS_TABLES required for replication? Particularly, I need to know about it for Percona Cluster.

  • 1
    What does the documentation say?
    – dezso
    Aug 25, 2013 at 17:43
  • documentation says STRICT_TRANS_TABLES is for validation. But Percona cluster installation creates a /usr/my.cnf file which has STRICT_TRANS_TABLES mode enabled. This file overrides configuration done in /etc/my.cnf hence I was clarifying if STRICT_TRANS_TABLES is a requirement for cluster to function.
    – Jai
    Aug 26, 2013 at 10:36
  • I would say that if the docs don't say it is needed for replication then it isn't needed. If you enable it does it make any harm (performance or other)?
    – dezso
    Aug 26, 2013 at 10:42
  • Percona uses 3rd party galera cluster and some custom scripts for replication. I was unsure about reason for Percona to add /usr/my.cnf in installation to override sql_mode. If they did that it must be for a very good reason, unless it is a bug.
    – Jai
    Aug 26, 2013 at 11:28


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.