Relative Performance of Various Types of Repositories for MySQL Archive Backup and Restore Operations

Pavel Petrov; Ivan Kuyumdzhiev; Georgi Dimitrov; Adelina Kremenska

doi:10.3991/ijoe.v18i13.33429

Authors

Pavel Petrov University of Economics – Varna http://orcid.org/0000-0002-1284-2606
Ivan Kuyumdzhiev University of Economics - Varna
Georgi Dimitrov University of Library Studies and Information Technologies
Adelina Kremenska Institute of Robotics, Bulgarian Academy of Sciences

DOI:

https://doi.org/10.3991/ijoe.v18i13.33429

Keywords:

database backup, database restore, storage engine, archiving, MySQL

Abstract

The backup and restore operations are essential part of database system's administration process. Usually, the size of the database is a major factor that determines numerous practical issues, among which is what backup and recovery methods to be used. However, in addition, there are various types of storage systems (repositories) available in MySQL 8.0, for example MyISAM, Merge, Memory, InnoDB, CSV, Blackhole, Archive and Federated, which in general sense determine how to store each table into at least one file. Each of these storage systems have their own positive and negative characteristics, so when constructing logical archives, it is vital to compare the performance of those various types of repositories.

Author Biographies

Pavel Petrov, University of Economics – Varna

Department of Informatics, Assoc. Prof.

Adelina Kremenska , Institute of Robotics, Bulgarian Academy of Sciences

Adelina Georgieva Kremenska is a PhD Candidate, Institute of Robotics, Bulgarian Academy of Sciences, Acad. Georgi Bonchev str., 1113 Sofia, Bulgaria.