MySQL Forums
Forum List  »  NDB clusters

Autodiscovery of databases
Posted by: Laurence Praties
Date: August 25, 2005 03:57AM

Hello,

I'm trying to set up my first mysql cluster at work. It's all looking good, the management node reports that everything is connected properly, and i have loaded some data into the sql node.

My problem is this:

<quote>
It is important to note that NDB Cluster in MySQL 4.1 and MySQL 5.0 does not support autodiscovery of databases. This means that, once the world database and its tables have been created on one data node,you will need to issue the command CREATE DATABASE world; (beginning with MySQL 5.0.2, you may use CREATE SCHEMA world; instead) followed by FLUSH TABLES; on each data node in the cluster
</quote>

As far as I am aware, the data nodes only run ndbd and no instances of mysqld. If this is so then how do I issue commands (create database and flush tables) to them? I've looked through the documentation and some of the forums but couldn't find any info, however there must be plenty of people who know what to do - am I just missing something glaringly obvious?

Regards,

Laurence

Options: ReplyQuote


Subject
Views
Written By
Posted
Autodiscovery of databases
2428
August 25, 2005 03:57AM
1545
August 25, 2005 04:35AM
1544
August 25, 2005 05:32AM
1439
August 25, 2005 06:33AM
1562
August 25, 2005 09:05AM
1565
August 25, 2005 07:48PM
1646
August 25, 2005 07:30AM


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.