OVERVIEW AND IMPLEMENTING SQL SERVER HIGH AVAILABILITY SOLUTIONS

• Authors: Bleja Michał
• Languages of publication: EN

Abstracts

EN

The paper presents the concepts related to the design of high availability solutions for Microsoft SQL (MS SQL) Server database servers. MS SQL Server from version 2012 offers a new capability called AlwaysOn which is aimed at reducing downtime of servers or databases during a failure. It includes several mechanisms such as Failover Cluster Instances, Availability Groups, Database mirroring, Log shipping. The paper presents the implementation of some of these concepts in our prototype. We also compare these mechanisms focusing on their aptitude in contemporary information systems.

Keywords

EN

high availability; windows clusters; availability group; failover cluster instance; database mirroring; log shipping

• Publisher: Katedra Informatyki Szkoła Główna Gospodarstwa Wiejskiego w Warszawie
• Journal: Information Systems in Management
• Year: 2016
• Volume: 5
• Issue: 4
• Pages: 463-472

Dates

published

2016

Contributors

author

Bleja Michał

• Faculty of Mathematics and Computer Science, University of Lodz

References

• Books Online for SQL Server 2012 (2011): High Availability Solutions (SQL Server), Microsoft Corporation
• Bolton C. (2013) Professional SQL Server 2012 Internals and Troubleshooting, John Wiley & Sons, Inc.
• MySQL 5.7 Reference Manual (2016): High Availability and Scalability, http://dev.mysql.com/doc/refman/5.7/en/ha-overview.html
• Oracle Database High Availability Overview 11g Release 2 (2013), Oracle
• PostgreSQL 9.4.5 Documentation (2016): Chapter 25. High Availability, Load Balancing, and Replication, The PostgreSQL Global Development Group
• Worden D. (2004) Storage Networks, Apress
• Hotek M. (2009) Microsoft SQL Server 2008 - Implementation and Maintenance, Microsoft Press
• Books Online for SQL Server 2012 (2011): Configure Log Shipping (SQL Server), Microsoft Corporation
• Books Online for SQL Server 2012 (2011): Database Mirroring (SQL Server), Microsoft Corporation
• Books Online for SQL Server 2012 (2011): Overview of AlwaysOn Availability Groups (SQL Server), Microsoft Corporation
• Books Online for SQL Server 2012 (2011): Failover Cluster Overview, Microsoft Corporation
• Books Online for SQL Server 2012 (2011): AlwaysOn Failover Cluster Instances (SQL Server), Microsoft Corporation

Identifiers

ISSN

2084-5537