Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mysql backup quesiton

 On Thu, Jan 03, 2008 at 12:15:06PM -0500, Stephen Adler wrote: 
> My application is mantis, the bug tracking software. I need to make sure 
> that on a 24 hr interval, some kind of snap shot is made of the 
> database, through any backup mechanism out there, so that if the 
> database get corrupted, I loose at most 24 hours of data. I like the 
> idea of database replication. The replicated database will only be 
> accessed in case the master database get corrupted some how. Should I be 
> thinking about using postgressql instead? 

It seems that you are not running a production-critical, 
money-making service. I don't think you'd have any problems 
declaring 400-500 your maintenance window and shutting down 
the database, running mysqldump, gzipping the output and 
rsyncing it to two or three places. 

Sometimes the simple solutions are best. 

Every time you give up a right, the terrorists win. 
Tyranny is something that creeps up on you. is hereby incorporated by reference. 

This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. 

Discuss mailing list 
[hidden email]

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /