OnWorks favicon

filter_mysqlbinlogp - Online in the Cloud

Run filter_mysqlbinlogp in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command filter_mysqlbinlogp that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator



filter_mysqlbinlog - Trimming ROLLBACK statements and equivalent BINLOG events added by
mysqlbinlog. This script is now obsolete.


mysqlbinlog binary_or_relay_log_file | filter_mysqlbinlog

Note that this script is now obsolete and not used by MHA by default.


mysqlbinlog command provided by Oracle implicitly adds ROLLBACK statements and equivalent
BINLOG events. But this causes problems when recovering slave servers. To recover slaves,
MHA might need to apply the following binlog events.
1) Relay log events from Relay_Log_Pos to the end of the relay log file
2) Differential relay log events from the latest slave
3) Differential binary log events from the dead master mysqlbinlog command needs to be
executed on these files separately. If a transaction does not end by 1) or 2), implicit
ROLLBACK event rolls back the transaction, which will result in inconsistency.
filter_mysqlbinlog is a tool to fix this issue. Note that ROLLBACK statements themselves
are added in usual situations. For example, when you execute 1. BEGIN; 2. Updating
transactional tables 3. Updating non-transactional tables 4. ROLLBACK, a ROLLBACK
statement is written to the binary log to rollback transactional queries. This is normal
situation so filter_mysqlbinlog must not remove all ROLLBACK events.

Note that this script is now obsolete and not used by MHA by default.

Use filter_mysqlbinlogp online using onworks.net services

Free Servers & Workstations

Download Windows & Linux apps

  • 1
    Brackets is a free, modern open-source
    text editor made especially for Web
    Development. Written in HTML, CSS, and
    JavaScript with focused visual tools and
    Download Brackets
  • 2
    Free Pascal Compiler
    Free Pascal Compiler
    A 32/64/16-bit Pascal compiler for
    Win32/64/CE, Linux, Mac OS X/iOS,
    Android, FreeBSD, OS/2, Game Boy
    Advance, Nintendo NDS and DOS;
    semantically compatible wi...
    Download Free Pascal Compiler
  • 3
    Canon EOS DIGITAL Info
    Canon EOS DIGITAL Info
    Canon doesn�t have shutter count
    included on the EXIF information of an
    image file, as opposed to Nikon and
    Pentax. There�s no official Canon based
    application ...
    Download Canon EOS DIGITAL Info
  • 4
    rEFInd is a fork of the rEFIt boot
    manager. Like rEFIt, rEFInd can
    auto-detect your installed EFI boot
    loaders and it presents a pretty GUI
    menu of boot option...
    Download rEFInd
  • 5
    ExpressLuke GSI
    ExpressLuke GSI
    This SourceForge download page was to
    grant users to download my source built
    GSIs, based upon phhusson's great
    work. I build both Android Pie and
    Android 1...
    Download ExpressLuke GSI
  • 6
    Music Caster
    Music Caster
    Music Caster is a tray music player
    that lets you cast your local music to a
    Google Cast device. On the first run,
    you will need to click the arrow in your
    Download Music Caster
  • More »

Linux commands