On Tue, May 09, 2006 at 12:32:41PM -0400, Perrin Harkins wrote: > On Tue, 2006-05-09 at 11:28 -0500, Jeremy Brooks wrote: > > There's also clustering in MySQL 5 that looks very enticing to me as an > > additional layer or scale out and redundancy. It's not your typical > > master/slave scenario and actaully allows for real load balancing and > > failover. > > It's a pretty limited system, as described here: > http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-limitations.html > > No referential integrity and no disk storage (!) are the main issues for
It _is_ stored on disk, save for powerfailures, but all the data needs to fit in ram. So it's limited to the amount of ram you can give mysql. > me. It might be okay for transient data that you don't care about > losing if the power goes out. > > - Perrin > -- The Moon is Waxing Gibbous (88% of Full)