Re: Data Replication

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. ---------------------------------------------------------------------------- Bill Glidden Sr. Advanced Support Engineer E-mail: glidden@informix.com Advanced Support (415) 926-6904 Informix Software, Inc. ----------------------------------------------------------------------------