Hybrid storage management for database systems
Authors:
Open Access
- 1 June 2013
- journal article
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 6 (8) , 541-552
Abstract
The use of flash-based solid state drives (SSDs) in storage systems is growing. Adding SSDs to a storage system not only raises the question of how to manage the SSDs, but also raises the question of whether current buffer pool algorithms will still work effectively. We are interested in the use of hybrid storage systems, consisting of SSDs and hard disk drives (HDDs), for database management. We present cost-aware replacement algorithms, which are aware of the difference in performance between SSDs and HDDs, for both the DBMS buffer pool and the SSDs. In hybrid storage systems, the physical access pattern to the SSDs depends on the management of the DBMS buffer pool. We studied the impact of buffer pool caching policies on SSD access patterns. Based on these studies, we designed a cost-adjusted caching policy to effectively manage the SSD. We implemented these algorithms in MySQL's InnoDB storage engine and used the TPC-C workload to demonstrate that these cost-aware algorithms outperform previous algorithms.Keywords
This publication has 11 references indexed in Scilit:
- Flash-based extended cache for higher throughput and faster recoveryProceedings of the VLDB Endowment, 2012
- hStorage-DBProceedings of the VLDB Endowment, 2012
- SSD bufferpool extensions for database systemsProceedings of the VLDB Endowment, 2010
- FlashStoreProceedings of the VLDB Endowment, 2010
- An object placement advisor for DB2 using solid state storageProceedings of the VLDB Endowment, 2009
- Flashing up the storage layerProceedings of the VLDB Endowment, 2008
- Flash Disk Opportunity for Server ApplicationsQueue, 2008
- The Five-Minute Rule 20 Years Later: and How Flash Memory Changes the RulesQueue, 2008
- Flash storage memoryCommunications of the ACM, 2008
- Competitive algorithms for server problemsJournal of Algorithms, 1990