The biggest problem I have with my site is the 4 backup periods throughout the day where load will inevitably go above 50.
I am using nice and ionice to try and reduce the impact but to only limited success.
As I immediately copy my backup to an S3 bucket as soon as its completed followed by a deletion of the files, I'm wondering if I can create a memory based disk?
I usually have 25GB free memory (I over specced) and my uncompressed db is 17GB and my compressed is 6GB. I use xtrabackup stream and compress.
If the stream was to memory and not disk I think that would take a lot of load off the system as a whole.
Does this seem viable?
EDIT 1 something like tmpfs. https://en.wikipedia.org/wiki/Tmpfs