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.

How to do it...

Let's see how to play with the logs. I am sure you are going to love learning about them.

Enabling binary logs

1. Enable binary logging and set the server_id. Open the MySQL config file in your favorite editor and append the following lines. Choose server_id such that it will be unique to each MySQL server in your infrastructure. You can also simply put the log_bin variable in my.cnf without any value. In that case, the binary log...