Creating SQL Server HA cluster with DR | Nutanix Community
Skip to main content

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

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.


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!