mysqlbinlog support filter binlog_events by field values

[seanlook]

TenDB have enhanced mysqlbinlog to filter binlog row_events.
It's useful to track the change of some record, and no need to scrape the rows from massive output of mysqlbinlog. Just use --filter-rows options to filter rows out, and its result can be applied to mysqld.
Work with --flashback options, the binlog_event is reverted. That's:

1. WRITE_ROWS_EVENT is converted to DELETE_ROWS_EVENT
2. DELETE_ROWS_EVENT is converted to WRITE_ROWS_EVENT
3. Exchange the before and after image for UPDATE_ROWS_EVENT

This feature need binlog_format=ROW and binlog_row_image=FULL. You can use --query-event-handler and --filter-statement-match-[handler] to tell mysqlbinlog how to handle QUERY_EVENT.

Combine this options together, mysqlbinlog flashback support specific records rollback in a short time.

Read this docs to get more info: https://tendbcluster.com/book-cn/Documentation/tendb/mysqlbinlog-flashback.html

[seanlook]

Full options enhanced:

  -L, --databases=name 
                      List entries for these databases (local log only).Give
                      the database names in a comma separated list.
  --tables=name       List entries for these tables (local log only).Give the
                      tables names in a comma separated list.
  -B, --flashback     Flashback feature can rollback you committed data to a
                      special time point.
  --flashback-databases=name 
                      List entries for these flashback databases (local log
                      only).Give the database names in a comma separated list.
  --flashback-tables=name 
                      List entries for these flashback tables (local log
                      only).Give the tables names in a comma separated list.
  --flashback-databases-ignore=name 
                      List entries for ignoring these databases to flashback
                      whole tables (local log only).Give the database names in
                      a comma separated list.
  --flashback-tables-ignore=name 
                      List entries for ignoring these tables to flashback. not
                      work with --filter-rows (local log only).Give the tables
                      names in a comma separated list.
  --conv-event-update-to-write 
                      Whether convert the update_event's after image to
                      write_event.It's useful to work with imdepotent mode
  --filter-rows=name  Filter string or file to filter rows from event. (local
                      log only).Format: '@1,@2 100,aaa'. Must work with
                      --tables or --flashback-tables. You can use @2:hex format 
                      to tell mysqlbinlog its' varchar/varbinary/blob value is a hex. 
                      Also you can use @1:signed to mark it as a signed int/
                      tinyint/smallint/mediumint/bigint
  --query-event-handler=name 
                      Decide how to handle the query events like statement or
                      ddl.  Only error|keep|ignore|safe allowed. (error: exit
                      when encountered any query event. keep or ignore all
                      query event. safe: work with --filter-statement-match-error
                      and --filter-statement-match-ignore)
  --filter-statement-match-error=name 
                      Exit when this string is matched in query event. Comma
                      separated. Only work when
                      query-event-handler=keep|ignore|safe
  --filter-statement-match-ignore=name 
                      Ignore the query event when this string is matched. Comma
                      separated. Only work when query-event-handler=error|safe
  --filter-lines-terminated-by=name 
                      Lines in the filter file are terminated by the given
                      string.
  --filter-fields-terminated-by=name 
                      Fields in the filter file are terminated by the given
                      string.
  --filter-fields-enclosed-by=name 
                      Fields in the filter file are enclosed by the given
                      character.