Re: NDBD storage node configuration & synchronisation

[ian.sparrowhawk]

Hi Hamid,

Thanks for your response, I did as you suggested and created the world database on the SQL node but unfortunately I now just get a "Table 'world.City' doesn't exist" complaint instead. The tables do exist and contain data on both of the NDBD storage nodes and

Any idea what else the problem might be?

It does seem odd to me that the database also needs to be created on the SQL node, any idea why this should be? The on-line documentation does indeed suggest that the database shoudl also be created on each and every SQL node but in another post (http://forums.mysql.com/read.php?25,25333,25422#msg-25422) Jon Stephens suggest that this is not the case and that the procedure is:

1. create the database and the tables on one storage node
2. create the database and run FLUSH TABLES on each of the other storage nodes
3. load the data via the SQL node"</b>

Thanks again for your help,

Ian