I’m implementing XtraBackup now, and I have two slaves that I’d like to back up. Our first night encountered problems. So, I wanted to ask for some advice about how to manage this.
The problem is that apparently our slaves aren’t powerful enough to process replication data efficiently enough for the slave_open_temp_tables to become 0. I could try setting the timeout period longer, but I have no idea what that period should be other than to do a little trial and error.
I had another thought, though. It looks to me from the output of the failed backup that XtraBackup waits until it is ready to backup the MyISAM portion of the server before it cares about shutting down slave I/O. If that is the case and if all of my own tables are in InnoDB, then does it really matter if I use the --safe-slave-backup option? The only MyISAM in my server is the MySQL data dictionary.
Thanks in advance!
Dave