medium10 pts · first answer countshigh-availabilityreplicationreplica-lag
Replica lag spike after a batch job
Every night a job runs one DELETE that removes 3 crore rows in a single transaction. Replicas then lag by 40 minutes. What is the best fix?
Discussion 0
Join free to post in the discussion.
Related questions
- RPO and RTODatabase Administrator
- Why add a read replicaDatabase Administrator
- Downtime allowed by 99.9%Database Administrator
- Error budget for a 30-day monthDatabase Administrator
- Replicas after a bad DROP TABLEDatabase Administrator
- The 3-2-1 backup ruleDatabase Administrator
- Spotting a single point of failureDatabase Administrator
- Active-passive vs active-activeDatabase Administrator