Re: Effect of SAN-level replication on Informix

Informix can cope with SAN level replication and recover correctly rolling back partially applied transactions. However, personally I prefer to rely on Informix's RSS or ER replication for what you need. FYI, in case you have not been watching the forums recently, let me repeat: VM's are very bad at IO performance and databases live and die on IO performance. Conclusion? Don't use VMs to host databases - use raw iron. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jul 31, 2012 at 3:54 PM, red_valsen <red_valsen@yahoo.com> wrote: > Does anyone have experience with SAN-level replication and its effect on > Informix, especially with respect to disaster recovery/restore? We're > examining different redundancy schemes of our environment across a WAN > using Redhat Linux 4/5/6, Hitachi SANs, VMware and Informix (and other > DBMSes). Some staff have expressed reservations that SAN-level replication > can adequately substitute for database-style transactions in event of > sudden failure, that data granularity may be too fine, perhaps resulting in > not just failed transactions but referential integrity violations, further > data corruption or simple failure when a failover or restore (at O/S or > instance-level) is required. > > Has anyone dealt with these issues? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >