I need to design and implement a highly available SQL Server 2012 clustering on Amazon AWS. In the white paper presented by Amazon, they provided an example of Active/ Passive SQL Cluster. Do you know whether Active/ Active is also possible?
Active/Active denotes two live datastores that can be simultaneously accessed by the application(s) in question. SQL Server does not have a solution for this, including AlwaysOn Availability Groups, which at best will only provide you with additional readable replicas. Outside of Oracle RAC, there isn't a solution for this.