locking bayes?
Randal, Phil
prandal at herefordshire.gov.uk
Mon May 21 11:05:37 IST 2007
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!
>
More information about the MailScanner
mailing list