question

YeOldeDBA avatar image
YeOldeDBA asked

How to migrate a multi-instance SQL Failover Cluster to AlwaysOn?

I don't seem to be able to find any posts regarding how to go about migrating a multi-instance SQL Failover Cluster (SQL 2008 R2) to AlwaysOn Availability Groups (SQL 2014)? We have a two-node Windows Cluster (Windows 2008) with a SQL Failover Cluster on top. Works great. But now we figure we would need the DR functionality in AlwaysOn. So, two nodes on primary site and one node on DR site. But that is no issue here. The issue is that I am trying to find out how to configure the nodes SQL-wise. Right now we have 6 clustered instances, all on different ip addresses but all on port 1433. The goal is that apps won't have to change Connection strings because of this migration, i.e. we retain the network names for all the former instances and assign them to the AG Listeners, and furthermore we want to keep port 1433. Now, as I understand it, I need to set up 6 named instances (with generic names) on each node. The reasons for having named instances are memory managmement, security, separate tempdbs etc. Should I assign a static generic port to each named instance and turn off SQL Browser? Will the Listener be able to resolve to the correct instance if I do? Are there any alternative ways to go about this... anybody keen on sharing your experience on this?
clustersql-server-2014always-on
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
The thing is, Availability Groups are set up by database. There is no straight migration path for the servers from a failover cluster to Availability Groups because they're different technologies (although the AG does use clustering mechanisms and services). In fact, I know quite a few people that are running clusters in addition to AG.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.