Design and Implementation of SSD-Assisted Backup and Recovery for Database Systems

作     者：Son, Yongseok Kim, Moonsub Kim, Sunggon Yeom, Heon Young Kim, Nam Sung Han, Hyuck 

作者机构：Chung Ang Univ Sch Software Seoul 06974 South Korea Seoul Natl Univ Dept Comp Sci & Engn Seoul 08826 South Korea Univ Illinois Dept Elect & Comp Engn Champaign IL 61820 USA Dongduk Womens Univ Dept Comp Sci Seoul 02748 South Korea 

出 版 物：《IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING》 (IEEE知识与数据工程汇刊)

年 卷 期：2020年第32卷第2期

页      面：260-274页

核心收录：

学科分类：0808[工学-电气工程] 08[工学] 0812[工学-计算机科学与技术（可授工学、理学学位）] 

基　　金：National Research Foundation of Korea (NRF) - Korea government (MSIT) [2015M3C4A7065581  2015M3C4A7065645  2018R1C1B5085640] 

主　　题：Database systems Tools Performance evaluation Reliability Random access memory Arrays Solid state drives database systems backup and recovery replication redundant array of independent disks 

摘      要：As flash-based solid-state drive (SSD) becomes more prevalent because of the rapid fall in price and the significant increase in capacity, customers expect better data services than traditional disk-based systems. However, the order of magnitude performance provided and new characteristics of flash require a rethinking of data services. For example, backup and recovery is an important service in a database system since it protects data against unexpected hardware and software failures. To provide backup and recovery, backup/recovery tools or backup/recovery methods by operating systems can be used. However, the tools perform time-consuming jobs, and the methods may negatively affect run-time performance during normal operation even though high-performance SSDs are used. To handle these issues, we propose an SSD-assisted backup/recovery scheme for database systems. Our scheme is to utilize the characteristics (e.g., out-of-place update) of flash-based SSD for backup/recovery operations. To this end, we exploit the resources (e.g., flash translation layer and DRAM cache with supercapacitors) inside SSD, and we call our SSD with new backup/recovery functionality BR-SSD. We design and implement the functionality in the Samsung enterprise-class SSD (i.e., SM843Tn) for more realistic systems. Furthermore, we exploit and integrate BR-SSDs into database systems (i.e., MySQL) in replication and redundant array of independent disks (RAID) environments, as well as a database system in a single BR-SSD. The experimental result demonstrates that our scheme provides fast backup and recovery but does not negatively affect the run-time performance during normal operation.