[sqlalchemy] Re: Using multiple databases for reliability (NOT sharding)

2010-12-17 Thread Lloyd Kvam
On Dec 17, 1:21 pm, Michael Bayer mike...@zzzcomputing.com wrote: Doesn't seem like anyone has any thoughts here.   Its certainly not something I've tried, but the general area of study here is multi-master replication:  http://en.wikipedia.org/wiki/Multi-master_replication.   The various

[sqlalchemy] Re: Using multiple databases for reliability (NOT sharding)

2010-12-17 Thread Lloyd Kvam
(Sorry, I mis-clicked before.) I've used MySQL replication for sharing data from multiple databases. You can organize the servers in a loop and configure them to pass along the changes replicated by other servers. Of course if any server fails, the loop is broken until that server is running