[consulting] Distributed Loads, Failover and Dynamic Content

[Allie Micka]

On Jul 14, 2006, at 7:41 PM, Hugh Esco wrote:
> We're looking at rsync and such for static content.  But
> I'm curious what strategies others might be pursuing for
> syncing two or more servers which are hosting mirrored
> content on dynamic platforms which are subject to local
> manipulation between changes.

MySQL has built-in database replication, and it's relatively easy to  
set up.  You can set it up in a multi-master configuration, which  
allows both locations to update content in their copy.

We've been doing this for hot realtime backups, and are beginning to  
work with this configuration as multi-master on Drupal sites.  We had  
to replace the db_next_id function to use auto increment instead of  
table locks, but otherwise, it seems to be working out.



Allie Micka
pajunas interactive, inc.
http://www.pajunas.com

scalable web hosting and open source strategies

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/consulting/attachments/20060715/0a31c726/attachment.htm