Re: mysql backup quesiton

["Dan Ritter-2" <user=13@nabble.blu.org>]

 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. 

http://tao.merseine.nu:81/~dsr/eula.html 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] 
http://lists.blu.org/mailman/listinfo/discuss