Percona XtraBackup is designed to create backups of MySQL databases without interrupting transaction processing, ensuring applications remain fully available. It provides a reliable and efficient way to safeguard data, minimizing downtime and maximizing database performance. This tool empowers users to complete backups quickly, save on disk space and network bandwidth through compression and streaming, automate backup verification, and benefit from faster restore times and higher uptime. Key functionalities include creating hot InnoDB backups without pausing the database, making incremental backups of MySQL, and streaming compressed backups to another server. It also allows for moving tables between MySQL servers online and creating new MySQL replication replicas easily. Percona XtraBackup is engineered to backup MySQL without adding significant load to the server, utilizing backup locks as a lightweight alternative to `FLUSH TABLES WITH READ LOCK` to avoid blocking DML queries that modify InnoDB tables. The software performs throttling based on the number of IO operations per second, optimizing resource usage. It skips secondary index pages during backup and recreates them during preparation, enhancing efficiency. Additionally, Percona XtraBackup can export individual tables, even from a full backup, regardless of the InnoDB version, and these exported tables can be imported into various Percona Server and MySQL versions.

Features

• Create hot InnoDB backups
  • Enables backups without pausing the database, ensuring continuous operation.
• Make incremental backups of MySQL
  • Reduces backup time and storage space by only backing up changes.
• Stream compressed MySQL backups to another server
  • Saves disk space and network bandwidth during backup transfers.
• Move tables between MySQL servers online
  • Facilitates database maintenance and upgrades with minimal downtime.
• Create new MySQL replication replicas easily
  • Simplifies the setup of replication for high availability and disaster recovery.
• Backup MySQL without adding load to the server
  • Minimizes performance impact on production databases during backups.