Saturday, June 18, 2011

How to: Informix HDR using infx services

While infx itself does not contain any services for Informix database replication, it can still be used to simplify the process.

The Informix High Availability Data Replication (HDR), is used to replicate all the databases in an Informix instance to another host. Informix Enterprise Replication (ER) is used to replicate individual databases and tables.

In this example I will show how to setup Informix HDR with infx services. The example assumes that Informix and infx are already installed on both servers.

The basic process is:

  1. create a new instance on the second server
  2. modify it to be a secondary instance
  3. copy the primary instance data with the hot copy service
  4. start HDR on the secondary
  5. start HDR on the primary