Architecting Multisite Database Proxy using ProxySQL

Architecting Multisite Database Proxy using ProxySQL

연구 분야: Databases

학회: 2024 2nd International Conference on Technology Innovation and Its Applications (ICTIIA)

This research investigates the implementation of a multisite database architecture utilizing ProxySQL to enhance database availability and resilience. The study focuses on designing and deploying a database system spanning on-premise and cloud environments, with ProxySQL acting as a component for load balancing, failover, and query optimization. The research methodology involves a systematic approach, encompassing literature review, system design, implementation, testing, and analysis. Key findings demonstrate the result of the proposed architecture in achieving high availability, better performance, and enhanced disaster recovery capabilities. The results highlight the potential of ProxySQL as a valuable tool for mitigating database downtime and ensuring business continuity.