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