Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

share|improve this question
1  
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

 
discard

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

Browse other questions tagged or ask your own question.