Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Flashback - Rolling back a MySQL/MariaDB instance, database or table to a previous snapshot

Flashback - Rolling back a MySQL/MariaDB instance, database or table to a previous snapshot

 25 April - 2:20 PM - 3:10 PM @ Ballroom F
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MariaDB
MySQL
Devops
Tools and Techniques

Description

Flashback: - Makes use of the binary log to roll back an instance, database or table to a previous snapshot. - Is available as a first release is MariaDB 10.2.4/RDS MySQL 5.6. - Is implemented on the server-level, so supports all storage engines. - Makes use of full image format binary logs. - Is currently a mysqlbinlog feature (the --flashback option) The talk will discuss how Flashback is currently implemented, what it currently can and can't do, and what features are in the pipeline for future MariaDB/AliSQL releases.

Speakers

Lixun Peng's picture

Lixun Peng

Staff Database Engineer, Alibaba Cloud

Biography:

I work as a Staff Database Engineer for Alibaba Cloud, am a Senior Developer for the MariaDB Foundation, and have been an Oracle ACE for MySQL since 2013. I'm also Vice-President of the All China MySQL User Group (ACMUG), and have contributed numerous features and bugfixes to the MySQL/MariaDB community such as multi-source replication, thread memory monitoring, Flashback, etc. I'm also a co-translator of the Chinese version of the High Performance MySQL (3rd) and MariaDB Knowledge Base.

Share this talk