Implementasi Database Mirror dan Failover SQL Server pada Windows Hyper-V
Abstract
The use of databases helps build data to be more organized and computerized, so the data can be accessed. Users also want a service that has a high level of availability so that it can be used continuously without feeling down in the event of a server failure. However, when accessing the database there can be several obstacles, such as the situation when the user is unable to access information because the primary database access service is turned off so that information cannot be given. For that reason, database mirror is one form of solution for primary databases that cannot be accessed. The mirror runs in conjunction with the use of failover, i.e. if a server failure occurs, then another server will take over the function. From the test obtained, the mirror process runs well on two nodes with the contents of each database the same, and the failover process is able to connect other servers to take over the function as the main database when the main database is down, with data accuracy of 100%.Published
2020-09-10
Issue
Section
Artikel
License
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.
