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
Recommended Citation
Ymeri, Exhevit; Qehaja, Besnik; and Hoxha, Ramiz, "Synchronization and High Availability of Data by Using Technology of SQLServer 2012 Always On" (2017). UBT International Conference. 104.
https://knowledgecenter.ubt-uni.net/conference/2017/all-events/104
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.