Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Microsoft Virtualization Discussions

SQL 2008 and MetroCluster

netappdaxon99

I'm referencing the NetApp Solution Guide, "Microsoft Exchange Server, SQL Server, SharePoint Server Mixed Workload on Microsoft Hyper-V and NetApp Fabric MetroCluster" and have some questions.

Based on my reading the solution is a four-node Microsoft Hyper-V multisite failover cluster with two nodes at each site running as an active-passive cluster (p. 6).

I'm assuming that the Hyper-V cluster is a geocluster (different subnets) and not a stretched VLAN (same subnet for both sites). Is that correct?

The solution relative to SQL 2008 calls for two SQL 2008 VMs (p.8) but it doesn't indicate that the SQL vms are clustered. I don't really get the SQL server setup. These are non-clustered SQL servers which seem to both be live at the same time and seem to be accessing the same data (e.g: "Separate aggregates are created for Exchange Server and SharePoint Server in site A and SQL Server and SharePoint are served from a single aggregate in siteB"). So both sites have live data and both sites have live SQL servers (which don't seem to be aware of each other). Also, since these SQL servers aren't clustered and therefore don't have application HA but only the HA provided by being vms on a HA Hyper-V server which is in a failover cluster how is the solution a site-resilient HA solution?

The document does mention that the VMs are hosted on NetApp iSCSI-based storage, which would be a requirement for clustering of Hyper-V guest VMs but, as I mentioned, I don't see any reference to the guest VMs being clustered.

I'd appreciate any clarification on the MetroCluster setup in general, SQL server HA as part of a MetroCluster and pointers to some in-depth MetroCluster documentation which I have not been able to locate on my own.

Thanks

2 REPLIES 2

SKROFKNWLDG

Has this been answered? I am interested in the same scenario(s).

I am digging through the documentation to see if I can find an implementation scenario of two SQL servers, both active, at two different physical locations on a stretched LAN.

Thanks.

abhisek

Hi ,

Can you let me know the layout and architecture that you have ? Also if you can provide the exact TR number where you are referencing then that would be very helpful.

Regards,

Abhishek

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public