SQL – Creating a SQL Server AlwaysOn on Amazon EC2, Part 3

In Part 2 we have finished configuring Windows Failover Cluster. By now our network looks like this:
AG0Now we are ready to deploy SQL Server components. For the AlwaysOn we need a standalone SQL server installlation type [we do not need to install a SQL Server failover cluster]:

I’m going to skip installation steps as these are quite straightforward [just install major components] and rather focus on preparing SQL for AlwaysOn. Just gonna mention here that service account is CONTOSO\svcsql.

Asuming standalone SQL server is installed on each of the nodes, next we need to activate AlwaysOn functionality on each of the nodes. For that run “SQL Server Configuration Manager”, select “SQL Server Services” and then open “SQL Server” service properties:

SQL2Open “AlwaysOn High Availabilty” tab and tick “Enable AlwaysOn Availability Groups”:

SQL3Cluster name will be popoulated automatically because it’s already installed.
SQL Server services will be restarted. Do not forget to repeat this on the other node.

Now, lets create a small database to work with. On WIN2012R2-1 I’ve created the following simple database with just one tiny table:

SQL4Make sure it’s Recovery Model is set to “Full”:

SQL5Lets make a Full database backup to some local folder [C:\SQLBackup in my case]:

SQL7SQL6AlwaysOn will be using a shared folder to synchronize database accross cluster nodes belonging to the same Availability Group. Lets create one called “C:\Replica” on the DC:

SQL8SQL Server service account [contoso\svcsql in my case] needs to have Read/Write NTFS permissions on that shared folder:SQL9OK, at this point we are ready to configure AlwaysOn, finally :). See you in Part 4.



Leave a Comment here

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s