Backups - again
However from what I've read, this isn't suitable for MySQL databases using InnoDB tables as MySQL will cache stuff in RAM and therefore won't write the data via rsync.
My question is how are other Linode users who use InnoDB getting around this issue?
This isn't a complaint but will Linode offer backups in the same vein as their competitors? I've moved here from Slicehost since they erased the firewalls on 3 of my 4 slices due to their error, but the one thing that really made them stand-out is their backup feature.
11 Replies
@MrNod:
My question is how are other Linode users who use InnoDB getting around this issue?
Not a perfect solution, but
@CybrMatt:
The most trivial thing to do is simply mysqldump the databases somewhere on disk and include that output in your tar/rsync backup job of the filesystem.
That's definitely the simplest, and if you can't stand the downtime, you can replicate to a remote machine over SSH (or even a second instance on the same machine) and then mysqldump off of that for your snapshot.
Caker - you've made me a very happy bunny
Cheers
@Xan:
@CybrMatt:The most trivial thing to do is simply mysqldump the databases somewhere on disk and include that output in your tar/rsync backup job of the filesystem.
That's definitely the simplest, and if you can't stand the downtime, you can replicate to a remote machine over SSH (or even a second instance on the same machine) and then mysqldump off of that for your snapshot.
You don't always need replication in order to avoid downtime. If you have InnoDB tables, "mysqldump –single-transaction" will give you a perfectly consistent snapshot of your live DB, without hanging inserts or updates in the meantime. But only if your tables are InnoDB.
@caker:
Backups are coming. We're actively working on this. Stay tuned!
:) -Chris
Whatcha got in the works? Any estimated time table?
…anyway, this is definitely exciting.
If it's coming soon enough I'm thinking of not going through the whole Amazon S3 thing (or whatever I'd end up doing) and instead just make manual backups of most important directories myself and send them to my localhost until the Linode backups feature hits.
Oh and btw, Linode was awsome for me so far! Thanks!