We have used it for a simple mirroring of transaction data. It has worked like a champ so far, but the number of tables is low (less than 10) and the transactions tend to be inserts (common), updates (less so) and deletes rarely, none of them very frequent. The two servers are quite close physically (different racks but the same cage), and the speed of updates is reliable. We've only had to roll over from the primary to the mirror a couple of times, and both times the process was painless (going back the other way when the primary is back up is more of a pain, of course, other replicators are far better at that sort of thing; with dbmirror you have to do it manually.
From: Edward Konetzko [mailto:konetzed(at)linuxworkz(dot)com]
Sent: Tue 3/22/2005 2:34 PM
Subject: [ADMIN] dbmirror
I was wondering if anyone is using the dbmirror stuff that come with
postgres versions >7.3.1. If so what kind of experiences have you had.
I am looking a small number < 10 tables that will contain a lot of very
important data and I would like a way to replicate it.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
pgsql-admin by date
|Next:||From: root||Date: 2005-03-23 03:31:45|
|Subject: Import Database|
|Previous:||From: Edward Konetzko||Date: 2005-03-22 22:34:21|