We have on Always On infrastructure with 4 SQL DB Servers. We have a Primary and Secondary in the Main Site and a DR Primary and Secondary in the Secondary Site.
We have 4 Application servers in each of the 2 sites. We want everything local, meaning for the Primary site we want the 2 application servers to read and write to the Primary DB server. For the 2 Secondary Application servers we want it to read and write data to the Secondary DB server's. However according to our DBA, that is not how it works. The secondary DB servers are only read only and are unable to write from the secondary application servers. So that means all 4 application servers can only write to the primary DB server only.
Is there anyway for the application write to any of the DB servers using the Always On feature? Or what can we do so everything local from an application server perspective. I want the application servers to only read/write to the local SQL 2012 servers in each site.
I appreciate any feedback! I am not a SQL person, but would love a second opinion on how or if we can get this setup the way I need too!