MySQL Forums
Forum List  »  NDB clusters

Recommended configurations - sql node per webserver?
Posted by: Daniel Bambach
Date: January 18, 2009 08:56AM

In a proposed environment for a client, we have been considering a configuration of 3 or 4 data nodes, 2 management nodes, and between 4 and 8 web/ application servers that we were considering putting the sql nodes on... (so each app server would connect to the its localhost mysqld to query the cluster)

Each sql node would connect to all three/ four data nodes to distribute queries.

Does anyone know of any good reasons not to do this? - it seems to remove the need to load balance fewer sql nodes, and the only disadvantage is that things like query caches are local to each application server, rather than being shared.

Any thoughts greatfully received.

Options: ReplyQuote

Written By
Recommended configurations - sql node per webserver?
January 18, 2009 08:56AM

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.