MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Re: Recommended configurations - sql node per webserver?
Posted by: Matthew Montgomery
Date: January 18, 2009 03:59PM

Firstly, 3 data nodes is not recommended. The number of data nodes must be a multiple of NoOfReplicas, and NoOfReplicas = 2 is the recommended number.

Localhost connection to the database is one less network hop to contend with. Network latency is a common culprit for ndbd performance. I've been told that under the single threaded ndbd, the ratio of SQL to NDBD nodes which provides the best of concurrency and total throughput was 8:1. In this situation I'd say probably the higher number of SQL nodes you have the better performance you will see.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Recommended configurations - sql node per webserver?
2655
Daniel Bambach
January 18, 2009 08:56AM
Re: Recommended configurations - sql node per webserver?
1716
Matthew Montgomery
January 18, 2009 03:59PM
Re: Recommended configurations - sql node per webserver?
1691
Alejandro Cavallo
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.