Performance Evaluation of NewSQL Databases in a Distributed Architecture
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...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
IEEE
2025-01-01
|
| Series: | IEEE Access |
| Subjects: | |
| Online Access: | https://ieeexplore.ieee.org/document/10840221/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832590358498770944 |
|---|---|
| author | Zhiyao Zhang Alan Megargel Lingxiao Jiang |
| author_facet | Zhiyao Zhang Alan Megargel Lingxiao Jiang |
| author_sort | Zhiyao Zhang |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-cbce8ad6d190488d8cfab924a82615fb |
| institution | Kabale University |
| issn | 2169-3536 |
| language | English |
| publishDate | 2025-01-01 |
| publisher | IEEE |
| record_format | Article |
| series | IEEE Access |
| spelling | doaj-art-cbce8ad6d190488d8cfab924a82615fb2025-01-24T00:01:32ZengIEEEIEEE Access2169-35362025-01-0113111851119410.1109/ACCESS.2025.352974010840221Performance Evaluation of NewSQL Databases in a Distributed ArchitectureZhiyao Zhang0Alan Megargel1https://orcid.org/0000-0002-3349-660XLingxiao Jiang2https://orcid.org/0000-0002-4336-8548School of Computing and Information Systems, Singapore Management University, Bras Basah, SingaporeSchool of Computing and Information Systems, Singapore Management University, Bras Basah, SingaporeSchool of Computing and Information Systems, Singapore Management University, Bras Basah, SingaporeIn 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.https://ieeexplore.ieee.org/document/10840221/Database performanceNewSQLSQLMySQL NDBIMDGin-memory data grid |
| spellingShingle | Zhiyao Zhang Alan Megargel Lingxiao Jiang Performance Evaluation of NewSQL Databases in a Distributed Architecture IEEE Access Database performance NewSQL SQL MySQL NDB IMDG in-memory data grid |
| title | Performance Evaluation of NewSQL Databases in a Distributed Architecture |
| title_full | Performance Evaluation of NewSQL Databases in a Distributed Architecture |
| title_fullStr | Performance Evaluation of NewSQL Databases in a Distributed Architecture |
| title_full_unstemmed | Performance Evaluation of NewSQL Databases in a Distributed Architecture |
| title_short | Performance Evaluation of NewSQL Databases in a Distributed Architecture |
| title_sort | performance evaluation of newsql databases in a distributed architecture |
| topic | Database performance NewSQL SQL MySQL NDB IMDG in-memory data grid |
| url | https://ieeexplore.ieee.org/document/10840221/ |
| work_keys_str_mv | AT zhiyaozhang performanceevaluationofnewsqldatabasesinadistributedarchitecture AT alanmegargel performanceevaluationofnewsqldatabasesinadistributedarchitecture AT lingxiaojiang performanceevaluationofnewsqldatabasesinadistributedarchitecture |