We currently have 2 sites PROD and DR with separate subnets across VPN and geographical region.
Prod has a Win failover cluster P1 with 2 nodes P1A, P1B with SQL installed as a Role on Shared iSCSI storage
DR has a standalone SQL Server D1
We use merge replication to replicate 5 databases between P1 cluster and D1 standalone.
The latest version of sitecore that we are using does not support this replication method because it creates data conflicts between the databases.
We have to switch to always on Model to make this work.
Always on Can work between 2 standalone instances or a failover cluster on one side and standalone on the other.
We plan on having a 2 node cluster in PROD just like now and standalone in DR.
I am looking for a step by step setup for this specific option.
Can anyone provide complete example with Failover setup as well as SQL AG setup?
Q1- SQL Standard offers basic AG which has a 2 node max.
In my case its a 1 failover pair and 1 standalone, that's total of 3 servers.
Does this count as a 2 node or a 3 node setup?
Q2- In WSFC would I see Role1 SQL cluster made up of Node P1A and P1B with Shared storage
and Role2 which is a AG made up on Node P1 cluster and D1
Q3 - How are SQL listeners configured in this case. Is it going to be 2 listeners in the AG, one for clustered SQL and one for standalone, or are they 3, one for each node?