Recommended configurations - sql node per webserver?
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.
D.
Subject
Views
Written By
Posted
Recommended configurations - sql node per webserver?
2657
January 18, 2009 08:56AM
1718
January 18, 2009 03:59PM
1691
January 21, 2009 06:27AM
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.