In this article published in the top database journal Information Systems, Ricardo Jimenez-Peris, Diego Burgos, Francisco Ballesteros, Marta Patiño, and Patrick Valduriez discuss the following topics:

  • A complete solution for elastic scalable transaction processing in LeanXcale.
  • Linear scalability to 100s of servers, without requiring any hardware assistance.
  • Non-intrusive elasticity, without hurting the quality of service of TP.
  • Thorough performance evaluation on AWS showing linear scalability.

Abstract

Scaling ACID transactions in a cloud database is hard, and providing elastic scalability even harder. In this paper, we present our solution for elastic scalable transaction processing in LeanXcale, an industrial-strength NewSQL database system. Unlike previous solutions, it does not require any hardware assistance. Yet, it does scales linearly to 100s of servers. LeanXcale supports non-intrusive elasticity and can move data partitions without hurting the quality of service of transaction management. We show the correctness of LeanXcale transaction management. Finally, we provide a thorough performance evaluation of our solution on Amazon Web Services (AWS) shared cloud instances. The results show linear scalability, e.g., 5 million TPC-C NewOrder TPM with 200 nodes, which is greater than the TPC-C throughput obtained by the 9th highest result in all history using dedicated hardware used exclusively (not shared like in our evaluation) for the benchmark. Furthermore, the efficiency in terms of TPM per core is double that of the two top TPC-C results (also the only results in a cloud).

Related content

Did you find this article interesting? Then you may like all this content!

On database scalability

Posts:

Understanding Distributed Databases Scalability
Understanding Cluster Replication Scalability
The Case for Shared Nothing

Videos:

ACID ultra scalability with LeanXcale
Ricardo Jimenez – Talk at Waterloo Univ (24/05/2019)

On NewSQL

Post:

SQL, NoSQL & NewSQL
NewSQL in Finance and Insurance

Videos:

LeanXcale Webinar: NewSQL in Finance and Insurance

Demos

Videos:

Demo: LeanXcale for Data Pipelines
Demo: LeanXcale for Monitoring Applications