Comments on: MySQL Single Table Point-In-Time Recovery https://www.percona.com/blog/mysql-single-table-point-in-time-recovery/ Tue, 06 Aug 2019 20:50:23 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: marceloaltmannpercona https://www.percona.com/blog/mysql-single-table-point-in-time-recovery/#comment-10970938 Mon, 01 Jul 2019 16:41:52 +0000 https://www.percona.com/blog/?p=47695#comment-10970938 Hi Archit,

The fake master doesn’t need the data (restore the backup). The binlog dump thread will only need to read the binlogs to serve them to the slave.

]]> By: Archit Goel https://www.percona.com/blog/mysql-single-table-point-in-time-recovery/#comment-10970889 Wed, 12 Jun 2019 09:14:37 +0000 https://www.percona.com/blog/?p=47695#comment-10970889 Hi There,

Could you please help me to understand the difference between the normal point in time recovery method and this fake master?

My understanding by this blog:

I think fake master means, I have to restore backup on two servers.
One I have to make master, copy there all the binlogs which I took for the point-in-time recovery. Another node , I have to make as a slave, add replication_* filter for the table in my.cnf . and start replication on slave. So it will read only particular table related events from the binlogs which you copied to the master server for point-in-time recovery and run on slave. This is just my assumption.Please confirm.

And help us to understand this blog and it would be great for me if you can share/demonstrate any actual example of this recovery.

]]>