Running v1.5.1-xtrabackup on Debian Squeeze 64bit with standard debian mysql-server-5.1 (5.1.63-0+squeeze1) in a 2 server master/slave setup. The server(s) has one database (besides mysql), all InnoDB tables totaling about 225GB.
We need to migrate the master database to new hardware, but cannot shutdown for the amount of time it takes to just copy the 225GB data from one server to another.
Am i right in the following?
1). Using innobackupex i can backup the entire mysql install on the live server directly to the mysql datadir directory on the new server (with mysql off on the new server) - all without shutting down the live server and with no locking of the live server tables.
2). Then stop access to the live server and run --apply-log on the backup, which will apply the binary log file changes since the backup in step 1.
3). Then stop mysql on live server, change IP addresses over, set permissions etc, and start mysql on the new server.
All --copy-back does is simply copy the data from the backup dir to the datadir on the server. It does nothing else?
Would the best way to get the data from the live server to the new server during the innobackupex process be NFS?
Sorry for asking lots of questions on one go… but thanks in advance for any answers!