The Ultimate Guide to High Availability with MariaDB

Flashback

You are viewing an old version of this article. View the current version here.
MariaDB starting with 10.2.4

DML-only flashback was introduced in MariaDB 10.2.4

Flashback is a feature that will allow instances, databases or tables to be rolled back to an old snapshot. Currently only DML flashback is supported.

It's implemented on the server-level by full image format binary logs (--binlog-row-image=FULL), so it supports all engines.

Because the flashback binlog events will be stored in memory, you should make sure your server has enough memory for this feature.

New arguments

mysqlbinlog has a new option: --flashback or -B that will let it work in flashback mode.

Example

With a table "t" in database "test", you can compare the output with "--flashback" and without.

  1. client/mysqlbinlog /data/mysqldata_10.0/binlog/mysql-bin.000001 -vv -d test -T t --start-datetime="2013-03-27 14:54:00" > /tmp/1.sql
  2. client/mysqlbinlog /data/mysqldata_10.0/binlog/mysql-bin.000001 -vv -d test -T t --start-datetime="2013-03-27 14:54:00" -B > /tmp/2.sql

Then, importing the output flashback file (/tmp/2.log), you can flashback your database/table to the specific time (--start-datetime).

If you know the exact position, " -- start-position " also works. mysqlbinlog will output the flashback logs that can flashback to the " -- start-position " position.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.