Internet Archive Scholar

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

Pavel Petrov, Ivan Kuyumdzhiev, Georgi Dimitrov, Adelina Kremenska
2022 International Journal of Online and Biomedical Engineering (iJOE)  

Preserved Fulltext

fulltext thumbnail
Web Archive Capture PDF (747.7 kB)
https://web.archive.org/web/20221020025239/https://online-journals.org/index.php/i-joe/article/download/33429/12093

A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL. The file type is application/pdf.

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
more » ... 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.
doi:10.3991/ijoe.v18i13.33429 fatcat:kz6tqylqondznj6kzb5kk5pe7y
DOAJ OJS
Citation

Pavel Petrov, Ivan Kuyumdzhiev, Georgi Dimitrov, Adelina Kremenska. "Relative Performance of Various Types of Repositories for MySQL Archive Backup and Restore Operations." International Journal of Online and Biomedical Engineering (iJOE) 18.13 (2022) 152-159