Build a G5 G-Series #azure VM SQL Server 2014 Cluster With shared cloud Storage #SQL #Winserv   2 comments

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.

image

and later I can create a hybrid S2S VPN to my other Clusters.  See My other Blog post about VPN

https://robertsmit.wordpress.com/2014/12/15/how-to-setup-azure-vpn-for-site-to-site-cross-premises-or-create-a-virtual-network-for-point-to-site-vpn-azure-winserv/

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

https://robertsmit.wordpress.com/2014/10/28/configuring-advanced-quorum-configuration-as-a-cloud-witness-windows-azure-files-cloud-azure-winserv-witness/

 

Doing a quick performance test on the G5 Machine.  D and C drive

image  image 

 

The same on a A1 machine D and C drive

 

 image image

 

image image

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 

 

image

 

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.

 

image

Using the CSV as Storage

image

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 

AlwaysOn Failover Cluster Instances SQL Server 2014

https://robertsmit.wordpress.com/2014/05/15/alwayson-failover-cluster-instances-sql-server-2014-in-part2-azure-winserv-sql-msteched/

Windows 2012R2 Failover Cluster With SQL Server 2014 AlwaysOn Options

https://robertsmit.wordpress.com/2014/05/14/windows-2012r2-failover-cluster-with-sql-server-2014-alwayson-options-part1-cloud-azure-winserv-sql-msteched/

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.

https://robertsmit.wordpress.com/2013/09/30/windows-server-2012-r2-with-sql-server-2014-cluster-installation-in-less-than-15-minutes-winserv-rocks-movie/

 

Now that We have 2 SQL servers Running One instance on both nodes

image 

The First node is holding my CSV volume ( more about this on another blog )

image

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.

 

image

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.

 

Happy clustering

Robert Smit

@ClusterMVP

https://robertsmit.wordpress.com

Technorati Tags: Windows Azure,Azure File service,Windows,Server,Clustermvp,Blob,cloud witness

Posted February 2, 2015 by Robert Smit [MVP] in Azure, SQL Server 2014

Tagged with ,

2 responses to “Build a G5 G-Series #azure VM SQL Server 2014 Cluster With shared cloud Storage #SQL #Winserv

Subscribe to comments with RSS.

  1. Nice Guide!
    How you create CSV volume in Azure?
    Azure dont suport shared storage between Virtual Machines.

    Best regards,
    AC

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

  • Twitter

  • %d bloggers like this: