Open MySQL binlog log on Linux

linux Turn on MySQL binlog journal

binlog journal , namely binary log, It's a binary log file . It has two functions , One is incremental backup , That is, only the newly added content is backed up ; Second, it is used for master-slave replication, etc , That is, the master node maintains a binlog Log files , Slave node slave binlog Data synchronization in . We can go through binlog Log recovery data . Let's talk about opening MySQL binlog The process of logging ：

1、 Sign in MySQL, see binlog The status of the log

  Sign in MySQL after , Input show variables like '%log_bin%'; Check out binlog Log for OFF The closed position ;

2、 Turn on MySQL binlog journal

  sign out MySQL, Use vi Editor changes MySQL Of my.cnf The configuration file

  stay my.cnf Add two sentences as shown in the following figure to the configuration file

  Save exit after adding

 server-id Representing a single node id, Because there is only one node , So you can put id Randomly assigned to a number , There will be id Set to 1. If there are multiple nodes in the cluster , be id Cannot be the same

  The second sentence is designated binlog The name of the log file is mysql-bin, And its storage path

3、 restart MySQL

see /var/lib/mysql Contents under the directory

  Use command ：ls /var/lib/mysql;

Be careful ： Every time the server （ database ） restart , The server will call flush logs;, Create a new binlog journal

         Because I've restarted the database before , So here is mysql-bin.000001 To mysql-bin.000003 These three files . What you see here

It should be mysql-bin.000001 and mysql-bin.index Two documents

Now enter again MySQL, see binlog The status of the log . Show binlog Log for ON On state

Here we are ,binlog The log is opened successfully .