May 28, 2022 · Databases

Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization

This article explains why backup is the last line of data security, outlines multi‑location and multi‑media deployment requirements, compares physical and logical backup methods, reviews MySQL backup tools, evaluates their speed, and provides practical guidance for testing backup validity and minimizing RTO and RPO.

Backup ToolsDatabase BackupPhysical Backup

0 likes · 14 min read

Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization

Tencent Database Technology

May 9, 2018 · Databases

Optimizing Xtrabackup Recovery Process for InnoDB Databases

Xtrabackup is an open-source hot backup tool for InnoDB and XtraDB databases, offering non-blocking backups with features like fast backup speeds, reliable physical backups, and efficient disk space usage. The recovery process involves complex log parsing and page flushing mechanisms, which can be optimized to improve performance, especially for large datasets.

Backup ToolsDatabase ManagementDatabase Recovery

0 likes · 16 min read

Optimizing Xtrabackup Recovery Process for InnoDB Databases