SQL Server 2012 AlwaysOn
Posted on 2013-10-31
If you set up AlwaysOn and Availability Group and have on Synchronous mode with two to three replica; what happened during changes? for example, during deployment of changes to production, you want to make sure the changes perform as expected before they are copy to the other replicas and how to rollback after your replicas has been affected?
How do you handle this?
Can you change to Asynchronous during the change implementation and then flip back to Synchronous mode after the changes perform as expected in production?
I've noticed in our environment, changes perform well in QA; however, when implemented in production they turns out to perform differently. This makes me curious and wanting to know what will happen when we implement AlwaysOn?