Implementation of High Availability Based on Load Balancing and Failover Method in E-commerce Using MySQL Database

Abstract

The rapid growth of e-commerce has brought about challenges in managing traffic loads and ensuring the availability of database servers. One critical issue is what happens when the main database server fails, potentially leading to downtime or data loss. This research aims to address these problems by optimizing server resource distribution and implementing data replication across multiple database servers. The goal is to enhance system efficiency, prevent server overloads, ensure data availability, and minimize downtime or data loss when server failures occur.This research utilizes a multi-stage methodology. First, data collection was conducted to gather relevant information. In the second stage, a needs analysis was performed to identify system requirements. The third stage involved designing the system architecture, including the creation of entity-relationship diagrams (ERD), flowcharts, and network topologies. In the final stage, the system was implemented through database replication and the application of failover methods.The results demonstrate that the failover mechanism operates effectively, ensuring that data is successfully replicated across all database servers. This confirms that the system achieves high availability and minimizes the risk of data loss or service downtime. The implications of this research provide a reliable solution for improving the resilience and performance of e-commerce systems, particularly in managing database server failures.