Unsolved
This post is more than 5 years old
124 Posts
0
569
March 30th, 2011 06:00
MirrorView Cluster Enabler for SQL server Cluster (Cross-Site)
Hi,
I need a solution for one of my environments where we have SQL server cluster on two sites Site A & Site B and the requirement is to have streched cluster which means Cluster is b/w Site A & Site B SQL servers and they are accessing Storage from Clariion and we have the mirrorview/Sync to be used .
Would anyone please help me understand how MirrorView/CE works incase of SQL server clusters and would this achieve a automatic failover of SQL cluster from Site A to Site B.
Does anybody has any white papers which I can go through ?
Thanks in advance
Rahul
No Events found!
RRR
6 Operator
•
5.7K Posts
0
March 31st, 2011 02:00
The CE is a script that needs to be registered as a cluster resource from which disks need to be dependent. If a cluster failover is triggered the CE resource needs to start on the new active node, it will then perform a MirrorView failover and then the disks on the other side will be brought online. Without the CE resource the cluster tries to bring up the disks on the other side, but since MirrorView doesn't know a failover has been triggered, the new active cluster node won't gain access to the LUNs on that side. The CE resource will do the failover so the new active cluster node will be able to start writing to the LUNs on it's side.
StorageAdmin2
124 Posts
0
March 31st, 2011 03:00
Hi RRR,
Thanks for that reply...
So the failover is automatic and CE takes care of that. I would also want to know what happens in the failback , what is the process ?
I presume it is manual but does CE allow a smooth failback as well ?
RRR
6 Operator
•
5.7K Posts
0
March 31st, 2011 05:00
I must admit that my experience with CE is theoretical, so I don't know the answer. Sorry for that.