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/...mitations.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