Percona XtraBackup is an open-source, free, hot backup utility for MySQL-based servers that performs non-blocking backups, meaning it does not lock your database during the backup process. It is designed for InnoDB, XtraDB, MyISAM, and MyRocks storage engines, making it suitable for high-load production environments. Key Features and Benefits
No Locking: It enables backups without disrupting application performance, ensuring 24×7 availability.
Hot Backups: It can perform backups while the database is active and running.
Faster Restoration: As a physical backup tool, it copies actual data files, which is generally faster than logical backups (like mysqldump) for large datasets.
Compression and Security: Supports compressed backups and provides high security.
Incremental Backups: Allows for taking incremental backups to save time and storage space. Supported EnvironmentsPercona XtraBackup works with: MySQL 8.0 and 5.7 servers. Percona Server for MySQL (with XtraDB). Percona XtraDB Cluster. Limitations
MariaDB Support: It is not supported for MariaDB versions 10.3 or later, and only partially supported for 10.1 and 10.2.
Storage Engines: While it supports InnoDB and MyISAM, its primary advantage is with transactional engines like InnoDB/XtraDB.
You can find the official documentation and installation guides on the Percona website or explore the source code on GitHub.
If you’d like to explore how to use this for a specific setup, I can provide information on: Installing Percona XtraBackup Creating a full backup Restoring a backup Setting up incremental backups Let me know which of these you’d like to know more about! Percona XtraBackup – Documentation
Leave a Reply