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

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.

Covr iJOE Vol. 18 No. 13 (2022)

Downloads

Published

2022-10-19

How to Cite

Petrov, P., Kuyumdzhiev, I., Dimitrov, G., & Kremenska , A. (2022). Relative Performance of Various Types of Repositories for MySQL Archive Backup and Restore Operations. International Journal of Online and Biomedical Engineering (iJOE), 18(13), pp. 152–159. https://doi.org/10.3991/ijoe.v18i13.33429

Issue

Vol. 18 No. 13 (2022)

Section

Short Papers

License

Copyright (c) 2022 Pavel Petrov, Ivan Kuyumdzhiev, Georgi Dimitrov, Adelina Kremenska

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

The submitting author warrants that the submission is original and that she/he is the author of the submission together with the named co-authors; to the extend the submission incorporates text passages, figures, data or other material from the work of others, the submitting author has obtained any necessary permission.
Articles in this journal are published under the Creative Commons Attribution Licence (CC-BY What does this mean?). This is to get more legal certainty about what readers can do with published articles, and thus a wider dissemination and archiving, which in turn makes publishing with this journal more valuable for you, the authors.
By submitting an article the author grants to this journal the non-exclusive right to publish it. The author retains the copyright and the publishing rights for his article without any restrictions.