Research and ACM SRC Posters Archive

Kamo: Bringing Many-Core Scalability to MySQL


Poster Type: Research Posters

Author: Yusuke Miyazaki (Keio University, Tokyo), Sho Nakazono (LY Corporation), Tatsuhiro Nakamori (Keio University, Tokyo), Haowen Li (Keio University, Tokyo), Hideyuki Kawashima (Keio University, Tokyo)

Abstract: MySQL’s SQL ecosystem is widely used, but its default InnoDB storage engine does not scale well under high concurrency. Kamo is a prototype DBMS built on MySQL that substantially extends the initial LineairDB storage-engine integration. Our contributions include named tables, relational insert/update/delete semantics, secondary and composite indexes, ordered scans, and broader MySQL handler coverage sufficient to execute all five BenchBase TPC-C transaction classes. The current prototype has been implemented and evaluated on single-node and semi-synchronously replicated configurations, reaching up to 18.7× the request throughput of MySQL/InnoDB under the evaluated settings.

In the poster session, we will present Kamo’s system architecture, the key relational and MySQL-integration extensions, and end-to-end TPC-C and YCSB-A results. We will also discuss the observed scaling behavior, current bottlenecks, and limitations of the prototype.

Best Poster Finalist (BP): no
Poster: PDF
Poster Summary: PDF


Back to Poster Archive Listing