Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
What does the documentation say? – dezso Aug 25 '13 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 '13 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 '13 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 '13 at 11:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.