Overview and implementing sql server high availability solutions

• Autorzy: Bleja M.
• Języki publikacji: EN

Abstrakty

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.

Słowa kluczowe

EN

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

PL

baza danych; serwer bazodanowy; SQL Server

• Wydawca: Wydawnictwo Szkoły Głównej Gospodarstwa Wiejskiego w Warszawie
• Czasopismo: Information Systems in Management
• Rocznik: 2016
• Tom: Vol. 5, No. 4
• Strony: 463--472
• Opis fizyczny: Bibliogr. 12 poz., rys.

Twórcy

autor

Bleja M.

• Faculty of Mathematics and Computer Science, University of Lodz

Bibliografia

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

Uwagi

PL

Opracowanie ze środków MNiSW w ramach umowy 812/P-DUN/2016 na działalność upowszechniającą naukę.