Hi,
Robert McHugh wrote:
> I was wondering if there were anyway to back up
> cluster tables in the event of a catastrophic
> failure. it would seem that an in-memory database
> is pretty volatile and would like to ensure the
> possibility of recreating a database after such a
> failure.
>
> Is there any way to do this using MySQL?
>
Even though Cluster is an in-memory database, it isn't very volatile. The reason it that it can lose any single node without losing data.
Cluster does write to disk by default though, however it is only needed in the event of a total cluster failure. In that case, when you start it back up, then it will read disk and resume operations. It is possible to lose data though as it only writes to disk in an asynchronous manner.
You can also take hot online backups with Cluster. These are only needed when you have a total cluster failure resulting in loss of the disks or when there is a user failure (ie. DROP DATABASE by accident). Read
http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Backup.html for more info.
Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com