We're at the point where mysqldumps are in excess of 3 gigs, and there's not enough space on the device to gzip it at that point.
Up until now I've been dumping to the FS and using rsnapshot to synch it offsite. Now that space is becoming an issue (to put off an upgrade for a while) Im looking for a better solution.
I'd try a mysqldump over SSH to just deposit the sql file on a remote system, but I'm scared of how unresponsive the board would be while this process was running.
Is there a better way? The board is fairly busy (3 million posts, about 1,200 members online) during non-peak hours, so I've been dumping Sunday mornings to reduce the impact on the server.
Up until now I've been dumping to the FS and using rsnapshot to synch it offsite. Now that space is becoming an issue (to put off an upgrade for a while) Im looking for a better solution.
I'd try a mysqldump over SSH to just deposit the sql file on a remote system, but I'm scared of how unresponsive the board would be while this process was running.
Is there a better way? The board is fairly busy (3 million posts, about 1,200 members online) during non-peak hours, so I've been dumping Sunday mornings to reduce the impact on the server.
Comment