Re: cluster backup - Geert Vanderkelen - com.mysql.lists.cluster

6 messages in com.mysql.lists.clusterRe: cluster backup

From	Sent On	Attachments
Matteo Vadagnini	01 Feb 2008 03:08
Geert Vanderkelen	01 Feb 2008 03:17
Matteo Vadagnini	01 Feb 2008 03:24
Wilersh	01 Feb 2008 03:25
Geert Vanderkelen	01 Feb 2008 03:36
Matteo Vadagnini	01 Feb 2008 03:39

Subject:	Re: cluster backup
From:	Geert Vanderkelen (gee...@mysql.com)
Date:	02/01/2008 03:36:46 AM
List:	com.mysql.lists.cluster

On Feb 1, 2008, at 12:24 , Matteo Vadagnini wrote:

Sorry, I forgot to say some important requirements... I'm using MySQL 5.0 and I need something that I can put on another server, if needed.

Doesn't matter 5.0 or 5.1. ndb_mgm> START BACKUP;

See: http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup.html Does it give problems on your setup?

Files are stored on each data node (check the datadir) which you can copy to other machines and can restore there, into another cluster.

Running a MySQL Cluster not using the online backup is BAD! :) Using mysqldump is half-OK, because you risk to lose integrity.

-Geert

Il Friday 01 February 2008 12:17:29 Geert Vanderkelen ha scritto:

On Feb 1, 2008, at 12:09 , Matteo Vadagnini wrote:

Hi to everyone! What is the best way to do a backup of a mysql custer? I'm using mysqldump, at this moment, but I would like to know if there is a better way to do it.

There is only one way really: ndb_mgm> START BACKUP;

See: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-backup.html

I would only use mysqldump to get the DDL (schema information), just to have it in SQL format. Sometimes handy.

Cheers,

Geert