[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Approaches to maintain clinical data uptime

From: Tim Churches
Subject: Re: [Gnumed-devel] Approaches to maintain clinical data uptime
Date: Sat, 29 Apr 2006 21:35:22 +1000
User-agent: Thunderbird (Windows/20060308)

Karsten Hilbert wrote:

> 1) Slony continually replicates GNUmed database from primary
>    to slave DB on identical secondary 

Have any GNUmeders had any real-life experience with Slony-1? It is hard
to find any stories, good or bad, about it. We were about to test it to
implement a hot spare DB for our NetEpi application (which uses PG
back-end storage), so I read the documentation and realised that Slony
doesn't replicate schema changes - if the schema changes on the master,
you need to a) take the slaves offline b) do a manual dump of the master
and restore it to the slaves c) restart slave synchronisation. That was
a show-stopper for us, since one of the main features is that data
collection forms and their underlying tables can be defined on-the-fly
(I keep wondering whether we should have used an EAV pattern for storage
- Slony would have worked with that..).

Tim C

reply via email to

[Prev in Thread] Current Thread [Next in Thread]