Re: Data Replication

In article <4i0jni$8e1@news.informix.com>, glidden@informix.com (Bill Glidden) wrote: >Tamara Winburn (tamara@shop.internet.net) wrote: > >: Assuming that there is a defined PRIMARY and a SECONDARY my question is this. > >: Knowing that the two machines are always syncing to each other, data >: inserted from users on the net into the PRIMARY database/server will sync to >: the SECONDARY database/server, will the same be true if data is inserted >: into the SECONDARY? Will it sync to update the PRIMARY of the data added to >: it? Thus eliminating internal activity on the PRIMARY altogether. > >Tamara, > >The short answer to your question is no. The long answer is this: >Currently, the OnLine data replication is one-way, primary gets >replicated to the secondary. Additionally, the secondary server >is in a read-only mode, so you aren't even able to insert data >into the secondary. You can run queries against the secondary, >as long as these queries do not attempt to modify the database. > Hi Bill, is it possible to make the secondary server to the primary after the primary server had crashed. Is it very difficult to switch the secondary server? We want to use replication to make our databases more reliable. The servers are placed in different buildings, so if the primary server crashed because of fire, the user can continue their work in the building of the secondary server without any great time delay. Do you think, that this is prossible??? Thanks in advance Dirk +----------------------------------------------------------------+ | Stadt Muelheim an der Ruhr | email scheer@stadt-mh.de | | Dirk Scheer / Amt 10-3 | telefon +49 208 455 1006 | | Ruhrstr. 32 | fax +49 208 455 581006 | | D-45468 Muelheim an der Ruhr | | +----------------------------------------------------------------+