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
Solved
Creating SQL Server HA cluster with DR
Best answer by Moustafa Hindawi
Hello
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
This topic has been closed for comments
+6Hello
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
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.
+6Hello
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.