# sql\_mode

**URL:** <https://forums.percona.com/t/sql-mode/6351>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 11, 2018, 9:19am UTC](https://forums.percona.com/t/sql-mode/6351 "2018-05-11T09:19:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bogomip](https://avatars.discourse-cdn.com/v4/letter/b/e47774/32.png) [@bogomip](https://forums.percona.com/u/bogomip)\
**Post date:** [May 11, 2018, 9:19am UTC](https://forums.percona.com/t/sql-mode/6351/1 "2018-05-11T09:19:00Z")

</div>

we are running percona-xtradb-cluster-57, is it safe to revert the sql\_mode to “sql\_mode NO\_ENGINE\_SUBSTITUTION” as per percona-server-server-5.6 ?

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [May 11, 2018, 9:40am UTC](https://forums.percona.com/t/sql-mode/6351/2 "2018-05-11T09:40:21Z")

</div>

It should safe to use “NO\_ENGINE\_SUBSTITUTION” , but also Percona XtraDB Cluster 5.7 comes with pxc\_strict\_mode which would not allow you to use any engine, but only InnoDB.