Before explaining how you can improve the speed for performing
point-in-time recovery, let’s recall what is Point-In-Time
Recovery and how it’s usually performed.
Point-in-Time Recovery, PTR
Point-In-Time recovery is a technique of restoring your data
until a certain point (usually until an event that you would like
that has never happened).
For example, a user did a mistake and you would like to recover
your data up to that mistake to revert its effects like a drop
table or a massive delete.
The usual technique consists to restore the last backup and
replay the binary logs up to that unfortunate “event”.
So, as you might have already realized, backups and binary logs
The main spread technique to replace those binary logs event is
to use the `mysqlbinlog` command. However, depending on your
workload, this process can be quick or slow, depending on how
much data there …[Read more]