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.

cheers

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

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.