SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2012 Active/Active Cluster in Hyper-V


SQL Server 2012 Active/Active Cluster in Hyper-V

Author
Message
Paul Brewer
Paul Brewer
SSC Eights!
SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)

Group: General Forum Members
Points: 989 Visits: 1335
Comments posted to this topic are about the item SQL Server 2012 Active/Active Cluster in Hyper-V
Carpe Datum
Carpe Datum
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 97
Unless there is a new 2012 feature that hasn't been well advertised, SQL Server does not do active/active clusters.

You have created two SQL instances which are active/passsive on different servers, i.e. multi-instance. But the instances are not active/active.

Also, there is little high-availability gained here because all the VMs are on the same host hardware. The use of an iscsi VM represents a single point of failure on the same hardware even if you put the cluster vms on separate hosts.
Paul Brewer
Paul Brewer
SSC Eights!
SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)

Group: General Forum Members
Points: 989 Visits: 1335
The article suggests routing SAN related disk IO over your virtual IP Network. If a million records were inserted in a table, the network would be flooded and any other users/processes would be hammered. That seems to me the biggest issue although it should be possible to configure the virtual iSCSI NIC to use a dedicated physical LAN.

The ideas in the article are intended to provoke thought and consideration of the possibilities offered by iSCSI SANs. Brent Ozar wrote an article recently about running SQL Server from network shares using trace flag 1807, Brents suggestion involves a lot less work to implement but perhaps, offers less resilience.


Regards
Paul
rfr.ferrari
rfr.ferrari
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3105 Visits: 13645
very good article, Paul!!!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Paul Brewer
Paul Brewer
SSC Eights!
SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)

Group: General Forum Members
Points: 989 Visits: 1335
Thanks very much Rfr, it was fun writing it.
rfr.ferrari
rfr.ferrari
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3105 Visits: 13645
sqlservercentral-622386 (2/13/2012)

Unless there is a new 2012 feature that hasn't been well advertised, SQL Server does not do active/active clusters. .....


the A/A cluster on SQL Server is possible when we talking about HA and not HP!! the scene designed by Paul, for each instance that is avail on node, you would configure half of resources server to SQL Server, i.e. the server has 8 Gb RAM and 8 cpus, then to SQL this instance would have 4 Gb RAM and 4 CPUs and same configuration for other node!!!

when one node fails the other takes full workload!!!

Now, the load balance of workload, users and databases between sql servers, is a job of DBA!!! where is possible configure A/A cluster for HA!!!

For HP, only Windows 2008 R2 HPC, when we want performance of both servers in specific task!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

quackhandle1975
quackhandle1975
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5445 Visits: 1244
Great article, I am looking to build the same clustered environment using SQL 2008 R2/Win2008 R2 Server & virtual box.

qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
Paul Brewer
Paul Brewer
SSC Eights!
SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)SSC Eights! (989 reputation)

Group: General Forum Members
Points: 989 Visits: 1335
http://www.sqlskills.com/blogs/jonathan/post/Failover-Clustering-without-a-SAN-SQL-Server-2012-and-SMB-for-Shared-Storage.aspx

This is also a good method.

Regards
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search