Is STRICT_TRANS_TABLES required for replication? Particularly, I need to know about it for Percona Cluster.
-
1What does the documentation say?– dezsoAug 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.– JaiAug 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)?– dezsoAug 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.– JaiAug 26, 2013 at 11:28