An automate failure recovery for synchronous distributed database system

• Main Authors: Ahmad Shukri, Mohd Noor, Auni, Che Fauzi, Ainul Azila, Che Fauzi, Noraziah, Ahmad, Mohamad Syauqi, Arifin
• Format: Article
• Language: English
• Published: Institute of Advanced Engineering and Science 2022
• Subjects: QA75 Electronic computers. Computer science; QA76 Computer software; T Technology (General); TA Engineering (General). Civil engineering (General)
• Online Access: http://umpir.ump.edu.my/id/eprint/37411/1/An%20automate%20failure%20recovery%20for%20synchronous%20distributed%20database%20system.pdf; http://umpir.ump.edu.my/id/eprint/37411/; https://doi.org/10.11591/ijeecs.v28.i2.pp973-979; https://doi.org/10.11591/ijeecs.v28.i2.pp973-979

Periodically, researchers have been sharing their constant attempts to improve the existing methods for data replication in distributed database system. The main goal is to work for an efficient distributed environment. An efficient environment may handle huge amount of data and preserve data availability. The occasionally failures in distributed systems will affect the end results, such as data loss, income loss etc. Thus, to prevent the data loss and guarantee the continuity of the business, many organizations have applied disaster recovery solutions in their system. One of the widely used is database replication, because it guarantees data safety and availability. However, disaster still can occur in database replication. Hence, an automatic failure recovery technique called distributed database replication with fault tolerance (DDR-FT) has been proposed in this research. DDR-FT uses heartbeat message for node monitoring. Subsequently, a foundation of binary vote assignment for fragmented database (BVAFD) replication technique has been used. In DDR-FT, the data nodes are continuously monitored while auto reconfiguring for automatic failure recovery. From the conducted experiments, it is proved that DDR-FT can preserve system availability. It shows that DDR-FT technique provides a convenient approach to system availability for distributed database replication in real time environment.