Re: Database for greylisting plugin.

On Fri, Dec 08, 2006 at 02:23:34PM +1100, Graham Miller wrote:
>
>mysql Pros:
>- central (or replicated) DB for server farms.

is that really needed for greylisting?

>The current greylistd C program I am using in a beta test server on one
>domain that gets lots of spam, is using the filesystem and files named after
>their IP address. This seems to be working ok so far, but I have concerns
>about the number of files that end up being cached by the OS and robbing
>server RAM.

an advantage there is simple (emergency) shell manipulations

sqlite has a facility to use in-memory tables, you will probably
want to add a capacity to dump/load data to disk. the source is
mature and in public domain, so you can include the libs in your
package.

when a mx passes you could make the record 4 bytes (ip) and an
integer (time). In any event, I have the sense your app won't
cause memory problems, but it may be simple to optionally use on
disk tables.

// George


-- 
George Georgalis, systems architect, administrator <IXOYE><