How to read a mysql binlog

mysql mysqlbinlog
user4930867 picture user4930867 · Jun 3, 2015 · Viewed 22.8k times · Source

I want to write a service to tail the mysql bin log to get notifications about database changes.

Is there an open source library that reads and parses mysql bin log in ROW format?

Answer

Tan Hong Tat picture Tan Hong Tat · Jun 3, 2015

Use mysqlbinlog.

The server's binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents of relay log files written by a slave server in a replication setup because relay logs have the same format as binary logs.

Source: https://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog.html

Related questions

mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)

I faced with this error after trying to restart MySQL server. root@private:/# mysqld_safe 140618 03:56:53 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect. 140618 03:56:53 mysqld_safe …

Read More
Searching MySQL Bin Log for a Query

Is it possible to query the mysql bin log for a particular query? For example, suppose I want to know if anyone in the last hour did a specific query (like 'Update tableX where userName = 'bob'"). I just want to …

Read More
MySQL Replication fails with error "Could not parse relay log event entry."

I've searched google thoroughly for a definitive solution or set of steps to resolve this issue, but there don't seem to be many high quality results, and I haven't found the question on stack overflow. We're trying to set up …

Read More