Unsolved
This post is more than 5 years old
28 Posts
1
1364
VPLEX Metro with SQL
How does VPLEX Metro wok with MSSQL, as MSSQL is not Active/Active? If the storage array in Site A failed how would Site B handle this from a SQL perspective? I understand how it works with RAC, but fuzzy on MSSQL. It seems there is 0 documentation on MSSQL and VPLEX.
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
April 1st, 2013 08:00
Assuming the SQL DB is clustered with MSCS or WSFC, VPLEX Metro will synchronously replicate the data and LUNs will be r/w at both site. SQL DB is active/passive so the database will live on one site or the other and not be distributed across both sites. If the database lives on site A and it fails, the cluster software automates the movement of the resources to site B with a quick restart (no LUN trepass, failover, or manual intervention).
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
April 18th, 2013 11:00
You are absolutely correct. VPLEX does not make MS SQL an active/active database.
VPLEX Metro enables HA for the underlying storage infrastructure across sites, which in turn enables a stretched HA MS Cluster(or any supported cluster). MS SQL instances can run on any node within that cluster and provide the ability to use MS Cluster technology to failover without any intervention to the end user across sites.