Back-up Question
12 Replies
Edit: There's a guide in the Linode Library now!
Yes, the backup snapshot has everything. Note that the database files it backs up (not mysqldump'd files, but the actual things in /var/lib/mysql or whatnot) will be in an inconsistent state, so it's a good idea to cron up a mysqldump before the daily backup and/or use binlogs.
(More than once, I have restored a backup to another, empty Linode, pushed the Boot button, and Everything Worked.
For all you Turkey eaters, have a good holiday!
@hoopycat:
Yes, the backup snapshot has everything. Note that the database files it backs up (not mysqldump'd files, but the actual things in /var/lib/mysql or whatnot) will be in an inconsistent state, so it's a good idea to cron up a mysqldump before the daily backup and/or use binlogs.
Just a quick note on this: for best results, a mysqldump should share-lock all databases while it runs. This will cause a short outage on your application. The best practice is to replicate to a second server and make your backup dumps there.
@BarkerJr:
@hoopycat:Yes, the backup snapshot has everything. Note that the database files it backs up (not mysqldump'd files, but the actual things in /var/lib/mysql or whatnot) will be in an inconsistent state, so it's a good idea to cron up a mysqldump before the daily backup and/or use binlogs.
Just a quick note on this: for best results, a mysqldump should share-lock all databases while it runs. This will cause a short outage on your application. The best practice is to replicate to a second server and make your backup dumps there.
MySQL replication has something of a reputation for being tricky to set up, and unreliable (although I've not used it myself)… For most people, scheduling backups during an off-peak period with a maintenance notice on the site is sufficient . Heck, if your database dumps only take a few seconds, you might not even need the maintenance notice, since users might not even notice the delay.
@Linodapalooza:
Thanks Stan– hey, why are you working today?
Like Hoopycat said, someone had to prepare the turkeys
1. Shut down my linode.
2. Delete the disk I want restored.
3. Create a new disk of the same size and name. Is this step necessary?
4. Restore to the new disk.
or
1. Shut down my linode.
2. Delete the disk I want restored.
3. Restore and the new disk will be created automatically for me with the same name?
Thanks,
doug
doug
@carol:
if i am wanting to do apt-get upgrade, should i wait for the backup post processing to finish? or is it safe to proceed before post processing has finished?
You're safe. By the time it started copying data to the backup server, it already had a consistent snapshot of your stuff. Any changes made after it takes that snapshot won't be backed up.
@hoopycat:
@carol:if i am wanting to do apt-get upgrade, should i wait for the backup post processing to finish? or is it safe to proceed before post processing has finished?
You're safe. By the time it started copying data to the backup server, it already had a consistent snapshot of your stuff. Any changes made after it takes that snapshot won't be backed up.