[development] Re: enterprise needs

Dries Buytaert dries.buytaert at gmail.com
Mon Feb 27 07:51:33 UTC 2006

On 27 Feb 2006, at 02:34, pat at 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  

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/

More information about the development mailing list