SQL Server 2012 introduced the new feature called AlwaysOn.
AlwaysOn provides High Availability & Disaster Recovery alternative to Database Mirroring.
What is Database Mirroring?
Database Mirroring is a technique to increase High Availability of database. The topology consists of three server roles.
- Witness Server
- Principal Server
- Mirror Server
Transaction Logs will be synchronized from Principal Server to Mirror Server.
The Witness Server determines whether to contact Principal or Mirror based on activity, thus increasing the availability.
Advantages of AlwaysOn over Database Mirroring
AlwaysOn provides the following advantages over Database Mirroring:
- More effective server utilization
- Less configuration hassles
- Better manageability
- Better failover situation
- Works best with multiple-database scenarios of SharePoint
More and More people are switching to AlwaysOn Availability Group technique.
Clustering, Mirroring, Log Shipping, AlwaysOn are different technologies to attain High Availability in database servers.