Publication Type
Journal Article
Version
acceptedVersion
Publication Date
1-2025
Abstract
In the last decade, application architectures have evolved drastically, moving from monolithic architectures to distributed architectures where deployment has shifted from dedicated on-premises servers to the cloud. Distributed architectures and cloud computing has enabled businesses to scale their application components across different geographical locations. While it is easy to scale the application layer, scaling its database layer that relies on traditional SQL databases is challenging and often is a common source of bottlenecks when it comes to application performance. This paper evaluates the performance characteristics between two NewSQL databases solutions, MySQL NDB Cluster vs. TIBCO ActiveSpaces IMDG. Serving as an application layer, a simulation of banking microservices, handling loyalty rewards, is developed to interface with these databases to derive additional insights and comparison. In the context of a geographically distributed architecture, our experiment results show that MySQL NDB Cluster is more suited for critical business transactions requiring ACID properties while TIBCO ActiveSpaces is better suited for use cases that require big data ingestion, such as IoT platforms.
Keywords
database performance, NewSQL, SQL, MySQL NDB, IMDG, in-memory data grid
Discipline
Databases and Information Systems | Software Engineering
Research Areas
Software and Cyber-Physical Systems
Publication
IEEE Access
Volume
13
First Page
1
Last Page
10
ISSN
2169-3536
Identifier
10.1109/ACCESS.2025.3529740
Publisher
Institute of Electrical and Electronics Engineers
Citation
ZHANG, Zhiyao; MEGARGEL, Alan @ Ali MADJELISI; and JIANG, Lingxiao.
Performance evaluation of NewSQL databases in a distributed architecture. (2025). IEEE Access. 13, 1-10.
Available at: https://ink.library.smu.edu.sg/sis_research/10035
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
https://doi.org/10.1109/ACCESS.2025.3529740
