HA and DR Solution

  • You're working in Azure. That's great. Just shift your brain a little and think differently about the solutions. The old style methods of having all the servers in a common room, shared storage and all that stuff, it's gone. Even if you have two servers in the same data center in Azure (or AWS or Google), it's exceedingly unlikely that they're in the same room either (depending on how you define "room").

    As to the whole shared disk thing, I'd suggest you go and read how the various providers have designed their offerings in the cloud. Technology has moved away from the shared disk model because it has proven to be very fragile. It's not simultaneous lightning strikes in both New Jersey and Texas that we have to worry about. It's about the fundamentals that a single shared resource with zero redundancy becomes the primary failure point. This is why so many organizations are moving away from FCI towards Availability Groups.

    Microsoft supplies excellent documentation on setting up HA & DR within Azure. Read this article to get started.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply