I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to AWS.
I am working on configuring an MS SQL Server instance on AWS RDS with multi-AZ mirroring enabled. We would like to have a set-up that allows us to read from the replica and write to the primary. Is there a way to access the mirrored failover/replica server or will I need to find another solution for this?