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

Binary log backup

You know that binary logs are needed for point-in-time recovery. In this section, you will understand how to take a backup of binary logs. The process streams the binary logs from the database server to a remote backup server. You can take the binary log backup from either the slave or the master. If you are taking the binary log backup from the master and the actual backup from the slave, you should use --dump-slave to get the corresponding master log position. If you are using mydumper or XtraBackup, it gives both the master and slave binary log positions.

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