MySQL 8 Cookbook

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.