We have 2 SQL Servers at Production site and 1 SQL Server at DR site.
Please correct below things as I am not getting clear idea about these sync mode in AlwaysOn:
If I install SQL Server FCIs in Production environment (2 node) can I set one secondary to synchronous mode automatic failover and DR (Stand-Alone) server to Async mode?
Total 3 SQL Servers (Primary Sync, Secondary Sync and Secondary Async (Stand-Alone)) is it possible?
If SQL Server Cluster (2 Instances) is configured in Windows 2-node cluster, is synchronous mode possible?
Should all the SQL Servers be stand-alone to configure AlwaysOn synchronous mode and automatic failover?
Two SQL Servers in Production site, can I set secondary as Synchronous mode with automatic failover?