AWS BYOC – Bring your own SQL Server cluster with AWS EC2 and SIOS

Nice blog post from SQL Server expert Steve Rezhener.

DataSteve


Introduction

They are multiple options to implement HADR solution for in AWS public cloud. The easiest way to do that is to use AWS Database as a Service (DBaaS) product known as AWS and enable Multi-AZ option using your AWS Control Panel (Fig #1).

See the source image
Fig #1

That is all it takes to roll out or add it to an existing instance. AWS will take care of the rest under the hood (depending on your version, it might use Mirroring or Always On Availability Groups). It will provision all the necessary things for an automatic (, , , etc…), so when a primary node will go down, it will be replaced with a secondary node. No ifs and no buts. This blog post is going to discuss build your own HADR solution using multiple AWS EC2s (BYOC) instead of a managed AWS…

View original post 1,104 more words

 

This article was originally published by Clustering For Mere Mortals. You can find the original article here.