mysql 二進位制日誌

mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |      106 |              |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

mysql>  show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.00 sec)

開啟二進位制日誌

新增配置檔案/etc/my.cnf    log-bin引數

[root@JacTest01 binlogs]# more /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
log-bin=/var/lib/mysql/binlogs/mysql-bin

修改許可權

chown -R mysql:mysql /var/lib/mysql/binlogs

重新啟動mysql服務

[root@JacTest01 binlogs]# service mysqld start
正在啟動 mysqld：                                          [確定]

檢視日誌目錄下內容

[root@JacTest01 mysqllog]# cd /var/lib/mysql/binlogs/
[root@JacTest01 binlogs]# ll
總用量 12
drwxr-xr-x. 2 mysql mysql 4096 5月   4 16:58 mysql-bin
-rw-rw----. 1 mysql mysql  106 5月   4 17:00 mysql-bin.000001
-rw-rw----. 1 mysql mysql   40 5月   4 17:00 mysql-bin.index

使用特殊工具mysqlbinlog工具檢視日誌日誌內容

[root@JacTest01 binlogs]# mysqlbinlog mysql-bin.000001 
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4

刪除全部日誌：

mysql> reset master;
Query OK, 0 rows affected (0.00 sec)