3

I have set up a 3-node, multi-subnet Always On Availability group in AWS, which seems to be working well. However, each node only has a single network adaptor with 3 IP addresses assigned to it (1 primary, 1 WSFC IP resource, 1 listener). Is this sufficient for high-availability, or do I need additional networks? I believe with a traditional cluster you would need multiple networks & adaptors to ensure there is no single point of failure. I'm not sure if this is the case in AWS, as I assume they have redundancy built-in at their end?

6

In AWS EC2, you don't get the ability to add additional network ADAPTERS to your VM.

You can add additional network INTERFACES, which are just different IPs/subnets/routes/etc, but they're using the same underlying network adapters (cards).

You can choose to use instance types with faster networking ports, though. The EC2 instance configuration page lists which ones have 10 Gigabit ports, although I like ec2instances.info for easier sorting and filtering. When you're doing Always On Availability Groups, it's especially important to use this faster networking because high-network operations (like backups to another machine) can result in SQL Server timeouts (disclaimer: that's my blog post) if you've only got GbE networking. (That causes AG failovers.)

  • Thanks for the quick response Brent, that's great info. So I assume adding additional interfaces/routes would have little or no benefit then? – Matt Feb 9 '17 at 15:16
  • Correct, not if you run into the situations I describe above. – Brent Ozar Feb 9 '17 at 17:06

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.