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
    VBA-M (Archived - Now on Github)
    VBA-M (Archived - Now on Github)
    Project has moved to
    Features:Cheat creationsave statesmulti
    system, supports gba, gbc, gb, sgb,
    Download VBA-M (Archived - Now on Github)
  • 2
    Linux System Optimizer and Monitoring
    Github Repository:
    Audience: End Users/Desktop. User
    interface: Qt. Programming La...
    Download Stacer
  • 3
    Fork of TeamWinRecoveryProject(TWRP)
    with many additional functions, redesign
    and more Features:Supports Treble and
    non-Treble ROMsUp-to-date Oreo kernel,
    Download OrangeFox
  • 4
    itop - ITSM  CMDB OpenSource
    itop - ITSM CMDB OpenSource
    IT Operations Portal: a complete open
    source, ITIL, web based service
    management tool including a fully
    customizable CMDB, a helpdesk system and
    a document man...
    Download itop - ITSM CMDB OpenSource
  • 5
    Clementine is a multi-platform music
    player and library organizer inspired by
    Amarok 1.4. It has a fast and
    easy-to-use interface, and allows you to
    search and ...
    Download Clementine
  • 6
    ATTENTION: Cumulative update 2.4.3 has
    been released!! The update works for any
    previous 2.x.x version. If upgrading
    from version v1.x.x, please download and
    Download XISMuS
  • 7
    Modular headtracking program that
    supports multiple face-trackers, filters
    and game-protocols. Among the trackers
    are the SM FaceAPI, AIC Inertial Head
    Tracker ...
    Download facetracknoir
  • More »

Linux commands