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 me. It might be okay for transient data that you don't care about losing if the power goes out. - Perrin
