Re: Replication on INFORMIX ?

Clem Akins wrote: > > Bharat asks: > [...] > my quez are : (as seen at page 236, Unleashed Informix by John Mc.Nally, > Glenn Miller, SAMS Publishing) > [...] > >do we need this .... I mean actually this is a mirroring ... not a > >replication enginee ... right? > > Had you bought Carlton Doe's book, the "Informix-OnLine Dynamic Server > Handbook", you'd know that "Unlike disk mirroring...Replication creates > and maintains a complete copy of an instance on a separate physical > server." > > >and also in replication ... we need not to replicate the whole database ... > >only some tables ...and also the hardware and o/s are different ... .... > > as I have seen in other databases ) > >so any idea about this ... ? ... someone please help me on this ... > > You can do this several ways: > > Informix Enterprise Replication (formerly Continuous Data Replication) > Praxis OmniReplicator > Application code Sometimes application code can be cleaner if the replication requires only a sub-set of tables or there is a pattern such as time-series keys in the data that a global generic replication code would never be aware of. We looked at the replication solutions from major vendors and it appeared that the entire database would be rereplicated upon loss of sync. IMHO this seemed unacceptable so we rolled our own perl and routines. Our solution: - replicate some tables only (full non-keyed) - replicate time-series data intellegently - replicate to non-hetrogeneous machines and enviroinments - configure via a directives file Jon Strabala, Quantum Systems