As SQL Server is available for Linux can I configure Clustering on Linux nodes? I mean mixed with Windows - some nodes are on Linux, others on Windows in the same cluster?

  • Is there a reason why mirroring won't cut it? – Joshua Oct 17 at 15:18
up vote 14 down vote accepted

As SQL Server is available for Linux can I configure Clustering on Linux nodes?

You can configure Corosync and pacemaker for Linux. Good luck.

I mean mixed with Windows - some nodes are on Linux, others on Windows in the same cluster?

In the same cluster, no. Someone will argue with me and say, "Well, Sean, you can do read-scale availability groups like this!" and that may be true, however it isn't a cluster.

The only way to do this would be to have two different clusters, spanned by a distributed availability group. If you want to make life complicated then this would be the setup to do it.

Yes - cross platform is supported for AlwaysON availablity groups. Microsoft recommends to use this only for migration and not for HA.

See - Configure SQL Server Always On Availability Group on Windows and Linux (cross-platform)

  • 2
    Kin, it's not a cluster, hence CLUSTER_TYPE = NONE which means you're not going to get HA. This is a read-scale AG. – Sean Gallardy Oct 17 at 14:47
  • 2
    Yes agreed. Just wanted to highlight that mostly it can be used for read-scale or for migration (which I am going to use it to migrate from windows to Linux). – Kin Oct 17 at 14:58

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.