We have a two site AlwaysOn Cluster and looking to do a High Available multi-site write solution. We have looked at Replication, Sharding, and SQL Elastic options for having multi-site write for a single application. End goal is to have N number of sites that can host the application closest to the user requesting the service, with high availability. We have scaled up, now we want to scale out.
It looks like sharding might be the best option. Does anyone have solid experience with implementing a solution like this in MS SQL?
