We’re trying to set up a new copy of our database on a new server, using the our nightly xtrabackup/innobackupex backup. The complicating factor is that our database is quite large: 2.6TB.
So we copy over the gzip’d tarball, and expand it to the full size. Now as I understand, the next steps are to “prepare” it and then “restore” it. It seems that the “restore” step will create another full copy of the database files, in their restored state of course. Having an additional 2.6TB of space just for this temporary step is, as you might imagine, going to be expensive.
My question is simply to sanity-check what we’re doing. Is this right? Is there some way around this?