For those who haven’t seen it so far, my mysqlbinlog patch is aimed for use in continuous backup situations.  It is designed retrieve binary logs direct from remote servers and write them directly to disk in their raw format.

When combined with mysqldump snapshots you can have an almost up-to-the-second point-in-time backup for your server just in case its blown off the face of the earth.  The advantage this has over a blackhole slave is you can run multiple instances of mysqlbinlog on one server with minimal overhead to backup multiple servers into one.  Its also much easier to setup.

After some great input from a user of my patch and Luís Soares, who is reviewing my patch as a possible community contribution submission into MySQL 6.0, I have made several fixes.

You can find the new patch here, and for basic usage information please see my previous blog post here.

Change Summary:

• Fixed a possible segfault
• There were situations where an extra empty file could be created
• Fixed a couple of warnings
• Use more mysys functions
• Add test cases
• Minor code cleanups

Source/Kaynak : http://blogs.sun.com/LinuxJedi/entry/mysqlbinlog_raw_mode_update