As you know in Windows Server you can use the local storage in you cluster and you can also replicate storage between two Servers.
But what if we combine these two options ? seems logical and with some advanced config it could work. ok but what if I use Azure for this and better I use a Hybrid config using a Cluster that has also a leg in a on premise will this work ? I don’t think it is supported but cluster validation passed on this so it must be supported. with a *
Ok what Do I need for this :
Azure Subscription – Check
Azure Site – to – site VPN – Check
on-premise Cluster – Check 6 node Cluster
Azure Cluster nodes – Check 2 nodes running in Azure.
Fast Internet line – check
I’m not showing you all the details else it would be a very long blog post and I have already posted on how you can build your Replica and How to use the Storage Spaces Direct Combine them with those Two options.
My Setup is 4 Cluster nodes On Hyper-v on premise and Two node in Azure all running All Running Windows Server 2016.
and basically what I did is Building a cluster with Storage Spaces Direct based on 3 local disk and on top of this I created a 2 Disks that I used for replication.
as you can see I have 26 disk in Node 1 Different Sizes and Shared and non shared disks these are running on my Hyper-v 2012R2 Server
and with the Storage Spaces Direct option my Cluster Would look like this. Hybrid Cluster with all the Best options in Windows Server 2016
My Storage Pools One is running in Azure and On is on premis As for the Replication all replication disk needs to be at the same size.
Sizing difficult in azure So I created first the Azure disk to see what size they are and after that I created the On-premise disks
This is really nice all native Windows Server 2016. the only thing you need is a fast internet line. and Currently the limit is the access to Azure ( if you don’t have Expressroute. )
Seting up the Replication is easy with powershell
New-SRPartnership -SourceComputerName win2015-1 -SourceRGName Azure_group01 -SourceVolumeName u: -SourceLogVolumeName v: -DestinationComputerName win2015-6 -DestinationRGName Azure_group02 -DestinationVolumeName p: -DestinationLogVolumeName Q: -LogSizeInBytes 1gb
My Replication with Storage Spaces Direct in a hybrid Configuration. as you can see with this more configurations are possible and if you make sure the line latency is below 50ms things could work just fine.
But building this is fun but imaging you need to trouble shoot this where are my disk and what is failing things are getting complex and even with the hybrid model extending your Datacenter to Azure is a bit closer.
With todays Fast internet it is easy to build this and hybrid solutions are easy to build especially with windows server 2016 build in Replica and local Storage for clustering. extending your lab or production to Azure and you can demonstrate the high available solutions today. but keep in mind building an troubleshooting can be a pain as environments are getting complex.
Checkout the MVP V-Conf Session
Deploying Highly Available SQL Server in Microsoft Azure IaaS
Download Windows Server Technical Preview evaluations:
- TechNet Evaluation Center (US): http://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-vnext-technical-preview
- TechNet Evaluation Center (worldwide): http://technet.microsoft.com/evalcenter/dn781243
- MSDN subscribers: http://msdn.microsoft.com/en-us/subscriptions/downloads/