Re: SQL node not sync after down and up

[Jon Stephens]

Hi again Davide,

I'm sorry, I didn't read your original question closely enough. Currently, databases are not automatically created on "new" SQL nodes; you must issue a CREATE DATABASE (or CREATE SCHEMA) statement on the SQL node. Once you do this, it should be populated with any tables existing on other SQL nodes.

This is a known limitation of NDB Cluster, but you shouldn't have to put up with it much longer--in NDB 8.0 we've implemented automatic synchronisation of NDB with the MySQL data dictionary. As of the NDB 8.0.18 DMR, this already handles NDB tables, tablespaces, and logfile groups, and is expected to include synchronisation of databases in NDB 8.0 GA.

cheers

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle