8 messages in com.mysql.lists.clusterRe: Memory issues with MySQL Cluster
FromSent OnAttachments
Gbenga Bello12 Mar 2005 15:24 
Mikael Ronström14 Mar 2005 01:11 
Martin Skold14 Mar 2005 01:13 
Ira Abramov14 Mar 2005 03:29 
Alex Davies14 Mar 2005 03:35 
Mikael Ronström14 Mar 2005 04:37 
Martin Skold14 Mar 2005 04:45 
Sancho2k.net Lists14 Mar 2005 06:25 
Subject:Re: Memory issues with MySQL Cluster
From:Sancho2k.net Lists (lis@sancho2k.net)
Date:03/14/2005 06:25:21 AM
List:com.mysql.lists.cluster

Mikael Ronström wrote:

Databases are not "auto-discovered". Thus if you create a database you need to create it on all MYSQLD's. Tables are "auto-discovered" so they show up immediately after being created on another machine when requested by an SQL command.

6)How can I manage database and tables created from one interface (MySQLQ) using a different interface or how do I make several mysql prompt or mysqld view all database and tables residing on the cluster

Ensure that all databases created are created at all MYSQLD's. After that all MYSQLD's see the same view of the system.

Is it generally accepted that identical grant tables are maintained on each MYSQLD node as well, or do ppl generally centralize the tables from the mysql database in NDB as well?

For example, if we bring a new mysqld into the cluster and we have a lot of grants to handle connections, will we want to duplicate that on the new SQL node or should it be set up to autodiscover?

DS