How to do safety mirroring innodb table on mysql?
Plan A:  Speed up the Summary by building and maintaining a Summary Table:  http://mysql.rjweb.org/doc.php/summarytables .  In particular, this is likely to segregate the summary select, which will now touch only the summary table, from the updates.  And it will
Plan B:  Use replication on the same server.  Be sure to have a different &quot;Port&quot; (such as 3307) for that Replica.  Direct summary requests to that port.  Continue to direct writes to the Primary (your current instance).
Plan C:  If the &quot;update&quot; is just a &quot;Likes&quot; or &quot;Visits&quot; counter, then do the following to avoid some of the interference.  Move that column to a separate table.  The two tables would have the same PRIMARY KEY for ease of JOINing.  The update will avoid interfering with any selects that don't need also need to counter.
Plan D:  Plans A,B,C are independent; do a combination of them.
The repeated copying of the table will (I predict) be poor for both maintenance and performance.