I am going to set up AG's for the very first time, so with little or no experience, please guide me on below understanding:
If i am setting up 4 node AOAG with below scenario:
Node1-NY Data Center - Primary replica
Node2-NY Data Center - Secondary replica
Node1---Node2 Synchronous mode
Node 3 - Michigan Data Center secondary replica acting as DR site with different subnet with ASYNC mode
Node 4 -- Readable secondary in NJ data center for reporting purpose using ASYNC mode
In above Multi Subnet configuration can i still use a different storage across 4 nodes or do i need to use SAN replication as i have read few blogs and confused if that is a requirement for multi site env
What should be ideal Quorum setup? -- Can i have that in NJ site as file share witness?
Also if there is better design than above, please suggest as i have never implemented or worked on AOAG before.
RPO/RTO for critical apps varies between 2 hrs to 4 hours
While for mid critical its between a day and 2
I can add up information as needed.