Probably what you'll want is the database replication of MySQL 5. Have you
analyzed the the problem to determine specifically what the bottleneck is?
That will determine the best approach. Replication and load balancing is a
bit more risky than simply upgrading hardware (more RAM, faster discs) or
splitting the web and database servers off onto separate boxes.
I'd say database replication should be a last resort. Load balancing
across web servers is do-able. Use the multiple A records in DNS for the
same host name to do poor-mans load balancing. If you have sessions, other
techniques may get complicated.
You could still do a batch replication/synchronization to and keep a warm
spare (possibly off-site) as risk mitigation in case of disaster.
Received on Wed Jul 26 10:08:51 2006
This archive was generated by hypermail 2.1.8 : Fri Sep 08 2006 - 23:26:38 CST