SSD-Assisted backup and recovery for database systems
- Authors
- Son, Y.; Choi, J.; Jeon, J.; Min, C.; Kim, S.; Yeom, H.Y.; Han, H.
- Issue Date
- Apr-2017
- Publisher
- IEEE Computer Society
- Citation
- Proceedings - International Conference on Data Engineering, pp 285 - 296
- Pages
- 12
- Journal Title
- Proceedings - International Conference on Data Engineering
- Start Page
- 285
- End Page
- 296
- URI
- https://scholarworks.bwise.kr/cau/handle/2019.sw.cau/60832
- DOI
- 10.1109/ICDE.2017.88
- ISSN
- 1084-4627
- Abstract
- Backup and recovery is an important feature of database systems since it protects data against unexpected hardware and software failures. Database systems can provide data safety and reliability by creating a backup and restoring the backup from a failure. Database administrators can use backup/recovery tools that are provided with database systems or backup/recovery methods with operating systems. However, the existing tools perform time-consuming jobs and the existing methods may negatively affect run-Time performance during normal operation even though high-performance SSDs are used. In this paper, we present an SSD-Assisted backup/recovery scheme for database systems. In our scheme, we extend the out-of-place update characteristics of flash-based SSDs for backup/recovery operations. To this end, we exploit the resources (e.g., flash translation layer and DRAM cache with supercapacitors) inside SSDs, and we call our SSD with new backup/recovery features BR-SSD. We design and implement the backup/recovery functionality in the Samsung enterprise-class SSD (i.e., SM843Tn) for more realistic systems. Furthermore, we conduct a case study of BR-SSDs in replicated database systems and modify MySQL with replication to integrate BR-SSDs. The experimental result demonstrates that our scheme provides fast recovery while it does not negatively affect the run-Time performance during normal operation.
- Files in This Item
- There are no files associated with this item.
- Appears in
Collections - College of Software > School of Computer Science and Engineering > 1. Journal Articles
![qrcode](https://api.qrserver.com/v1/create-qr-code/?size=55x55&data=https://scholarworks.bwise.kr/cau/handle/2019.sw.cau/60832)
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.