RE: MySQL Cluster Backup and Restoration

you can only do a mysqldump consistently if you go into single user mode for the API node that will do the dump. this can mean downtime of the application. the advantage of a SQL dump is that it's more "portable" and you can do a search and replace for NDBENGINE and replace with MYISAM if you want to put your data into a non-cluster MySQL server for testing or whatever reason. Also, restoring a large database using a SQL dump can be very slow.

using the ndb_mgm -e "start backup", you can do it at anytime with the system 100% live. this doesn't interrupt services as your doing it and keeps a transaction log. restoring data using the hot backup files is generally faster than restoring from an SQL dump file. the disadvantage is that you can't use the hot backup files to put the data into a non-cluster MySQL server. Also, between major upgrades, you won't be able to use the hot backup files to restore say, from 5.0.x to a 5.1.x Cluster. and since those hot backup files are binary, it isn't easy to "see" your data offline.

in our systems, we do a nightly ndb_mgm -e "start backup" and backup onto a central NFS file server. when we need to perform maintenance that requires single user mode, we take the opportunity to do a SQL dump along with whatever other tasks is required.

> -----Original Message-----
> From: Jake Conk [mailto:jake.conk@gmail.com]
> Sent: Tuesday, October 02, 2007 7:15 PM
> To: cluster@lists.mysql.com
> Subject: MySQL Cluster Backup and Restoration
>
> Hello,
>
> I was wondering if it is better to backup a MySQL Cluster
> with the ndb_mgm program or use mysql_dump? What are the
> advantages and disadvantages of using either or?
>
> Thanks,
> - Jake
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=bond.masuda@jlbond.com
>
>

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com