MySQL Cluster - When rebooting a data node machine on a 4 machine cluster it hangs SQL nodes -
i have mysql cluster 4 machines such (example ip's): [ndbd(ndb)] 2 node(s) id=1 @1.1.1.1 (mysql-5.6.23 ndb-7.4.5, nodegroup: 0) id=2 @1.1.1.2 (mysql-5.6.23 ndb-7.4.5, nodegroup: 0, *) [ndb_mgmd(mgm)] 2 node(s) id=49 @1.1.1.51 (mysql-5.6.23 ndb-7.4.5) id=52 @1.1.1.52 (mysql-5.6.23 ndb-7.4.5) [mysqld(api)] 3 node(s) id=50 (not connected, accepting connect 1.1.1.51) id=55 @1.1.1.51 (mysql-5.6.23 ndb-7.4.5) id=56 @1.1.1.52 (mysql-5.6.23 ndb-7.4.5) if cold reboot on either data node machine (id=1 or id=2) cannot run sql queries (on nodes 55 or 56) until data node machine comes online reboot. here errors: error 1297 (hy000): got temporary error 4028 'node failure caused abort of transaction' ndbcluster error 1205 (hy000): lock wait timeout exceeded; try restarting transaction if stop data node first in ndb_mgm such 1 stop or 2 stop , reboot machine there no issue. is correct behavior? if data node machine crashes or pulls plug on cluster inopera...