Re: database distribution/replication

"Tobin Harris" <comedyharris_at_hotmail.com> wrote:

> > In several countries we have unix data bases in our own format (thus
> > no db/2, oracle or the like), in each case approx. 50'000 of
> > sentences.
> > These data bases are to be synchronized among each other or to one
> > master.
> >
> > Changes in one country should be done in other countries also, quasi
> > live (thus not by night batches). We would like to develop the
> > programs for that.
>
> Are they all permanently connected to the network?

Generally yes. But due to technical problems they may be offline a few hours.

> How many users are there?

Humm....maybe 40 users and 10 users at the same time.

> Do any of the sites 'own' thier own data? Why do offices want to view other
> offices data, just to read it? Or to write also?

Most of them have their own data. But there are 1-2 databases containing *all* data. Normally the offices don't want to see other offices data. But the main branch wants to read and write data of any office.

> Does synchronising your organisatinos data hold any business value, and if
> so can you fight for some budget to buy the tools?

MQSeries for example is very expensive if we have to buy it for every office.  

> If you're stuck with your own format, then you might have to write your own
> engine. You could also consider writing export/import routines to a
> commercial database and using that only for replication ( a kind of
> operational data store).

We have good developers. Thats not the problem. We like to do it. But I'd like to have some ideas (not solutions) from other people how to implement it.

Jens Received on Sat Aug 03 2002 - 15:41:37 CEST