I am quite new to databases and so far i really like working on this “technology” hence excuse me in advance if i ask something obvius.
What i wish to achive is to replay traffic-load from one database server (live data) to another (dev) and so far what i have found out by researching is to
- get a full backup
- Captre the traffic with slow-query option (set to 0)]
- Replay the traffic with percona-playback
I have done the above and all worked flawlessly including the playback.
My problem is that due to the database scheme, alot of queries fail or just hang there because provably there are some queries missing since there is a gap between the full backup and the slow-query logging.
Is there a way to get a full backup using the xtrabackup and then to make a slow-query log where the first query of the slow-query.log is the exac query executed in real life after the fullbackup has finished.
For example, lets assume that a full nackup is taken where the state of the databse is such as that includes the modifications made by the queries:
and the slow query-log should contain:
I assume that there is some sort of timestamp-ordering of the queries executed in the database? right?