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

Using binary logging

To enable binlog, you have to set log_bin and server_id and restart the server. You can mention the path and base name in the log_bin itself. For example, log_bin is set to /data/mysql/binlogs/server1, the binary logs are stored in the /data/mysql/binlogs folder with the name server1.000001, server1.000002, and so on. The server creates a new file in the series each time it starts or flushes the logs or the current log's size reaches max_binlog_size. It maintains the server1.index file, which contains the location of each binary log.

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