October 11, 2017 at 8:22 am
Can SQL 2016 Standard edition support an AlwaysOn replica w/ this configuration:
1 SQL 2016 Standard Edition server w/ 4 instances in Data Center 1
1 SQL 2016 Standard Edition server w/ 4 instances in Data Center 2
Setup AlwaysOn replica from Data Center 1 to Data Center 2 for DB's in each instance
I realize that the replica will not be available for Backuing up, Reading, etc. as this is running on Standard edition.
Some articles state a 2-node SQL Cluster is REQUIRED in each data center to accommodate AlwaysOn availability groups? I'm under the impression we do NOT need SQL Clusters defined here.
thx for any feedback
October 12, 2017 at 1:30 pm
AlwaysOn does not use SQL Clusters at all, that is a different technology. You have to setup both machines with a windows failover cluster.
I don't have experience myself with running AlwaysOn with multiple SQL Server instances on the same machines, but I believe you would have the single WSFC cluster, and then you would create separate availability groups on each set of instances, and create unique listeners for each instance, and add the databases to the availability groups.
Yes, 2016 Standard should support this configuration with automatic failover.
October 13, 2017 at 1:06 am
You need a standard Windows Failover Cluster to do Always On Availability Groups, be that a domain joined, multi domain joined, domain independent or a workgroup cluster (last 3 as long as your operating system is Server 2016).
If you truly want to do cluster less Always On you need SQL 2017
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply