I am looking for a better way of doing this…
Right now I have a 10TB DB in two physically geographical locations. I run nightly backups on one of the nodes that has a 50TB backup partition
I leverage the compress option on the backups and everything works fine (no issues with the backups)
The problem I ran into is with the system that the backups were NOT on had issues and needed to be rebuilt.
As the non backup system does not have a /backup drive with a ton of space I copied the files to the main mysql data dir (I have a /data /logs and /tmp)
When running the decompress option I run out of drive space as the compressed files and the datafiles are on the same mount point
Does an option exist for after the file is decompressed delete the compressed file? (for each thread as I am using about 30 threads)