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 are required
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]