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

被引：1
作者：
Petrov, Pavel [1 ]
Kuyumdzhiev, Ivan [1 ]
Dimitrov, Georgi [2 ]
Kremenska, Adelina [3 ]
机构：
[1] Univ Econ Varna, Dept Informat & Comp Sci, Varna, Bulgaria
[2] Univ Lib Studies & Informat Technol, Sofia, Bulgaria
[3] Bulgarian Acad Sci, Inst Robot, Acad Georgi Bonchev Str, Sofia 1113, Bulgaria
来源：
INTERNATIONAL JOURNAL OF ONLINE AND BIOMEDICAL ENGINEERING | 2022年 / 18卷 / 13期
关键词：
database backup; database restore; storage engine; archiving; MySQL;
D O I：
10.3991/ijoe.v18i13.33429
中图分类号：
TP39 [计算机的应用];
学科分类号：
081203 ; 0835 ;
摘要：
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.
引用
收藏
页码：152 / 159
页数：8
相关论文
共 18 条
  • [1] Aqel M. J., 2020, INT J INTERACTIVE MO, V14, P107, DOI [10.3991/ijim.v14i10.15189, DOI 10.3991/IJIM.V14I10.15189]
  • [2] Asrial Syahrial, 2020, International Journal of Interactive Mobile Technologies, P125, DOI 10.3991/ijim.v14i15.12995
  • [3] Bell C, 2013, EXPERT MYSQL, DOI [10.1007/978-1-4302-4660-2, DOI 10.1007/978-1-4302-4660-2]
  • [4] Bradford R, 2012, EFFECTIVE MYSQL BACK
  • [5] DuBois P., 2014, MySQL cookbook: solutions for database developers and administrators
  • [6] DuBois P., 2009, MySQL, V4th
  • [7] Exploiting Cloud Computing and Web Services to Achieve Data Consistency, Availability, and Partition Tolerance in the Large-Scale Pervasive Systems
    Fadelelmoula A.A.
    [J]. International Journal of Interactive Mobile Technologies, 2021, 15 (15) : 74 - 102
  • [8] GitHub McAfee Engineering, 2021, MYSQL AUD LIC
  • [9] Kuyumdzhiev I, 2019, INT MULTIDISCIPLINAR, V19, P167, DOI 10.5593/sgem2019/2.1/S07.022
  • [10] Kuyumdzhiev I., 2019, SERDICA J COMPUTING, V13, P139, DOI [10.55630/sjc.2019.13.139-154, DOI 10.55630/SJC.2019.13.139-154]
12