How can I replicate transactions one by one in mysql?
0
votes
1
answer
41
views
I have one source server and one replica server. And I set source_delay 30mins, replication is gtid based, mysql version is 8.0.24
1. If I accidentally drop table A, Can I apply transactions just right before the drop transaction??
2. What is the best solution when I accidentally drop table and I want to restore minimum data loss?
I tried restore table using replica's table which have data before 30 mins. So there is no data which is delayed.
Asked by 제임스으
(1 rep)
Dec 4, 2024, 12:55 AM
Last activity: Dec 4, 2024, 10:16 PM
Last activity: Dec 4, 2024, 10:16 PM