# STRICT\_TRANS\_TABLES a requirement for replication?

**URL:** https://forums.percona.com/t/strict-trans-tables-a-requirement-for-replication/2902
**Category:** Percona XtraDB Cluster 5.x
**Created:** [August 23, 2013, 11:58pm UTC](https://forums.percona.com/t/strict-trans-tables-a-requirement-for-replication/2902 "2013-08-23T23:58:38Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![jaigupta](https://avatars.discourse-cdn.com/v4/letter/j/a183cd/32.png) [@jaigupta](https://forums.percona.com/u/jaigupta)
#### Post date: [August 23, 2013, 11:58pm UTC](https://forums.percona.com/t/strict-trans-tables-a-requirement-for-replication/2902/1 "2013-08-23T23:58:38Z")

</div>

I see sql\_mode as STRICT\_TRANS\_TABLES,NO\_ENGINE\_SUBSTITUTION which is default with Percona Cluster.

This has been causing problems with some incompatible applications.

Is STRICT\_TRANS\_TABLES a requirnment for Cluster replication? If not, we may simply change it to “” to make applications work again.