I have an application that is being run on two separate sites. Ideally they would share a database, because each application needs to see what the other is writing to the database.
However, the sites are geographically separate and each needs to be able to operate if the other one goes down.
There also needs to be high availability within each site.
Does MS SQL AlwaysOn provide this functionality? From what I've read it seems to only support a read only secondary site.
I see that a question similar to this was already asked, but it's from before AlwaysOn was released: Is it possible to have 2 or more databases active, and synchronized between them?