Solved

Creating SQL Server HA cluster with DR

  • 31 January 2023
  • 4 replies
  • 172 views

Hi,
I have two Nutanix clusters on different sites (one on each site) a few miles apart with 10GB low latency networking in place.
I have setup a two node failover SQL Server cluster for HA on a single site, but I would like to add DR to the solution.
I know Availability groups (and other options) are a good solution for this, but we can’t implement those at present and so I am looking for the ‘correct’ way to replicate the two node HA that we have (With it’s shared storage) across to the second site so that our front-end application will continue to function in the event of a site failure.
Any tips or pointers would be very much appreciated!
Thanks

icon

Best answer by Moustafa Hindawi 1 February 2023, 14:50

View original

This topic has been closed for comments

4 replies

Userlevel 5
Badge +6

Hello @Osbit 

It’s better to configure SQL replication via SQL settings (App sync not VM sync), to do stretched cluster you need max. 5 ms network latency.  

Hello @Moustafa Hindawi 

Agreed that this would be better to do in SQL, but I’m in a situation where I’m pretty much a lone DBA with thousands of databases (Not all of them would need DR) to look after and so I don’t have the staff to monitor and maintain anything like that at present.
Until I can get staffing levels improved, I’m looking at doing this outside of the SQL area where we have more trained staff available.
Certainly not ideal I know.

Userlevel 5
Badge +6

Hello @Osbit 

In your case I recommend you to have a look at Nutanix Database Service product (NBD) which will be very good for you.

https://www.nutanix.com/products/database-service

 

Hello @Moustafa Hindawi 

Thank you for the pointer. I’ll take a look!