BinLOG – Adamhuan's Data Center – 【逻辑驱动数据】

MySQL Binlog解析工具：mysqlbinlog，由谁提供的？

很多常用的命令用顺手了之后，你往往会忘记，在系统刚刚部署起来的时候并非如此，… 那么方便的体验并不是与生俱来的，它们需要被努力与被实现，才能变成最后期望的样子。

对于MySQL的binlog解析工具：mysqlbinlog也是这样。
该工具并非默认由Linux或者MySQL安装包提供的。[……]

Posted on: 2018年9月21日 2018年9月21日
Author: Adamhuan
Categories: BinLOG, MySQL
Tags: binlog, Linux, MySQL, mysqlbinlog, Percona-Server-client-57-5.7.22-22.1.el7.x86_64, rpm -qf
Leave a comment: MySQL Binlog解析工具：mysqlbinlog，由谁提供的？

MySQL：binlog文件的清理

首先，看看一个MySQL是不是开启了binlog

[root@mariadb-cluster-1 ~]# cat /etc/my.cnf.d/server.cnf | grep --color "log-bin"
log-bin=/var/lib/mysql/binlog_data/mysql-bin
[root@mariadb-cluster-1 ~]# 
[root@mariadb-cluster-1 ~]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.2.11-MariaDB-log MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show variables like 'log_bin%';
+---------------------------------+--------------------------------------------+
| Variable_name                   | Value                                      |
+---------------------------------+--------------------------------------------+
| log_bin                         | ON                                         |
| log_bin_basename                | /var/lib/mysql/binlog_data/mysql-bin       |
| log_bin_compress                | OFF                                        |
| log_bin_compress_min_len        | 256                                        |
| log_bin_index                   | /var/lib/mysql/binlog_data/mysql-bin.index |
| log_bin_trust_function_creators | OFF                                        |
+---------------------------------+--------------------------------------------+
6 rows in set (0.00 sec)

MariaDB [(none)]>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

[root@mariadb-cluster-1 ~]# cat /etc/my.cnf.d/server.cnf | grep --color "log-bin"

log-bin=/var/lib/mysql/binlog_data/mysql-bin

[root@mariadb-cluster-1 ~]#

[root@mariadb-cluster-1 ~]# mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 11

Server version: 10.2.11-MariaDB-log MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show variables like 'log_bin%';

+---------------------------------+--------------------------------------------+

| Variable_name | Value |

+---------------------------------+--------------------------------------------+

| log_bin | ON |

| log_bin_basename | /var/lib/mysql/binlog_data/mysql-bin |

| log_bin_compress | OFF |

| log_bin_compress_min_len | 256 |

| log_bin_index | /var/lib/mysql/binlog_data/mysql-bin.index |

| log_bin_trust_function_creators | OFF |

+---------------------------------+--------------------------------------------+

6 rows in set (0.00 sec)

MariaDB [(none)]>

从上面的结果可以看到，当前数据库开启了BINLOG。

看看BINLOG的状态：

MariaDB [(none)]> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000012 |      328 |              |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.01 sec)

MariaDB [(none)]>

1

2

3

4

5

6

7

8

9

MariaDB [(none)]> show master status;

+------------------+----------+--------------+------------------+

+------------------+----------+--------------+------------------+

| mysql-bin.000012 | 328 | | |

+------------------+----------+--------------+------------------+

1 row in set (0.01 sec)

MariaDB [(none)]>

可以看到，当前位于1[……]

Posted on: 2017年12月23日 2017年12月23日
Author: Adamhuan
Categories: BinLOG, MySQL
Tags: binlog, Linux, MySQL, purge, rm, 清理
Leave a comment: MySQL：binlog文件的清理

Shell + MySQL：自动应用binlog

说明文档：http://url.cn/4324AMF
代码托管：
https://github.com/adamhuan/linux-script/tree/master/MySQL/%E8%87%AA%E5%8A%A8%E5%BA%94%E7%94%A8binlog%E6%81%A2%E5%A[……]