Enhancing High Availability in Multi-Cloud MySQL Deployments Using Group Replication and ProxySQL
DOI:
https://doi.org/10.63397/ISCSITR-IJCC_2025_06_03_002Keywords:
High Availability, SQL, AI, Deployment, Cloud, ReplicationAbstract
The paper looks into how MySQL high availability can be improved in multi-cloud environments using Group Replication and ProxySQL. These topics include architecture, WAN copy delays, scenarios for restoring service, and security. Systems in production show improved times for recovering from incidents and better capacity to cope with them. Tracking services and using intelligent routing boost the overall continuity of cloud-based operations spread across the globe.
References
Xiong, H., Fowley, F., & Pahl, C. (2016). A Database-Specific pattern for multi-cloud high availability and disaster recovery. In Communications in computer and information science (pp. 374–388). https://doi.org/10.1007/978-3-319-33313-7_29
Shrestha, R. (2017). High Availability and Performance of Database in the Cloud - Traditional Master-slave Replication versus Modern Cluster-based Solutions. Scitepress, 413–420. https://doi.org/10.5220/0006294604130420
Kraska, T., Pang, G., Franklin, M. J., & Madden, S. (2012). MDCC: Multi-Data Center Consistency. arXiv (Cornell University). https://doi.org/10.48550/arxiv.1203.6049
Eischer, M., & Distler, T. (2020, December). Resilient cloud-based replication with low latency. In Proceedings of the 21st International Middleware Conference (pp. 14-28). https://doi.org/10.48550/arXiv.2009.10043
Cecchet, E., Candea, G., & Ailamaki, A. (2007). Middleware-based Database Replication: The Gaps between Theory and Practice. arXiv (Cornell University). https://doi.org/10.48550/arxiv.0712.2773
Endo, P. T., Rodrigues, M., Gonçalves, G. E., Kelner, J., Sadok, D. H., & Curescu, C. (2016). High availability in clouds: systematic review and research challenges. Journal of Cloud Computing Advances Systems and Applications, 5(1). https://doi.org/10.1186/s13677-016-0066-8
Berenberg, A., & Calder, B. (2022). Deployment archetypes for cloud applications. ACM Computing Surveys (CSUR), 55(3), 1-48. https://doi.org/10.48550/arXiv.2105.00560
Bieger, V. (2023). A decision support framework for multi-cloud service composition (Master's thesis). https://studenttheses.uu.nl/handle/20.500.12932/44605
Kasiri, A., & Patel, K. Hybrid and Multi-Cloud Data Management Strategies for Sharing Research Data. Available at SSRN 4605362. http://dx.doi.org/10.2139/ssrn.4605362
Kaushik, M. K. R. AI And Observability In Multi-Cloud Database Migrations: Enhancing Performance, Reliability, And Cost Efficiency. https://www.researchgate.net/profile/Maheshbhai-Kansara/publication/391428576_AI_And_Observability_In_Multi-Cloud_Database_Migrations_Enhancing_Performance_Reliability_And_Cost_Efficiency/links/681690b3ded4331557422492/AI-And-Observability-In-Multi-Cloud-Database-Migrations-Enhancing-Performance-Reliability-And-Cost-Efficiency.pdf
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Hari Babu Dama (Author)
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
