Enterprise Replication
Howard Rock asked whether Enterprise Replication on Informix 7.23 suits a hot-site backup and whether the target needs identical hardware. Art S. Kagel advised against it before 7.31 and thought replicants need not be identical. Larry Redmond asked about 7.30.UC8 and update-anywhere versus primary-target. Art said it was reliable except in the earliest 7.30 releases, and 7.31 improved compression and overhead.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
My company is looking into Enterprise Replication for Informix 7.23 for a hot site backup. My first 2 questions are: Is this an appropriate vehicle for a hot site backup? Do we need the same type of server ( or another server with the same power) in order to replicate the entire database as a hot site backup)? Thanks in advance, Howard E. Rock
"Rock, Howard" wrote: > > My company is looking into Enterprise Replication for Informix 7.23 for a > hot site backup. My first 2 questions are: I would not use EDR before Version 7.31. > Is this an appropriate vehicle for a hot site backup? Yes. > Do we need the same type of server ( or another server with the same power) > in order to replicate the entire database as a hot site backup)? I think that with EDR the replicants do not have to be identical. Art S. Kagel
I am Looking to do the same thing but I have concerns. We are on 7.30.UC8 for NCR but are moving to Sun Sparcs in the near future. "Art S. Kagel" wrote: > "Rock, Howard" wrote: > > > > My company is looking into Enterprise Replication for Informix 7.23 for a > > hot site backup. My first 2 questions are: > > I would not use EDR before Version 7.31. Is it that previous versions are unreliable in your experience? > > > > Is this an appropriate vehicle for a hot site backup? > > Yes. In this situation should we be following a the 'update anywhere' model or is the primary-target OK. I am reluctant to use the former as (I imagine) it will mean some serious re-engineering of applications re serial fields. > > > > Do we need the same type of server ( or another server with the same power) > > in order to replicate the entire database as a hot site backup)? > > I think that with EDR the replicants do not have to be identical > > Art S. Kagel Larry Redmond Team leader Unix System Administration and DB administration, Orange Telecoms Australia
EDR seems to be safe an reliable in all but the earliest 7.30 releases, much more so than any of the 7.2x releases by reports, but the 7.31 releases add new compression options, greatly reduce communications overhead and handshaking overhead, and generally improve the process and its speed. These were specific 7.31 design goals and seem to have been met very well. Art S. Kagel larryr wrote: > > I am Looking to do the same thing but I have concerns. > > We are on 7.30.UC8 for NCR but are moving to Sun Sparcs in the near future. > > "Art S. Kagel" wrote: > > > "Rock, Howard" wrote: > > > > > > My company is looking into Enterprise Replication for Informix 7.23 for a > > > hot site backup. My first 2 questions are: > > > > I would not use EDR before Version 7.31. > > Is it that previous versions are unreliable in your experience? > > > > > > > > Is this an appropriate vehicle for a hot site backup? > > > > Yes. > > In this situation should we be following a the 'update anywhere' model or is the > primary-target OK. I am reluctant to use the former as (I imagine) it will mean > some serious re-engineering of applications re serial fields. > > > > > > > > Do we need the same type of server ( or another server with the same power) > > > in order to replicate the entire database as a hot site backup)? > > > > I think that with EDR the replicants do not have to be identical > > > > > Art S. Kagel > > Larry Redmond > Team leader Unix System Administration and DB administration, > Orange Telecoms Australia