This Morning I thought why not build a rocking Fast SQL Cluster in Azure. But the Next next Cluster operation is way to easy I decided to build this with the G series and with the Windows technical preview with the latest options. A G5 Server has 32 Cores and 448GB memory and only 6TB disk space. In this demo setup I used 3 G5 Servers and a little disk space
So I created a fresh new network for this.
and later I can create a hybrid S2S VPN to my other Clusters. See My other Blog post about VPN
I Create a DC that is holding my Service Accounts and I use Azure For the Cloud Witness
Check my blog on how to configure Cloud Witness
Doing a quick performance test on the G5 Machine. D and C drive
The same on a A1 machine D and C drive
The G5 CPU
As we Create the Cluster and I added some disk to the Cluster we have the following Configuration
With SQL 2014 I can use a CSV for the Database files So I created a CSV from 300GB this is more than enough to hold this test install and hold my two G5 Series SQL Server 2014 Ent. instances
To save Time and Costs I use the SQL ini file that I used in the first SQL Instance for the Second instance, This will not bring the fully automatic install as I don’t use the Service accounts But a Quick Next Next Finish will do the trick.
Using the CSV as Storage
On the Second instance I do a Install From ini file based setup. If you need more info on how to do this read my previous blog posts
Installing the SQL server is just as described in my blog post below
Windows 2012R2 Failover Cluster With SQL Server 2014 AlwaysOn Options
If you want to see the installation Steps I created a movie with about the same steps. the whole Process creating and install SQL in just 15 Minutes. not fully untended just for showing you what is possible.
Now that We have 2 SQL servers Running One instance on both nodes
The First node is holding my CSV volume ( more about this on another blog )
for demo I can’t fully load the SQL and this is only for showing that you can build a SQL Server 2014 Cluster Based on a CSV in Windows Azure.
And you can resize the G5 VM’s to a smaller size if needed.
But keep in mind the D drive is a temporary drive and will not hold data if the server is turned off !!
With the vNext there a re a lot off new options possible. For now I burned my Azure Credits See you next time.