MySQL Forums
Forum List  »  NDB clusters

Re: Adding a new SQL node to a mysql Cluster
Posted by: Matthew Montgomery
Date: January 21, 2009 09:34AM

You SHOW ouput indicates a 5.0.32 cluster not (mysql-5.1.30 ndb-6.3.20) as you stated above. Autodiscovery of databases is not supported under 5.0 only 5.1 and later versions. You should not copy directly the directories and .frm files from one SQL node to the other. Instead you should, on the new SQL nodes, issue CREATE DATABASE for each database containing tables in the cluster. You then issue FLUSH TABLES to cause mysql to reconnect to the cluster and get the DBDICT info for those tables.

See: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations-resolved.html
Section "Database autodiscovery and online schema changes."

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Adding a new SQL node to a mysql Cluster
2275
January 21, 2009 09:34AM


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.