Tagged articles
6 articles
Page 1 of 1
Laravel Tech Community
Laravel Tech Community
Jun 7, 2023 · Databases

MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures

This article explains the differences between MySQL logical and physical backups, introduces Percona XtraBackup, provides step‑by‑step installation commands, details common parameters, and demonstrates full and incremental backup and recovery workflows with practical code examples.

Database AdministrationIncremental BackupPercona XtraBackup
0 likes · 13 min read
MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures
dbaplus Community
dbaplus Community
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
Efficient Ops
Efficient Ops
Oct 20, 2021 · Databases

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

This article explains why database backup is essential, outlines multi‑region and multi‑media deployment requirements, compares physical and logical backup methods, reviews MySQL backup tools, shows performance differences, and provides practical guidance on verifying backup integrity and minimizing RTO and RPO.

Physical BackupRPORTO
0 likes · 12 min read
Mastering MySQL Backups: Strategies, Tools, and RTO/RPO Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 23, 2021 · Databases

Testing Remote Backup Capability of MySQL Enterprise Backup (mysqlbackup) 4.0

This article documents a practical test of MySQL Enterprise Backup 4.0, examining whether the tool can perform remote physical backups using the --host option, describing the test environment, commands, observed behaviours for both local and remote scenarios, and the conclusions drawn from the results.

MySQL Enterprise BackupPhysical Backupdatabase testing
0 likes · 6 min read
Testing Remote Backup Capability of MySQL Enterprise Backup (mysqlbackup) 4.0
JD Retail Technology
JD Retail Technology
Sep 5, 2019 · Databases

CB‑SQL Backup and Restore: Logical and Physical Methods

This article explains CB‑SQL's two backup approaches—logical (using DUMP and IMPORT) and physical (using BACKUP and RESTORE)—detailing their mechanisms, supported formats, storage options, performance characteristics, and how they ensure reliable data recovery for large‑scale distributed databases.

BackupCB-SQLPhysical Backup
0 likes · 7 min read
CB‑SQL Backup and Restore: Logical and Physical Methods