On 27 Feb 2006, at 02:34, pat@linuxcolumbus.com wrote:
6. Do MySQL replication
By this do you mean geographically seperate web servers?
Not necessarily. You can use MySQL replication and clustering for (at least) two reasons: 1. Redundancy. You can use MySQL's replication functionality to have a backup database. It's a "hot spare" so it can take over instantly without downtime. No need to restore a backup from tape. Depending on the amount of "replication traffic" and your internet connection, different database servers could be in geographically separate locations. 2. Performance. You can use MySQL's replication functionality to scale your database layer. You can use it to distribute the workload among multiple database servers that are exact copies of one another (load balancing). Occasionally companies use geographically separate servers to improve performance; by bringing the data closer to the user's geographical location you can eliminate some network latency. -- Dries Buytaert :: http://www.buytaert.net/