Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
From: "John C. Turnbull" <ozemale@ozemail.com.au>
To: "'Derby Discussion'" <derby-user@db.apache.org>
References: <3f88e2aa0709180129p4b219bpa6421b5334e93ab@mail.gmail.com>
 <56a83cd00709181017o2a08e43fp6af4aaaeeaf1c06f@mail.gmail.com>
In-Reply-To: <56a83cd00709181017o2a08e43fp6af4aaaeeaf1c06f@mail.gmail.com>
Subject: RE: Derby and replication
Date: Wed, 19 Sep 2007 23:04:29 +1000
Message-ID: <000f01c7fabd$9db81b80$d9285280$@com.au>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
thread-index: Acf6F9d/UKFeilCCT1i5xCJlkN5IXgAo53kw
Content-Language: en-au

I am investigating the ins and outs of a system that consists of several
JVMs running on possibly separate machines all manipulating separate
instances of Derby that collectively are kept in synch - somehow.  Does
anyone know of a possible solution to the synchronisation side of things =
or
am I dreaming?  I am not sure if HA-JDBC or Daffodil Replicator can =
handle
the inter-machine communication issues.

-JCT

> -----Original Message-----
> From: david.vancouvering@gmail.com
> [mailto:david.vancouvering@gmail.com] On Behalf Of David Van Couvering
> Sent: Wednesday, 19 September 2007 03:17
> To: Derby Discussion
> Subject: Re: Derby and replication
>=20
> I think the responses you have heard so far talk about replication to
> provide availability (HA-JDBC, the ongoing Derby effort).
>=20
> What you are talking about is basically using Derby as a reliable
> front-end cache to a back-end database where the connection can be
> unavailable from time to time.
>=20
> What this is about is really synchronization, not replication.
> Synchronization is keeping two sometimes disconnected databases in
> synch.
>=20
> One product out there that works with Derby is Daffodil Replicator,
> see http://sourceforge.net/projects/daffodilreplica/.  It's an open
> source project using the GPL license.
>=20
> David
>=20
> On 9/18/07, ad marginem <admarginem@gmail.com> wrote:
> > Hello,
> >
> > I want to develop a program, using derby as a back-end.
> >
> > There will be a POS and a Warehouse module. They will use the same
> database
> > scheme, but they cannot use the same database because of reliability
> (in
> > case of broken connection the POS must not stop).
> >
> > So my question is: how to develop such a reliable workflow?
> Replication? Or
> > maybe there are some other options? If replication - how to =
implement
> it?
> > Are there any existing methods to replicate derby database?
> >
> > Thank you!
> >
> >
> > --
> > =D0=CF =CB=D2=C1=D1=CD