Re: [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 
Sent: Monday, September 26, 2022 7:55 PM
To: Cluster Labs - All topics related to open-source clustering welcomed 
; Eric Robinson 
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.
___
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users

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

Re: [ClusterLabs] RFE: sdb clone

[Klaus Wenninger]

On Tue, Sep 20, 2022 at 3:59 PM Ulrich Windl <
ulrich.wi...@rz.uni-regensburg.de> wrote:

> Hi!
>
> I have a proposal (request) for enhancing sbd:
> (I'm not suggesting a complete rewrite with reasonable options, as I had
> don that before already ;-))
> When configuring an additional disk device, it would be quite handy to be
> able to "clone" the configuration from an existing device.
>
what you're suggesting is instead of entering the parameters for creation
of a device you would like
to have the possibility to instead point to an existing configured device?
sounds like a good idea.

> As I understand it, sbd uses the physical block size for disk layout, so a
> simple dd won't do the job when old and new device use different physical
> block sizes, right?
>
yep - physical block size is queried and used for message-box entries - for
good reason

Klaus

> I think manually entering the parameters for the sbd header (the way it
> has to be done now) is quite error-prone, and it's easy to configure
> devices using different timing parameters.
>
> Regards,
> Ulrich
>
>
>
> ___
> Manage your subscription:
> https://lists.clusterlabs.org/mailman/listinfo/users
>
> ClusterLabs home: https://www.clusterlabs.org/
>
>
___
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users

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