Is it possible to get ibd files until bin log file name in run time using percona innobackup.

Asked by Mannoj Kumar on 2012-10-21

 I'm looking for an option in percona innobackup, if I can specify the ibd files to be backed up until binlog file name in run time. Like when I do innobackup first full shot hotbackup and correspondingly when I issue "flush logs;" It should get the ibd files only until that file. Sounds lame. But trying to figure a quick option for slave build and not to wait for further new DMLs.

Thanks again for such an awesome tool !!

Question information

Language:
English Edit question
Status:
Solved
For:
Percona XtraBackup moved to https://jira.percona.com/projects/PXB Edit question
Assignee:
No assignee Edit question
Solved by:
Alexey Kopytov
Solved:
2012-10-22
Last query:
2012-10-22
Last reply:
2012-10-22
Alexey Kopytov (akopytov) said : #1

I'm not sure I understand the question. What does "the ibd files only until that file" mean. I.e. what is "that file" specifically, and what is the value used to figure out which ibd files are "until"?

Mannoj Kumar (mannoj87) said : #2

Sorry for not being clearer.. I mean.. "that file" -> refers to after "flush logs ;" it generates new binary log file. Say example new one is mysql-bin0012 and I need the innobackupex to take data files in the form of .ibd files until mysql-bin0011 in run time. Would there be a pointer in master .ibd files and mysql-binlog files as a point of which the backup can be taken. The reason why I need this is.? If database is having regular updates .. say 30TPS on a table, innobackupex scans the log upto the latest checkpoint and scans for longer duration. If there is a way to tell innobackupex to take ibd files and latest changes of the data until "mysql-bin0011" a binlog file once the backup is taken until that point(mysql-bin0011) and I can build the slave for it and apply latest binlog mysql-0012 and start slave from the latest checkpoint, by this way initial dump can be quicker. I know other options to get binary logs to be applied in innobackup itself. But this is to get initial dump out and not to record latest changes as it drags the backup to generate longer.. A thought.. not sure how far this can be implemented. Are you getting my approach Alexey?

Best Alexey Kopytov (akopytov) said : #3

I don't think it's possible. If I understand correctly, I want to take a snapshot of InnoDB data corresponding to a specific point in time in the past. Which is of course impossible. We can only read what's already on disk.

Mannoj Kumar (mannoj87) said : #4

Thanks Alexey Kopytov, that solved my question.