Database backup and recovery: a review with test implementation for MYSQL and NOSQL databases

Abstract

Databases hold cloud data and applications, and cloud-hosted services and apps must support more data. Therefore, the backup and recovery capabilities of the database are crucial. Regular backups of structured and stored data can reduce data loss and corruption. Administrators restore the database from a backup in the event of a hardware failure, data loss due to bugs, or other issues. The correct methods and features are important to the database administrator and user to apply the right technique at right time. The aim of the study incorporates identifying the available techniques of database backup and recovery with the implementation method. As a result, we can distinguish between the types of backup such as full, incremental, and differential, as well as recovery techniques such as log recovery and shadow paging. Additionally, the results indicated the adoption of MySQL and NoSQL backup and recovery methodologies. The result also showed the implementation of backup and recovery techniques of MySQL and NoSQL. This could be a solution to database backup and recovery issues if we use the appropriate approach and functionality.