Scientific Online Resource System

Izvestia Journal of the Union of Scientists - Varna. Economic Sciences Series

Backup and recovery with MySQL community edition: expectations and reality

Ivan Kuyumdzhiev

Abstract

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.


Keywords

backup, recovery, database, MySQL

Full Text


References

Банков, Б. (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


Refbacks

Font Size


|