MySQL Forums
Forum List  »  NDB clusters

Re: SQL node not sync after down and up
Posted by: Jon Stephens
Date: December 09, 2019 03:07PM

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.


Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Written By
November 18, 2019 08:18AM
Re: SQL node not sync after down and up
December 09, 2019 03:07PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.