Title
Database engines on multicores, why parallelize when you can distribute?
Abstract
Multicore computers pose a substantial challenge to infrastructure software such as operating systems or databases. Such software typically evolves slower than the underlying hardware, and with multicore it faces structural limitations that can be solved only with radical architectural changes. In this paper we argue that, as has been suggested for operating systems, databases could treat multicore architectures as a distributed system rather than trying to hide the parallel nature of the hardware. We first analyze the limitations of database engines when running on multicores using MySQL and PostgreSQL as examples. We then show how to deploy several replicated engines within a single multicore machine to achieve better scalability and stability than a single database engine operating on all cores. The resulting system offers a low overhead alternative to having to redesign the database engine while providing significant performance gains for an important class of workloads.
Year
DOI
Venue
2011
10.1145/1966445.1966448
EuroSys
Keywords
Field
DocType
resulting system,database engine,better scalability,infrastructure software,single database engine operating,multicore computer,single multicore machine,underlying hardware,important class,multicore architecture,replication,snapshot isolation,distributed system,operating system
Snapshot isolation,Computer science,Real-time computing,Database engine,Software,Multi-core processor,Operating system,Database,Scalability
Conference
Citations 
PageRank 
References 
39
1.31
27
Authors
4
Name
Order
Citations
PageRank
Tudor-Ioan Salomie1692.65
Ionut Emanuel Subasu2391.31
Jana Giceva31085.08
Gustavo Alonso45476612.79