Not the answer you need?
Register and ask your own question!

some puzzle on understanding xtrabackup

seagenseagen ContributorInactive User Role Beginner
Share the following questions with all guys on using Xtrabackup toolkit:

1. blocking
When I use innobackupex to take the backup on master or on slave with the --slave-info option, the whole procedure of backup NEED
locking all tables until copying all .ibd files are finished with FRM files and similar files.
So it is fact that innobackupex is NOT really non-blocking tool,right?
I know the --no-lock option is also supported, but I DO CARE about the binlog position for setting up replication.

2. non-blocking
xtrabackup binary could implement the non-blocking backup, but satisfy two requirements: #1. no DDL running #2. only including InnoDB tables.
Running the --prepare option can create the new file named by xtrabackup_binlog_pos_innodb. We are able to get the binlog file and posistion from the file. That is cool for setting up replication,as well :)
right now my question is starting up. If we take backup of the online DB, it means update is still be there - ibd files are still updated. How do we determine when the end of one ibd file is?

----
Regards and Thanks,
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.