MySql NDB cluster large transaction
I know that with NDB you can not do large transactions, if you do data nodes can restart into read-only mode and corrupt table.
I need to copy records into a new table but the thing is this table contains millions of rows in staging, the live server has even 10 times that amount.
how can I divide my copy into smaller transactions so I will not kill my server?
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html sounds like what you are looking for.