I have AlwaysOn cluster with 4 AGs. I need to leverage 2 of the AGs to reporting. I am planning to use read scale availability node without cluster for reporting purpose. Since my reporting load is heavy, I need 4 read scale nodes without cluster as standalone copies. My question is:
- Is it possible to configure four read scale nodes from the cluster? If yes - is that configured only from primary or it could be achieved from secondary replica as well?
- Reporting clients are accessing the standalone read scale copies using server IP (not the listener IP), so even if the primary is not available, the read replica will still be accessible or it will go to resolving mode?