Near-FT Support of OLTP Applications using a HA StarWind Virtual SAN and a Hyper-V Cluster
This document presents openBench Labs assessment of the performance of a StarWind High Availability (HA) Virtual Storage Area Network (Virtual SAN) in a Microsoft® Hyper-V® failover cluster and provides technically savvy IT decision makers with the detailed performance and resource configuration information needed to analyze the trade-offs involved in setting up an optimal HA configuration to support business continuity and any service level agreement (SLA) with line of business (LoB) executives.
- 3 Windows Hyper-V host servers: 2 x Dell PowerEdge R2950 with Windows Server 2012 R2, 1 x HP DL580 with Windows Server 2012.
- StarWind’s iSCSI Virtual SAN software on each Hyper-V host
- iSCSI quorum disk in our 3-node HA Virtual SAN
A Hyper-V failover cluster was configured using the two hosts running Windows 2012 R2 and a quorum disk that would remain available if either or both of the Hyper-V failover cluster nodes failed.
A vSphere® 5.5 VM was introduced running StarWind to create a 4-node Virtual SAN to deploy shared storage resources for deploying near fault tolerant (FT) VMs on the Hyper-V cluster.
For assessing the performance of HA storage, a common IT scenario was used: a SQL Server database running an OLTP business application.
OLTP Stress Test scenario: Based on Transaction Processing Performance Council’s TPC-E benchmark on a VM dubbed oblHA-SQL, customers of a brokerage firm run SQL transactions to research market activity, check their account, and trade stocks, while brokers execute customer orders and update client accounts. To simulate external customers and internal traders, another VM creates and launches SQL queries based on ten templates, which are customized using a random number generator. Estimated parameters: Average execution rate in transactions per second (TPS), average response time for all queries.
HA Virtual SAN Crash Dynamics: test results are given for Crash, Synchronization, and Full Recovery stages.
HA Hyper-V Cluster Dynamics: Using Hyper-V live migration, IT administrators are able to move VMs between hosts in a Hyper-V cluster with minimal service interruptions. Hyper-V Cluster Dynamics are tested by moving the test VM, oblHA-SQL, between two Hyper-V cluster hosts, Dell2950A and Dell2950B, while the OLTP business application was running.