Re: [ClusterLabs] DRBD and SQL Server

[Madison Kelly]

The way we do it is to create a VM that runs Windows and hosts the DB, so the OS nor the DB have to have any concept that there's replication behind the scenes.

Exactly how we do is specific to our platform (The Anvil), but in short we've got a custom RA for pacemaker and management tools to create LVs per VM, and those LVs become backing devices for a DRBD resource with 1 or more volumes. The resource runs in single-primary except when we want to live migrate, (all this is handled in our Pacemaker RA) then we enable dual-primary, promote the target to primary, migrate, demote the old host to Secondary and disable dual-primary support.

Of course, protection is provided via IPMI fencing as the primary method with switched PDU fencing as a backup.

I'm happy to go into more detail, but I'll stop here until/unless you have more questions. Otherwise I'd write a book. :)

Madi

On 2022-09-27 15:42, Eric Robinson wrote:

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 <mke...@alteeve.com>
Sent: Monday, September 26, 2022 7:55 PM
To: Cluster Labs - All topics related to open-source clustering welcomed <users@clusterlabs.org>; Eric Robinson <eric.robin...@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.

-- 
Madison Kelly
Alteeve's Niche!
Chief Technical Officer
c: +1-647-471-0951
https://alteeve.com/

_______________________________________________
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users

ClusterLabs home: https://www.clusterlabs.org/