Sample Header Ad - 728x90

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