Date: Wed, 3 Jan 2001 20:56:09 -0500 From: "Dave VanAuken" <dave@hawk-systems.com> To: <freebsd-questions@FreeBSD.ORG> Subject: RE: a very dumb backup question Message-ID: <DBEIKNMKGOBGNDHAAKGNCEENCLAA.dave@hawk-systems.com> In-Reply-To: <3A53B831.4F97E83B@i-clue.de>
next in thread | previous in thread | raw e-mail | index | archive | help
do a dump of the databases to get around this... for example, we cron mysqldump and pgsqldump each morning at 3am... once complete you have an accurate 3am "snapshot" of the database, then run your backup immediately thereafter (we have it all in the same shell script). on disaster, rebuild the server from the backup and then delete the database data (which may be erronious if backed up mid session or something) and restore from the database dumps. We also have some e-commerce/critical db files that get incrementially dumped and rotated thruout the day to cover disasters between nightly backups. the brief overhead of a pg_dump for 30-60 seconds every hour is a small price to pay for recovering a few thousand dollars in transactions that would otherwise dissapear into never never land. html file changes are less of a worry since any changes uploaded to the server should be available fo reload from your development station in the event of a disaster. Dave -----Original Message----- From: owner-freebsd-questions@FreeBSD.ORG [mailto:owner-freebsd-questions@FreeBSD.ORG]On Behalf Of Christoph Sold Sent: Wednesday, January 03, 2001 6:39 PM To: Eric_Stanfield@kenokozie.com Cc: freebsd-questions@FreeBSD.ORG Subject: Re: a very dumb backup question Eric_Stanfield@kenokozie.com schrieb: > > I have a number of freebsd boxes up that I've been backing up over the wire > using samba shares and nt backup software. In my ignorance as a newbie I > didn't know if sticking a tape drive in the servers and using tar to > perform backups would catch open files. In my somewhat lesser ignorant > state as a familiar freebsd guy, I still don't know so I figured I'd ask. > Will open files (web pages, etc) be backed up to tape using tar? Yes. The problem is, you may capture them while in an inconsistent state. For this reason, databases should be powered down when backup time hits the disc. HTH -CHristoph Sold To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?DBEIKNMKGOBGNDHAAKGNCEENCLAA.dave>