9

I would like to setup a MSMQ in a failover system.

I do not have a shared storage setup (hardware not available - budget), but i have three dl380 running windows server 2016.

I would like to setup failover with a quorum server.

is this setup possible?

  • 1
    Looks like the coin will be killing this entire project. – pithhelmet Feb 24 '17 at 20:36
8

You can also stick with Always On scenario that doesnt assume a shared storage and where the overall health of your cluster would be determined by the votes of quorum of nodes in the cluster. But this feature is an enterprise one. So in case of tight budget, I would also recommend to go with FCIs.

  • 1
    AlwaysOn is available with an inexpensive Standard edition of SQL Server. msdn.microsoft.com/en-us/library/mt614935.aspx (OK, these are BASIC Availability Groups but should be enough for most of the cases IMHO). – BaronSamedi1958 Feb 24 '17 at 22:13
  • 2
    Too much limitations, if you ask me. I'd reconsider going this way referring to "limit of two replicas" and "no support for adding or removing a replica to an existing availability group". – batistuta09 Feb 27 '17 at 16:01
  • Yeah, we do FCI over basic AGs here. – BaronSamedi1958 Feb 27 '17 at 16:04
  • Does this Always On SQL server allow the MSMQ to carry over as well? – pithhelmet Feb 27 '17 at 16:23
  • AFAIK, MSMQ doesn't implement the "always-on" feature, so the some sort of shared disk is still a requirement for the quorum. But it may be even a JBOD enclosure or a replicated drive. – batistuta09 Feb 27 '17 at 16:51
9

From my experience, MSMQ deploys find on top of clustered shared volumes. Therefore, any software shared solution that does mirror/present storage to Failover cluster as CSV will do the job.

I can recommend you try HPE VSA, StarWind VSAN, Microsoft Storage Spaces Direct, so far all of them do share nothing storage for Failover Cluster. I would suggest StarWind in case you don't run Hyper-V on your hosts, so it will do free mirrored storage.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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