# Percona Xtradb MySql any option to ignore insert error

**URL:** <https://forums.percona.com/t/percona-xtradb-mysql-any-option-to-ignore-insert-error/10524>\
**Category:** Percona Server for MySQL 8.0\
**Tags:** mysql\
**Created:** [May 19, 2021, 10:04pm UTC](https://forums.percona.com/t/percona-xtradb-mysql-any-option-to-ignore-insert-error/10524 "2021-05-19T22:04:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahulsri\_percona](https://avatars.discourse-cdn.com/v4/letter/r/f19dbf/32.png) [@rahulsri\_percona](https://forums.percona.com/u/rahulsri_percona)\
**Post date:** [May 19, 2021, 10:04pm UTC](https://forums.percona.com/t/percona-xtradb-mysql-any-option-to-ignore-insert-error/10524/1 "2021-05-19T22:04:17Z")

</div>

I have following question where I have described a failure scenario in Percona MySql 5.7 and asking if there is a way in **Percona MySql version 8.0** to prevent this by changing the default settings.

**Failure scenario:-**  
In one of the failure scenario of **Percona MySQL Xtradb cluster version 5.7** which has RSU option enabled. The whole cluster goes down when below 3 steps are done:-

1. Let say there are 3 nodes of a database cluster with one node being primary donor node and two other are non-primary nodes.
2. Create a table and insert a row on the primary donor node.
3. Whole cluster goes down due as soon as donor node replicates to other nodes due to inconsistent state as table was not existing on the non-primary nodes.

**Question:-**  
In **Percona Mysql version 8.0** I was going through this link [Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/wsrep-system-index.html#wsrep_ignore_apply_errors) Here I don’t see any option that can help protect the cluster from going down due to above failure scenario for e.g. by ignoring insert.

Is there any setting that can ignore errors due to inserts as per above scenario and not let the whole cluster go down in version 8.0?

Thanks

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 19, 2021, 10:41pm UTC](https://forums.percona.com/t/percona-xtradb-mysql-any-option-to-ignore-insert-error/10524/2 "2021-05-19T22:41:42Z")

</div>

Hello @rahulsri_percona,  
RSU is dangerous for the very reasons you described. Unfortunately, there is no way to prevent your cluster from going down in this scenario. What you have described is a _clear violation_ of data integrity. In Galera/PXC, the data is the most important thing. If consistency is compromised, the cluster goes down. You need to fix the other nodes and bring them into sync.

---

<div class="post-metadata">

**Author:** ![rahulsri\_percona](https://avatars.discourse-cdn.com/v4/letter/r/f19dbf/32.png) [@rahulsri\_percona](https://forums.percona.com/u/rahulsri_percona)\
**Post date:** [May 19, 2021, 11:06pm UTC](https://forums.percona.com/t/percona-xtradb-mysql-any-option-to-ignore-insert-error/10524/3 "2021-05-19T23:06:48Z")

</div>

Thanks Matthewb. Appreciate your input.

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [May 20, 2021, 2:13pm UTC](https://forums.percona.com/t/percona-xtradb-mysql-any-option-to-ignore-insert-error/10524/4 "2021-05-20T14:13:28Z")

</div>