That mirroring stuff is designed with the idea that one data center will lose power or be destroyed by terrorists.
However, if the database becomes corrupt, and you are using physical mirroring, you now have two copies of a corrupt database in two data centers. And we have found that bugs in the software are far more likely to happen than losing a data center.
It creeps me out to even be near there. Bad karma, yo.
What you didn’t get the memo from management? The software testing budget has been cut by 50%, blame the programmers.
That depends on the software and array you are using. The company I work for uses proprietary protocols for several mirroring software systems that prevent that sort of thing. Well, not so much prevent as make it easily recoverable to point-in-time when the corruption happens.