Rubyrep looks very interesting, I just watched their 5min video and looks very easy to setup.
Few questions.. The left/right database looks very limiting (you can only replicate two databases at a time).. Their documentation says that the solution is to setup a chain. To keep A, B and C in sync, A should replicate with C and B should replicate with C: http://www.rubyrep.org/replication_between_more_than_two_databases.html There will be a set of triggers for each replication. Since MySql doesn't support more than one trigger on a table, this approach won't work which I guess is their way of saying "We're database independent, as long as you use either Postgres or MySql oh and btw we have no replication story above 2 nodes on MySQL" Also, if database C goes down, then everything goes kaboom, right? Even if you did A replicates with B, B replicates with C, if one database goes down your chain is broken. I'm worried about this scenario, and any perf implications with having a whole bunch of triggers on a table. Maybe someone can comment. Mike On Mon, Jun 22, 2009 at 10:23 PM, Arndt Lehmann <arndt.lehm...@gmail.com>wrote: > Hi Craig, > > just wanted to mention that there is a new open-source solution > available that now also enables asynchronous, row-based, master-master > replication of PostgreSQL databases. > > Name: rubyrep > > Project website with full feature list, step-by-step tutorial and > screencast (from zero to running replication in under 5 minutes) > available here: > http://www.rubyrep.org > > Best Regards, > Arndt Lehmann > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
