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!
Best answer by Moustafa HindawiView original
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.
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.
In your case I recommend you to have a look at Nutanix Database Service product (NBD) which will be very good for you.
Thank you for the pointer. I’ll take a look!