MySQL Forums
Forum List  »  NDB clusters

MySQL Cluster Load
Posted by: Loulou Reykjavik
Date: February 13, 2009 06:51AM

Hi,

I've setup a MySQL cluster (mysql-cluster-gpl-6.3.20) with 2 NDB nodes, 1 NDB_MGMD node and 2 SQL (API) nodes. Evrything works fine and is fault tolerant, it's cool :)
I just wanted to know something I'm not sure to have understood :
When a SQL query is executed, which node will proceed and execute the query? an API node or a data node?
I'd like to know which node of my cluster will get the charge (CPU/RAM usage)? I mean : my database will have more and more access and sql query to execute, so, will I have to add API nodes or data nodes to support the load?

I hope I've been clear...
Thanx for any suggestions, I have to have this kind of information before being in production ;)

Best regards,

Hindisvik

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Cluster Load
3040
February 13, 2009 06:51AM
1738
February 13, 2009 09:00AM
1852
February 13, 2009 11:01AM


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.