spare server and data mirroring
Posted in 2006
Hi everybody, I want to make a spare db server installation, for disaster recovery purposes, and I'm looking for advices. Our present setup is a single HP-UX machine, running IDS 7.31, all important filesystems and all database chunks are mirrored on two IBM disk arrays, placed in separate locations. Mirroring on the LVM level (no Informix mirrornig is used, OS is HP-UX 11.11). My very rough idea is to add a spare server in the remote location, install Informix software there, configure it to access appropriate filesystems and db chunks, and leave it off, so in case of a disaster in the primary site I could just start IDS on that spare server and have the database available there. No clustering software is available, so switching will be done manually. Does it look reasonable? I'm concerned about data mirroring. If the primary site fails, so that spare server will be enabled and our work will be continued there, and later we want to switch back to the primary site, will the data be synchronized in the correct direction, from that remote copy to the local one? Is there any risk here, that it could go wrong way, and if so, what should take care of to prevent against that? Is the LVM mirroring a safe solution to mirror a database chunks? Are there any licence issues, if the second server will never be up together with the first one, only one copy of the IDS software runnig at any given time? I know this is not a very clean idea, but I have to provide a solution using those available resources. Thanks in advance for any advices. Regards Pawe