Re: Replication Question
Posted in 1998
Topics: High Availability & Replication, Jobs, Consulting & Announcements
An HDR solution is workable here, although not recommended, if they can run off of one server all the time. You're right, one server is read-only, until a failure, in which case it becomes read/write until the other returns. If the data sets are mutually exclusive, you could also set up two engines on each machine (one local, and one a remote replicate) such that either side is always accessing a local database so long as both machines are up. If one goes down, the replicate is accessed. Now, if you're using Enterprise data replication, then both sites can be read/write simultaneously, but you open yourself up to more potential database inconsistency issues. In any case, any of the above solutions will chew a LOT of bandwidth, so you'd want a channel dedicated to the replication process. I don't believe you need any extra software so long as you're using ODS 7.22 or higher. I don't know enough about OWGS to comment. HTH, - Thomas J. Girsch Database Systems Manager Arch Communications Group, Inc. Rob Prop wrote in message <34B14377.45B2@concepts.nl>... > > My questions are: > - Does anyone have a solution ? > - Can this be done with Enterprise Replication ? > - Is it possible to synchronise the databases at night ? > - Is it wiser to set up 2 different env. with a backup on the > remote machine ? > - Which software do I need, can I use OWGS or does I need ODS ? > - Do I need exra software (for the replication etc.) ? > > Thank you very much in advance, help me I'm stuck !!! > >-- > =============================================================== > Rob Prop Tel. : +31-164-255300 > Consultant Fax. : +31-164-246162 > Informa Automatisering bv Email: rprop@concepts.nl > Bergen op Zoom informa@pi.net > The Netherlands Web : http://www.informa.nl > ===============================================================