5 messages in com.mysql.lists.clusterreplication question
FromSent OnAttachments
Jim Hoadley13 Sep 2004 17:43 
Mikael Ronström24 Sep 2004 01:23 
Igor25 Sep 2004 07:06 
Devananda27 Sep 2004 10:33 
Magnus Svensson28 Sep 2004 01:30 
Subject:replication question
From:Jim Hoadley (j_ho@yahoo.com)
Date:09/13/2004 05:43:11 PM
List:com.mysql.lists.cluster

I understand that replication can be used with MySQL Cluster. I'd imagine one use might be the replicate the cluster (MASTER) to a single-box (SLAVE), and to use the slave for offline backups. Three questions.

1) if the MASTER table is type=NDB, does it have to be type NDB on the SLAVE as well?

2) if so, could you have a 1-node cluster?

3) what's the benefit of using MySQL Cluster's built-in BACKUP functionality versus using a SLAVE dedicated to backups?

Thanks for any responses.

-- Jim