Re: Cluster performance

[Anton Aleksandrov]

Johan, I am working at the same issue in our "lab".
We have 6 data nodes (Athlon 3.0 64-bit, 2Gb of RAM each), 3 API nodes (Athlon 2.6 64Bit, 1Gb RAM each). Those 3 boxes with API nodes also run apache webserver to handle web requests - it's some kid of a web cluster, because we also have a special load balancing box with round-robin load balancer. The problem is that MySQL server on API nodes eats all memory (around 70 to 95%!), so not so much is left for poor apache. At this point this is a problem for us, as we thought all load will be on data nodes, so webserver will just handle web requests.
I am also a little bit afraid of Jon Stephens's words that cluster "..is intended to provide high availability and not necessarily high speed.". Actually I've got a dilemma - stay with Cluster and just add more API nodes and keep them apart of webserver or try to move to MySQL 5.0.

If someone has got a good motivated answer - that would be very useful for me..

Thanks,
Anton.