I’m trying to migrate from mysqldump to an alternative that allows hot backups with non-blocking tables. I have studied about mydumper (I think that blocks tables during the process) and XtraBackup.
With XtraBackup: I have executed this command
innobackupex --user=root --password=root_password --databases=“banksdb” /root
banksdb it’s a small database (110MB) and the process spend a lot of time ( I have seen that is copying ibdata1 file with 24GB!). Is it normal?
After that, I’m going to execute
innobackupex --user=root --password=root_password --databases=“banksdb” --apply-log /root
Is correct my process? Where is the mistake? Any ideas?
I have read about XtraBackup and I don’t clear if I should to use --databases or --include to make a fragmental backup.
With mydumper: I have executed the command and I have not detect blocks in the activity (Only checked reads, without writers) … Any ideas?
Thanks in advance and my apologize if this post is some obvious.