undefined | Better HN

0 pointsjoshstrange7y ago0 comments

Awesome! I really hope I didn't come across as attacking you/your post, I found it really useful. I just wanted to remind people that the DB wouldn't really be covered by this (except in the case you mentioned where you are dumping the data).

I am definitively looking at this through the lens of where I work where a mysqldump (or equivalent) could take days to complete in full (DB is nearing 2TB in size now). For a number of projects a mysqldump might only take seconds or minutes and would be a perfect candidate for this backup scheme.

0 comments

2 comments · 2 top-level

jakejarvis7y ago

Not at all! I'm really glad you mentioned it, since I wrote this in the mindset of small to medium VPSes used for personal projects and I'll make that more clear in the intro. Backups (like everything else, unfortunately) definitely get exponentially more difficult the more successful you become.

SkyLinx7y ago

The tool I mentioned, xtrabackup, is orders of magnitude faster than mysqldump for both backups an restores. Check it out

j / k navigate · click thread line to collapse