[consulting] Distributed Loads, Failover and Dynamic Content

[Darrel O'Pry]

On Fri, 2006-07-14 at 21:19 -0500, Allie Micka wrote:
> 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 thanks for pointing that multimaster replication is now possible
with mysql 5... I'm gonna have to play with it :)