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.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2