2 messages in com.mysql.lists.clusterRe: create and delete ndbcluster tables
FromSent OnAttachments
ca X30 May 2005 14:01 
Jon Stephens31 May 2005 11:43 
Subject:Re: create and delete ndbcluster tables
From:Jon Stephens (jo@mysql.com)
Date:05/31/2005 11:43:23 AM
List:com.mysql.lists.cluster

Cluster does not do autodiscovery of schema and table changes.

You need to execute a SHOW TABLES following any CREATE, DROP, or ALTER command in order for all nodes to 'see' the change. This is by design.

ca X wrote:

Hi, I am doing some tests on mysql cluster and I got this issue: I have 2 sql servers 1 mgm and 4 ndbs.

On sql server A I create a table and then I delete it. on sql server B such table was created and deleted, but If a try to create same table through sql server B I got "table already exist" message. If I run desc command I got "table does not exist" message.

any clue?

thx,

Jumpstart your cluster! http://www.mysql.com/consulting/packaged/cluster.html