Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This article explains how to collect MySQL load and how to replay it. My question is how to make a backup on a loaded server in a way that a recorded log will be consistent and not fail during replay because either database does not yet have some records it will try to update or records replay will try to crete already exist.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.