# Accidental creation and INSERT into MyISAM table crashes cluster

**URL:** <https://forums.percona.com/t/accidental-creation-and-insert-into-myisam-table-crashes-cluster/3586>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 1, 2014, 2:44pm UTC](https://forums.percona.com/t/accidental-creation-and-insert-into-myisam-table-crashes-cluster/3586 "2014-07-01T14:44:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shockwavecs](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@shockwavecs](https://forums.percona.com/u/shockwavecs)\
**Post date:** [July 1, 2014, 2:44pm UTC](https://forums.percona.com/t/accidental-creation-and-insert-into-myisam-table-crashes-cluster/3586/1 "2014-07-01T14:44:05Z")

</div>

We have a 3 node cluster that runs mostly InnoDB tables. We have MyISAM replication enabled in my.cnf. One database has all InnoDB tables aside from a brand new table that was set to MyISAM accidentally. After this table got an insert for the first time, it crashed the database.

OK, so PXC node 1 went down, PXC node 2 picked up. The developer saw a “mysql connection disappeared” or something similar after his attempt to do the INSERT. So he then went to PXC node 2 and did the same insert. This crashed node 2. This then left node 3 in “initialized” state and data could not be read or written to.

Questions:

1. Node 3 is not going to do anything until node 1 and/or 2 are fixed, correct? Should node 3 still operate?
2. Does all of this sounds like it is the proper outcome to accidentally creating a MyISAM table in a primarily InnoDB setup?
3. Can I avoid these issues? We need to convert a another database to InnoDB from MyISAM and we know it will crash everything until we do a restart.