This publication explores backup and recovery capabilities of the most popular database management system - MySQL Community Edition. Available backup types are categorized and compared theoretically. Experiments are conducted to measure the capabilities of each backup and recovery method. Knowing these characteristics could help choosing backup type, storage engine (MyISAM or InnoDB) and MySQL settings that would be most suitable for business needs. Conducted experiments combined with analytical approach can lead to building effective backup and recovery strategies.
Банков, Б. (2018) Софтуерна система за автоматизирана обработка на неструктурирани данни от социалните мрежи. ИУ-Варна
Куюмджиев, И. (2018) Методологически и технологични аспекти при архивирането на бази от данни. Цани Калянджиев
Петров, П. (2008) Сървърно програмиране. Варна: Наука и икономика.
Сълова, С. (2017) Тенденции в развитието на софтуерните платформи с отворен код за създаване на електронни магазини. Известия на Съюза на учените - Варна, Серия Икономически науки, Варна: Съюз на учените, 2, 187 - 196
Bell, C. (2013) Expert MySQL. Apress
Bradford, R. (2012) Effective MySQL Backup and Recovery. McGraw Hill Professional.
DuBois, P. (2009) MySQL. Fourth Edition. Addison-Wesley
DuBois, P. (2014) MySQL Cookbook: Solutions for Database Developers and Administrators. O'Reilly Media, Inc.
Murach, J. (2012) Murach's MySQL. Mike Murach & Associates, Incorporated
MySQL (2017a) Benefits of Using InnoDB Tables. [Online] Available from: http://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html [Accessed: 16/10/2018]
MySQL (2018b) Chapter 16 Alternative Storage Engines [Online] Available from: https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html [Accessed: 16/10/2018]
MySQL (2018c) Database Backup Methods. [Online] Available from: http://dev.mysql.com/doc/refman/8.0/en/backup-methods.html [Accessed: 16/10/2018]
MySQL (2018d) MySQL Customers. [Online] Available from: https://www.mysql.com/customers/ [Accessed: 16/12/2017]
MySQL (2018e) FLUSH Syntax. [Online] Available from: https://dev.mysql.com/doc/refman/8.0/en/flush.html [Accessed: 16/10/2018]
MySQL (2018f) mysqldump — A Database Backup Program. [Online] Available from: http://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#option_mysqlpump_single-transaction [Accessed: 16/12/2017]
MySQL (2018g) mysqldump — Performance and Scalability Considerations. [Online] Available from: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#mysqldump-performance [Accessed: 11/07/2018]
MySQL (2018h) The MyISAM Storage Engine. [Online] Available from: https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html [Accessed: 16/10/2018]
MySQL (2018i) Using mysqlbinlog to Back Up Binary Log Files. [Online] Available from: https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html [Accessed: 16/10/2018] mysqldump-secure (2017) Live builds. [Online] Available from: https://mysqldump-secure.org/ [Accessed: 16/10/2018]
Schwartz, B., Zaitsev, P., Tkachenko, V. (2012) High Performance MySQL: Optimization, Backups, and Replication. O'Reilly Media, Inc
Vaswani, V. (2009) MySQL Database Usage & Administration. McGraw Hill Professional
