Cascaded replication and initializing replicated sites
Posted in 1997
Hello reader, We are currently determining how to apply Informix Enterprise Replication. Currently wee foresee two problems. I would like to know: 1. if anybode has encountered the same problems 2. how these problems were solved First some background information: We are setting up an infrastructure which will consist of 500 remote sites connected to on central site through a low bandwidth, high latency . These 500 servers all are equipped with an Informix server and contains a database which holds a subset of the complete dataset stored at the central site. The following two problems are foreseen: (a) Initialisation of new sites/recovery of crashed sites. There are no standard features provided by Informix to initialise a new site based on the replication definitions. Are there any people that have encountered the same type op problem? (b) Cascaded replication It is not possible to implement cascaded replication, Which means that a tupels that are part of two replication definitions are always replicated correctly. Did anybody design a workaround for this. We could split up the 500 remote sites in multiple replication definition instead of one. Thanks in advance for your time and effort, Greetings, Rob