2 messages in com.mysql.lists.clusterSome confusions about MySQL Cluster R...
FromSent OnAttachments
Sebastien LELIEVRE07 Aug 2007 01:53 
Jon Stephens07 Aug 2007 10:41 
Subject:Some confusions about MySQL Cluster Replication
From:Sebastien LELIEVRE (slel@tbs-internet.com)
Date:08/07/2007 01:53:39 AM
List:com.mysql.lists.cluster

Hi everyone,

I am trying to set up Replication mechanism for our MySQL Cluster configuration and I am having some troubles understanding the MySQL doc. Here it goes :

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-backups.html

On this doc, distinction between 'slave mysqld' (a.k.a. the API Node concerned by Replication as slave one) and 'slave cluster' is not really clear. More, some statements are pretty confusing, as in point 3 :

Important: A CREATE SCHEMA statement corresponding to each database to be
replicated must be executed on each data node in the slave cluster.

I think there is a misunderstanding between API Nodes (mysqld --with-ndbcluster) and Data Nodes (ndbd), or maybe I am wrong ? Can anyone give me a light on this ?

More, MySQL Cluster Replication over a 'standard' MySQL environnement seems to be possible regards to MySQL HA White Paper. Though, I did not find any clue about this in the MySQL Cluster Replication documentation. Is it possible and how does the ENGINE switch occur ?

Am I missing something ?

Regards,

Sebastien.