Re: RAM requirements for cluster
There are workarounds if you need to use 5.0 only. They require architectural changes, but you can use these techniques for the next ~6 months (until 5.1 is released).
Among the techniques is combining replication, clustering, and manual partitioning, and using load-balanced access to data. In these scenarios, you cluster certain data (essentially, everything that's indexed), much like the system does in 5.1, and then you provide replicated access to the rest of the data on disk (often via federated servers).
We have clients that need to do this, unfortunately, but 5.1 will be out soon enough, and they'll be able to move to saner environments. We do NOT recommend using 5.1 in production environments.
--
Jonathan Mischo • Quagility, Inc. • High-Volume Applications Group
jmischo [at] quagility [dot] com
Certified MySQL 5.0 Developer
Certified MySQL 5.0 DBA
DISCLAIMER:
The information in this posting or reply is based on information in this forum and is not guaranteed or covered by an form of warranty. It is a best effort to offer information based on limited data and should not be viewed as a recommendation for action or an exhaustive list of considerations. Neither the author nor their employer takes any responsibility for its content or any actions that may be taken based on this information. If you need professional assistance, please contact the author via email to request a consultation.