locking bayes?

[Randal, Phil]

Why not go for the simple and obvious solution:

stop MailScanner
snapshot
restart MailScanner

Cheers,

Phil
--
Phil Randal
Network Engineer
Herefordshire Council
Hereford, UK  

> -----Original Message-----
> From: mailscanner-bounces at lists.mailscanner.info 
> [mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf 
> Of Greg Matthews
> Sent: 21 May 2007 10:56
> To: MailScanner discussion
> Subject: locking bayes?
> 
> I have developed a shell script that takes uses LVM snapshots 
> to backup 
> volumes on a mail server. I am able to get a read-lock on the MySQL 
> MailWatch table and was wondering if I could do the same with 
> the bayes 
> database to ensure it is consistent.
> 
> At the moment, I am relying on the robustness of BerkeleyDB 
> to be able 
> to recover from a possibly inconsistent state. This is not ideal.
> 
> The snapshot process is very quick so the lock could be 
> released almost 
> immediately.
> 
> GREG
> -- 
> Greg Matthews           01491 692445
> Head of UNIX/Linux, iTSS Wallingford
> 
> -- 
> This message (and any attachments) is for the recipient only. NERC
> is subject to the Freedom of Information Act 2000 and the contents
> of this email and any reply you make may be disclosed by NERC unless
> it is exempt from release under the Act. Any material supplied to
> NERC may be stored in an electronic records management system.
> 
> -- 
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
> 
> Before posting, read http://wiki.mailscanner.info/posting
> 
> Support MailScanner development - buy the book off the website! 
>