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
Creating SQL Server HA cluster with DR
Hello
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.