0

In general is it problematic to cluster across two datacenters that are up to 15-miles apart?

For this one particular project the approach is the following?

  • 2-Node Failover Cluster across two datacenters, one node per datacenter
  • local SAN disks, no shared disks
  • 'Node and FileShare Majority' at third location on-campus
  • employ AAG, failover will be manual; asynchronous mode

Is anyone implementing something like this with success??!?

Thanks so much for the help!!

1
  • 1
    Which RDBMS? SQL Server, I guess?
    – Philᵀᴹ
    Mar 23 '16 at 0:04
3

PASQLDBA it depends really on how much data is being written to the database and the link between these two DC's and also how far out of sync you can tolerate the two servers keeping your RTO/RPO in mind.

This is by no means any indication of what your milage may be but we have the following setup running quite well.

  • 2 Node Cluster, 1 node in each DC
  • DC's are a good 20 - 30kms apart
  • Fiber link between the DC's
  • Local SAN disks
  • Node and File Share Majority
  • Availability Groups setup, auto failover with synchronous commit

This houses multiple AG's with ~50 databases with no noticeable performance hit over the single instance it was on before.

Hope this helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.