[ClusterLabs] DRBD and SQL Server

[Eric Robinson]

Hi Madi,

It sounds like you’ve had a lot of good experience. I’m trying to decide between paying a premium price for MSSQL Enterprise with Always-On Replication or just setting up an Active/Standby scenario with the Standard Edition of MSSQL running on DRBD. We have tons of experience with MySQL on DRBD, but not with MSSQL. When running MSSQL on DRBD, what’s the cluster stack? How does failover work? When using MySQL, the service only runs on one server at a time. In a failover, the writable data volume transitions to the standby server and then the MySQL service is started on it. Does it work the same way with MSQL?

-Eric


From: Madison Kelly <mkelly at alteeve.com>
Sent: Monday, September 26, 2022 7:55 PM
To: Cluster Labs - All topics related to open-source clustering welcomed <users at clusterlabs.org>; Eric Robinson <eric.robinson at psmnv.com>
Subject: Re: [ClusterLabs] DRBD and SQL Server

On 2022-09-25 23:49, Eric Robinson wrote:
Hey list,

Anybody have experience running SQL Server on DRBD? I’d ask this in the DRBD list but that one is like a ghost town. This list is the next best option.

-Eric

Extensively, yes. Albeit in VMs whose storage was backed by DRBD, though for all practical purposes there's no real difference. We've had clients running various DB servers for over ten years spanning DRBD 8.3 through to the latest 9.1.

What's your question?

Madi

--

Madison Kelly

Alteeve's Niche!

Chief Technical Officer

c: +1-647-471-0951

https://alteeve.com/

Disclaimer : This email and any files transmitted with it are confidential and intended solely for intended recipients. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of Physician Select Management. Warning: Although Physician Select Management has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20220927/e13d9815/attachment.htm>