What is Percona XtraBackup?

This Percona XtraBackup MySQL video will walk you through what one of Percona's flagship offerings - Percona XtraBackup - is and what features does this SQL database tool for MySQL and its counterparts including Percona Server contain.

Percona XtraBackup is an open-source hot database backup utility for MySQL-based database servers. The tool does not lock SQL databases during the database backup procedure.

Percona XtraBackup can back up data that's based on InnoDB, XtraDB, and MyISAM storage engines on database servers running MySQL and Percona Server.

Percona XtraBackup provides you with uninterrupted SQL query (database transaction) processing, automatic database backup verification, and faster backup restore time.

Some of the features of Percona XtraBackup include the ability to create hot MySQL InnoDB backups without interruptions, make incremental database backups, stream compressed MySQL backups to other servers, move tables between MySQL Servers without downtime, create new MySQL Server replicas, the ability to skip secondary database index pages and recreate SQL index pages, the ability to export individual database tables, and more.

Are you a user of Percona XtraBackup? How do you like the tool? Share your opinion in the comment section below!

Music:
Music | Palm Trees by Declan DP

#coding #database #sql #software #data #mysql