[development] Re: enterprise needs

[Dries Buytaert]

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