[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] database replication with bucardo
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] database replication with bucardo |
Date: |
Thu, 5 Jul 2012 08:24:03 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Wed, Jul 04, 2012 at 10:15:34PM +0000, Jim Busser wrote:
> Is the replicated record intended to exactly mirror every datum *except* the
> pk which gets newly-assigned by the contextually-child system?
>
> For example. suppose GNUmed was cloned via Bucardo at the point when GNUmed
> had only 11 patients, and now in one system Kirk is created (being assigned
> pk 12) at the same moment as -- in the other system -- some other "new
> patient" is being created (also assigned pk = 12).
>
> This results in two systems whose data content
>
> - except for the pks, will always always the same
>
> but pks will
>
> - be different, in the situation of any latency (or lag-time or transient
> disconnection) between syncs, during which there had been table alterations
> at both ends
>
> - at the end of a sync, achieve the same sequence number at both ends, with
> the possibility of remaining the same (in sync) for those records which alter
> a given table only at one end between syncs
>
> and this is ok because one would never expect a cross-database search to have
> meaning?
Bucardo needs to contain code to either mediate or prevent
such situations or else it is not fit for purpose.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] database replication with bucardo, Slappinjohn, 2012/07/04
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/07/04
- Re: [Gnumed-devel] database replication with bucardo, Busser, Jim, 2012/07/04
- Re: [Gnumed-devel] database replication with bucardo,
Karsten Hilbert <=
- Re: [Gnumed-devel] database replication with bucardo, Busser, Jim, 2012/07/05
- Re: [Gnumed-devel] database replication with bucardo, Sebastian Hilbert, 2012/07/05
- Re: [Gnumed-devel] database replication with bucardo, Sebastian Hilbert, 2012/07/05
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/07/05
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/07/06
Re: [Gnumed-devel] database replication with bucardo, Busser, Jim, 2012/07/04