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

Consistent backup

The metadata file in the backup directory contains the binary log coordinates for consistent backup.

On a master, it captures the binary log positions:

shell> sudo cat /backups/metadata Started dump at: 2017-08-20 12:44:09SHOW MASTER STATUS:    Log: server1.000008    Pos: 154    GTID:

On a slave, it captures the binary log positions of both master and slave:

shell> cat /backups/metadata Started dump at: 2017-08-26 06:26:19SHOW MASTER STATUS: Log: server1.000012 Pos: 154 GTID:SHOW SLAVE STATUS: Host: 35.186.158.188 Log: master-bin.000013
 Pos: 4633 GTID:Finished dump at: 2017-08-26 06:26:24

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