An automate failure recovery for synchronous distributed database system

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

Perancangan dan Pengujian Load Balancing dan Failover Menggunakan Nginx

High-traffic websites can have heavy workload on the server side, which causes a decrease in the server performance. It might also lead to system failures. A distributed system using load balancing with failover is one of the solutions to overcome this problem. Load balancing is a technology to divide workload among multiple servers, ensuring that no one server is overloaded. Failover is the ability to switch to a secondary system on the event of failure of the primary system. In this research, Nginx and KeepAlived are the key software packages. Nginx will be used as the load balancer, while KeepAlived will be used to configure the failover. Both methods will be implemented over the Ubuntu operating system. A number of scenarios were designed to test the designed load balancing system. Test will be conducted using JMeter software package. Based on the result of the test, the designed system was able to divided request workload among the backend and even if the load balancer server or the backend server were failing, the system was still able to keep working. Several test was also proofing that using a load balancing will decrease response time and increase the system throughput which causes an increase in the performance of the system. Based on this research, using Nginx as a load balancing combined with failover can be used as one of the solution to overcome an increasing traffic in a website

An efficient data replication technique with fault tolerance approach using BVAG with checkpoint and rollback-recovery

Data replication has been one of the pathways for distributed database management as well as computational intelligence scheme as it continues to improve data access and reliability. The performance of data replication technique can be crucial when it involves failure interruption. In order to develop a more efficient data replication technique which can cope with failure, a fault tolerance approach needs to be applied in the data replication transaction. Fault tolerance approach is a core issue for a transaction management as it preserves an operation mode transaction prone to failure. In this study, a data replication technique known as Binary Vote Assignment on Grid (BVAG) has been combined with a fault tolerance approach named as Checkpoint and Rollback-Recovery (CR) to evaluate the effectiveness of applying fault tolerance approach in a data replication transaction. Binary Vote Assignment on Grid with Checkpoint and Rollback-Recovery Transaction Manager (BVAGCRTM) is used to run the BVAGCR proposed method. The performance of the proposed BVAGCR is compared to standard BVAG in terms of total execution time for a single data replication transaction. The experimental results reveal that BVAGCR improves the BVAG total execution time in failure environment of about 31.65% by using CR fault tolerance approach. Besides improving the total execution time of BVAG, BVAGCR also reduces the time taken to execute the most critical phase in BVAGCRTM which is Update (U) phase by 98.82%. Therefore, based on the benefits gained, BVAGCR is recommended as a new and efficient technique to obtain a reliable performance of data replication with failure condition in distributed databases