Real-Time MySQL binary log parsing

Question

we are dealing with a legacy application built on MySQL 5.0 (MyISAM). I need to know in real-time when an update, delete, or insert happens to a particular table. The 'gotcha' is that I can't change the db (i.e. write triggers) in any way. I have to use the bin log, replication or something else which is somewhat non-invasive.

We've looked at using the 'mysqlbinlog' command to parse the binary log. However, this is not real-time and we'd rather do something more event driven.

Any ideas?

did you ever come up with anything for this?

Oren Mazor
– Oren Mazor

2012-10-18 17:25:02 +00:00
Commented Oct 18, 2012 at 17:25 — Oren Mazor
– Oren Mazor, Commented Oct 18, 2012 at 17:25

Javier · Accepted Answer · 2008-10-23 20:50:22Z

6

check MySQL Proxy. it lets you tap right in the command/response stream, and it's fully programmable in Lua. you can even modify commands in real time, if you want

answered Oct 23, 2008 at 20:50

Javier

63.1k9 gold badges82 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JJohnson Over a year ago

We've looked at that a bit and that could work. The plan would be: 1) Change the port that MySQL listens on and then setup the on MySQL's old port. 2) Capture actions to our table and call some shell command. However, we'd much rather use <b>mysqlbinlog</b> in a <b>daemon</b> like way.

Miljen Mikic Over a year ago

MySQL Proxy is not actively developed anymore. MySQL Router replaced it, with the similar functionality.

h4ck3rm1k3 · Accepted Answer · 2011-03-26 10:51:45Z

0

I am experimenting with using mysqlbinlog -R -t to get the feed in realtime, it works until the end, then you need to find the last position read, and continue there, combined with a query for log files this should give you all the files one after another.... am experimenting with this..

answered Mar 26, 2011 at 10:51

h4ck3rm1k3

2,10022 silver badges33 bronze badges

Comments

h4ck3rm1k3 · Accepted Answer · 2011-03-26 12:00:43Z

0

Also, if you want to know in real time if a change has taken place on one table, then i would suggest that you make a trigger on the master, and then you can insert data into a separate database that is replicated on its own. inside the trigger you can access another server even using a federated server. http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html

answered Mar 26, 2011 at 12:00

h4ck3rm1k3

2,10022 silver badges33 bronze badges

Collectives™ on Stack Overflow

Real-Time MySQL binary log parsing

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related