"Mirroring two databases - one offline - one online.......
Our live database is currently running Informix 5.x (soon to be 7.X) Each night, the database is put into 'quiescent' mode while the backup occurs. I would like to be able to have a "mirrored" copy of this database on-line so that when the backup completes (and is put back into multi-user mode) that any changes that were made to the "copy" are automatically reflected to the live system. eg. A person may change an address on the "copy" while the backup is being performed - this address change would reflect itself on the live as soon as the "live" is back on-line. The "copy" database would not necessarily need to be Informix but preferably so. Is this possible? Where can I found out more about doing this? Regards - Adam
In article <01be37a7$ccab5840$2d0110ac@adamb>, "Adam Bradley" <adam.bradley@ahmg.com.au> wrote: > Our live database is currently running Informix 5.x (soon to be 7.X) > > Each night, the database is put into 'quiescent' mode while the backup > occurs. > > I would like to be able to have a "mirrored" copy of this database on-line > so that when the backup completes (and is put back into multi-user mode) > that any changes that were made to the "copy" are automatically reflected > to the live system. > > eg. A person may change an address on the "copy" while the backup is being > performed - this address change would reflect itself on the live as soon as > the "live" is back on-line. > > The "copy" database would not necessarily need to be Informix but > preferably so. > > Is this possible? Where can I found out more about doing this? > > Regards - Adam > Adam, It sounds like you are talking about HDR. High availablity Data Relication (or something close to that). One system is set up as the primary system and another as the secondary. Every action you make on the Primary system is reflected on the secondary, automatically. It's also important to note that you can archive the database while it is on-line provided you have enough log space for the activity. I have Informix 7.3 with Solaris 2.6 set up where the Primary system has the data entry folks loading data and the secondary "read only" system for the users who only request data. Yes its possible and I beleive the information is in the Guide to Enterprise Replication Good luck -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Adam Bradley wrote: > Our live database is currently running Informix 5.x (soon to be 7.X) > > Each night, the database is put into 'quiescent' mode while the backup > occurs. > > I would like to be able to have a "mirrored" copy of this database on-line > so that when the backup completes (and is put back into multi-user mode) > that any changes that were made to the "copy" are automatically reflected > to the live system. I hope this isn't a stupid question, but why not just do on-line backups? If you didn't put the live database in 'quiescent', you wouldn't need a mirror on-line. Sounds like an awfully cumbersome process. Granted, Informix HDR or ER could be used to make it easier (maybe), but it still seems like needless aggravation. Or is that just me being naive? June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plain)