MySQL binlog opening steps

Binlog is a binary log file that is used to record MySQL data changes. Binlog logs can play a big role when restoring data. MySQL master-slave replication uses the binlog principle

1. After logging in to MySQL, use the following command to check whether binlog is enabled

show variables like 'log_%';

2. Edit the configuration file

vi /etc/my.cnf

3. Add the following content

server_id=2

log_bin = mysql-bin

binlog_format = ROW

expire_logs_days = 30

4. Restart MySQL service

systemctl restart mysqld

5. Use the command show variables like 'log_%' again to view it. If it is ON, it means binlog is turned on.

6. The binlog log file storage path is

/var/lib/mysql

7. Files like mysql-bin.000001 mysql-bin.000002 will be generated in this path