none
Will an SQL Server 2008 VM image be made available and can we cluster it? RRS feed

Answers

All replies

  • Hi LordG,

    We do not have any specific dates/information available for SQL 2008 based Images. Clustering is not supported in Windows Azure Virtual Machines.

    http://support.microsoft.com/kb/2721672/de

    Thanks,

    Hari

    Wednesday, August 15, 2012 2:29 PM
    Moderator
  • Hi Hari,

    Thanks for the response. Regarding the clustering, what is the exact definition of not supported.

    Surely we can run our own SQL Sever 2008 with replication/clustering to support an Active/Passive setup?

    Ideally we would run 2 or 3 VM's with SQL Server 2008, use replication or similar, and the load balancing features of traffic monitor.

    If this is not possible, then I can only assume our only way to support fail over in the Windows Azure environment, is to use a SQL Logical Server, correct?

    Our current challenge is that we have a SQL 2008, .NET 4, and Server 2008 infrastructure requirement. For the immediate term, we would like to move this to Windows Azure. In the long term, we plan to migrate our architecture to support more of the Azure features and infrastructure.

    Wednesday, August 15, 2012 2:41 PM
  • Hi LordG,
    Regarding to your description, SQL clustering is not supported on WA VMs, SQL Clustering and most solutions built on top of windows failover clustering require support for an IP address that moves between VMs. The Azure VMs only support a single IP address per VM
    for more detail, please refer to : http://social.msdn.microsoft.com/Forums/en/WAVirtualMachinesforWindows/thread/97425ee5-ae4d-4d95-85d1-32f61c24acda

    According to your description, seems you tried to find a solution for loading  balance for VM on Azure.  You can try to could create 2 VMs, primary server, secondary server, and then deploy them into one Availability Set. It will ensure these two servers are in different fault domain to guarantee availability for loading balance.
    Refer to: http://michaelwasham.com/2012/06/08/understanding-windows-azure-virtual-machines/


    Regards, Amber zhang

    Thursday, August 16, 2012 1:59 AM
    Moderator
  • Hi Amber,

    Ok, those links helped. It's down to the disks and the windows clustering support.

    Would mirroring work on the VM's and be the more correct solution, with load balancing using traffic monitor?

    Thursday, August 16, 2012 2:21 PM
  • Hi LordG,

    Thank you for your update.

    Yes, the Availability Set is high availability solution in Azure VM. So for SQL Server as I mentioned as above setup mirroring is correct solution for you. Please try to follow the Blog as I provided.


    Regards, Amber zhang

    Thursday, August 23, 2012 8:22 AM
    Moderator