Architecting Multisite Database Proxy using ProxySQL

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.