SSD-Assisted backup and recovery for database systems

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2017, Pages 285-296

  Son, Yongseok ^a   Choi, Jaeyoon ^b   Jeon, Jekyeom ^b   Min, Cheolgi ^a   Kim, Sunggon ^a   Yeom, Heon Young ^a   Han, Hyuck ^c  

^a Seoul National University   (South Korea)

^b SAMSUNG Electronics   (South Korea)

^c Dongduk Women's University   (South Korea)

Author keywords

[No Author keywords available]

Indexed keywords

EMBEDDED SYSTEMS; FLASH-BASED SSDS; RECOVERY;

DATABASE ADMINISTRATORS; DESIGN AND IMPLEMENTS; FLASH TRANSLATION LAYER; HARDWARE AND SOFTWARE; IMPORTANT FEATURES; REALISTIC SYSTEMS; REPLICATED DATABASE; RUN-TIME PERFORMANCE;

DATABASE SYSTEMS;

EID: 85021242747     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2017.88     Document Type: Conference Paper

References (47)

1. Mysql point-in-Time backups. http://www.databasejournal.com/features/mysql/article.php/3915236/MySQL-Point-in-Time-Backups.htm 2010.
2. Ibm flash storage. http://www-03.ibm.com/systems/storage/flash/2013.
3. Netapp, all-flash fas storage arrays. http://www.netapp.com/us/products/storage-systems/2016.
4. Purestorage, all-flash cloud. http://www.purestorage.com/products/flash-Array-m.html, 2016.
5. A Quick Start Guide to Backup Technologies. https://mariadb.com/sites/default/files/AQuickStartGuidetoBackupTechnologies-MariaDBWhitePaper-082613001.pdf 2008.
6. G. Amvrosiadis and M. Bhadkamkar. Identifying trends in enterprise data protection systems. In ATC, pages 151-164, Santa Clara, CA, July 2015. USENIX Association.
7. C. Bell et al. MySQL high availability: Tools for building robust data centers. " O'Reilly Media, Inc.", 2010.
8. P. A. Bernstein and N. Goodman. The failure and recovery problem for replicated databases. In PODC, pages 114-122, New York, NY, USA, 1983. ACM.
9. P. A. Bernstein and N. Goodman. An algorithm for concurrency control and recovery in replicated distributed databases. ACM Trans. Database Syst., 9(4):596-615, Dec. 1984.
10. S. Bhattacharya et al. Coordinating backup/recovery and data consistency between database and file systems. In SIGMOD, pages 500-511, New York, NY, USA, 2002. ACM.
11. Binary log. http://dev.mysql.com/doc/refman/5.6/en/binary-log.html.
12. J. Bonwick and B. Moore. Zfs: The last word in file systems. 2007.
13. M. Canim et al. Ssd bufferpool extensions for database systems. Proceedings of the VLDB Endowment, 3(1-2):1435-1446, 2010.
14. Codership Oy. http://galeracluster.com/products/.
15. J. Do et al. Query processing on smart ssds: opportunities and challenges. In SIGMOD, pages 1221-1230. ACM, 2013.
16. M. Hasenstein. The logical volume manager (lvm). White paper, 2001.
17. P. Huang et al. Bvssd: Build built-in versioning flash-based solid state drives. In SYSTOR, pages 11:1-11:12, New York, NY, USA, 2012. ACM.
18. Hybrid Incremental MySQL Backups. https://www.facebook.com/notes/facebook-engineering/hybrid-incremental-mysql-backups/10150098033318920/.
19. W.-H. Kang et al. Flash-based extended cache for higher throughput and faster recovery. Proc. VLDB Endow., 5(11):1615-1626, July 2012.
20. W.-H. Kang et al. X-ftl: Transactional ftl for sqlite databases. In SIGMOD, pages 97-108, New York, NY, USA, 2013. ACM.
21. W.-H. Kang et al. Durable write cache in flash memory ssd for relational and nosql databases. In SIGMOD, pages 529-540, New York, NY, USA, 2014. ACM.
22. A. Kopytov. Sysbench: A system performance benchmark, 2004.
23. S.-W. Lee et al. A case for flash memory ssd in enterprise database applications. In SIGMOD, pages 1075-1086. ACM, 2008.
24. S.-W. Lee et al. Advances in flash memory ssd technology for enterprise database applications. In SIGMOD, pages 863-870, New York, NY, USA, 2009. ACM.
25. D. Lomet, Z. Vagena, and R. Barga. Recovery from "bad" user transactions. In SIGMOD, pages 337-346, New York, NY, USA, 2006. ACM.
26. MongoDB. https://www.mongodb.com.
27. C. B. Morrey and D. Grunwald. Peabody: The time travelling disk. In MSST, pages 241-253, April 2003.
28. MySQL Database Server. https://dev.mysql.com/.
29. MySQL Replication. http://dev.mysql.com/doc/refman/5.6/en/replication.html.
30. MySQL Replication for High Availability - Tutorial. http://severalnines.com/tutorials/mysql-replication-high-Availability-Tutorial.
31. mysqldump. http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.
32. G. Oh et al. Share interface in flash storage for relational and nosql databases. In SIGMOD, pages 343-354, New York, NY, USA, 2016. ACM.
33. X. Ouyang et al. Beyond block i/o: Rethinking traditional storage primitives. In HPCA, pages 301-311. IEEE, 2011.
34. Z. Peterson and R. Burns. Ext3cow: A time-shifting file system for regulatory compliance. ACM Transactions on Storage (TOS), 1(2):190- 212, 2005.
35. PostgreSQL. http://www.postgresql.org.
36. T. Pott. http://www.theregister.co.uk/2014/09/24/storagesupercapacitors/, Sep 2014.
37. V. Prabhakaran et al. Transactional flash. In OSDI, pages 147-160, Berkeley, CA, USA, 2008. USENIX Association.
38. C. Qian, Y. Huang, X. Zhao, and T. Nakagawa. Optimal backup interval for a database system with full and periodic incremental backup. Journal of Computers, 5(4):557-564, 2010.
39. O. Rodeh et al. Btrfs: The linux b-Tree filesystem. ACM Transactions on Storage (TOS), 9(3):9, 2013.
40. SAMSUNG 843Tn Data Center Series. http://www.samsung.com/semiconductor/global/file/insight/2015/08/PSG20142HFINAL-1.pdf.
41. B. Schwartz, P. Zaitsev, and V. Tkachenko. High performance MySQL: Optimization, backups, and replication. " O'Reilly Media, Inc.", 2012.
42. S. Seshadri et al. Willow: A user-programmable ssd. In OSDI, pages 67-80, Broomfield, CO, 2014. USENIX Association.
43. S. Subramanian et al. Snapshots in a flash with iosnap. In EuroSys, pages 231-2314, New York, NY, USA, 2014. ACM.
44. K. Sun et al. Ltftl: Lightweight time-shift flash translation layer for flash memory based embedded storage. In EMSOFT, pages 51-58, New York, NY, USA, 2008. ACM.
45. Y. Tan et al. Cabdedupe: A causality-based deduplication performance booster for cloud backup services. In IPDPS, pages 1266-1277. IEEE, 2011.
46. xtrabackup. https://www.percona.com/software/mysql-database/percona-xtrabackup.
47. Q. Yang et al. Trap-Array: A disk array architecture providing timely recovery to any point-in-Time. In ISCA, pages 289-301, Washington, DC, USA, 2006. IEEE Computer Society.