Synchronization and High Availability of Data by Using Technology of SQLServer 2012 Always On

Session

Computer Science and Communication Engineering

Description

The development of online technology and the use of various banking transaction applications as well as the use of networked information in background, are dealing today with the basis of records that should be accessible, up-to-date and available to users throughout all the time. This are few challenge in itself that requires a lot of resources, time and energy. However, the implementation and configuration of High Availability and Always On Group in SQL Server 2012 greatly increases the availability, accessibility, disaster recovery and maintenance of the database while the database is in used. Through this configuration, the SQL server supports up to four NODE’s (secondary servers) that are primary database copy and, at any time, they can be replaced with the server that maintains the primary database automatically and without interruption of the work process. The security level has increased greatly due to the fact that the NODE’s can be within the same or various data centers. They also can be located in different geographical locations with the primary database, which automatically increases system security issues, such as the risks that are encountered from disasters. Therefore the aim of this research paper is to test the use of High Availability and Always ON technologies in SQL server databases and ascertaining the increased availability, accessibility and maintainability of databases. With the implementation of Always ON availability in SQL server, security, updating information as well as system maintenance has improved greatly. Furthermore, the challenges of current times have been overcome in terms of availability of access and maintenance of the database.

Keywords:

data synchronization, high availability, accessibility, node, always on group, SQL

Session Chair

Kozeta Sevran

Session Co-Chair

Bertan Karahoda

Proceedings Editor

Edmond Hajrizi

ISBN

978-9951-437-54-7

Location

Durres, Albania

Start Date

27-10-2017 3:00 PM

End Date

27-10-2017 4:30 PM

DOI

10.33107/ubt-ic.2017.104

This document is currently not available here.

Share

COinS
 
Oct 27th, 3:00 PM Oct 27th, 4:30 PM

Synchronization and High Availability of Data by Using Technology of SQLServer 2012 Always On

Durres, Albania

The development of online technology and the use of various banking transaction applications as well as the use of networked information in background, are dealing today with the basis of records that should be accessible, up-to-date and available to users throughout all the time. This are few challenge in itself that requires a lot of resources, time and energy. However, the implementation and configuration of High Availability and Always On Group in SQL Server 2012 greatly increases the availability, accessibility, disaster recovery and maintenance of the database while the database is in used. Through this configuration, the SQL server supports up to four NODE’s (secondary servers) that are primary database copy and, at any time, they can be replaced with the server that maintains the primary database automatically and without interruption of the work process. The security level has increased greatly due to the fact that the NODE’s can be within the same or various data centers. They also can be located in different geographical locations with the primary database, which automatically increases system security issues, such as the risks that are encountered from disasters. Therefore the aim of this research paper is to test the use of High Availability and Always ON technologies in SQL server databases and ascertaining the increased availability, accessibility and maintainability of databases. With the implementation of Always ON availability in SQL server, security, updating information as well as system maintenance has improved greatly. Furthermore, the challenges of current times have been overcome in terms of availability of access and maintenance of the database.