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?
Asked
Active
Viewed 943 times
8
-
Is there a reason why mirroring won't cut it? – Joshua Oct 17 '18 at 15:18
2 Answers
14
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.
Sean Gallardy - Mostly Retired
- 22,686
- 2
- 35
- 68
1
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)
Kin Shah
- 60,908
- 5
- 111
- 230
-
2Kin, 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 - Mostly Retired Oct 17 '18 at 14:47
-
2Yes 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 Shah Oct 17 '18 at 14:58