Database Replication for Disconnected Operations with Quasi Real-Time Synchronization
-
Published:2023-10-01
Issue:3
Volume:24
Page:
-
ISSN:2300-7036
-
Container-title:Computer Science
-
language:
-
Short-container-title:csci
Author:
Mucha Rafal,Balis Bartosz,Grigoras Costin,Kitowski Jacek
Abstract
Database replication is a way to improve system throughput or achieve high availability. In most cases, using an active-active replica architecture is efficient and easy to deploy. Such a system has CP properties (from the CAP theorem: Consistency, Availability and network Partition tolerance). Creating an AP (available and partition tolerant) system requires using multi-primary replication. This approach, because of many difficulties in implementation, is not widely used. However, deployment of CCDB (experiment conditions and calibration database) needs to be an AP system in two locations. This necessity became an inspiration to examine the state-of-the-art in this field and to test the available solutions. The tests performed evaluate the performance of the chosen replication tools: Bucardo and EDB Replication Server. They show that the tested tools can be successfully used for continuous synchronization of two independent database instances.
Publisher
AGHU University of Science and Technology Press
Subject
Artificial Intelligence,Computational Theory and Mathematics,Computer Graphics and Computer-Aided Design,Computer Networks and Communications,Computer Vision and Pattern Recognition,Modeling and Simulation,Computer Science (miscellaneous)