O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Taking backups using XtraBackup

XtraBackup is an open source backup software provided by Percona. It copies flat files without shutting down the server, but to avoid inconsistencies, it uses a redo log file. It is widely used by many companies as a standard backup tool. The advantages are that it is very fast compared to logical backup tools and recovery is also very fast.

This is how Percona XtraBackup works (taken from the Percona XtraBackup documentation):

  1. It copies your InnoDB data files, which results in data that is internally inconsistent; but then it performs crash recovery on the files to make them a consistent, usable database again.
  2. This works because InnoDB maintains a redo log, also called the transaction log. This contains ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required