상세 보기
Design and Implementation of SSD-Assisted Backup and Recovery for Database Systems
- Son, Yongseok;
- Kim, Moonsub;
- Kim, Sunggon;
- Yeom, Heon Young;
- Kim, Nam Sung;
- 외 1명
WEB OF SCIENCE
1SCOPUS
3초록
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.
키워드
- 제목
- 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
- 발행일
- 2020-02-01
- 유형
- Article
- 권
- 32
- 호
- 2
- 페이지
- 260 ~ 274
- 언어
- ENG
- 출판사
- IEEE COMPUTER SOC
- 발행국가
- 미국
- 분량
- 15 페이지
- ISSN
- E 1558-2191
P 1041-4347