An Evaluation Method and Comparison of Modern Cluster-Based Highly Available Database Solutions

Raju Shrestha, Tahzeena Tandel

2023

Abstract

High availability in cloud computing is a top concern which refers to keeping a service operational and available for the maximum amount of time without downtime. In any given application and service, the high availability of the database plays a critical role in the application’s high availability as a whole. Modern cluster-based multi-master technologies provide high availability database solutions through synchronous replication. Different database management systems offer different technologies and solutions for high availability. This paper proposes a comprehensive method for the evaluation of high availability database solutions. As a comparative case study, two modern high availability database solutions which are open-source and available for free use, namely the Percona XtraDB Cluster and the MySQL NDB Cluster are used. Benchmark tests with standard CRUD database operations and analysis of the test results show that no single solution is superior to the other in all scenarios and needs. Therefore, one should choose an appropriate solution wisely depending on the needs for an application or service. The proposed evaluation method would be useful to get insights into which solution is effective for a given application and hence it can be used in making an informed choice among different solutions at hand.

Paper Citation

in Harvard Style

Shrestha R. and Tandel T. (2023). An Evaluation Method and Comparison of Modern Cluster-Based Highly Available Database Solutions. In Proceedings of the 13th International Conference on Cloud Computing and Services Science - Volume 1: CLOSER, ISBN 978-989-758-650-7, SciTePress, pages 131-138. DOI: 10.5220/0011714400003488

in Bibtex Style

@conference{closer23,
author={Raju Shrestha and Tahzeena Tandel},
title={An Evaluation Method and Comparison of Modern Cluster-Based Highly Available Database Solutions},
booktitle={Proceedings of the 13th International Conference on Cloud Computing and Services Science - Volume 1: CLOSER,},
year={2023},
pages={131-138},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011714400003488},
isbn={978-989-758-650-7},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 13th International Conference on Cloud Computing and Services Science - Volume 1: CLOSER,
TI - An Evaluation Method and Comparison of Modern Cluster-Based Highly Available Database Solutions
SN - 978-989-758-650-7
AU - Shrestha R.
AU - Tandel T.
PY - 2023
SP - 131
EP - 138
DO - 10.5220/0011714400003488
PB - SciTePress