[Exim] Re: Multiple Database Question

Góra strony
Delete this message
Reply to this message
Autor: Kelley Reynolds
Data:  
Dla: List - Exim-users
Temat: [Exim] Re: Multiple Database Question
--- Original Message ---
From: "Odhiambo G. Washington" <wash@???>
Sent: Sat, 13 Dec 2003 19:50:15 +0300
To: List - Exim-users <exim-users@???>
Subject: Re: [Exim] Multiple database question

> --
> * Wakko Warner <wakko@???> [20031213 17:22]: wrote:
> > > IIRC exim never writes to databases (I'm not counting the retry,
> > > callout and similar hints dbs, which you wouldn't put on a remote
> > > db server).
> >
> > This is incorrect, I have exim setup to write to databases through ACLs.
>
> You run the _most_ elegant SQL-based exim setup ;-)
>
> We definately need to follow on your fottsteps.


I am currently keeping various statistics on domain/host behavior for a variety of statistical analyses. On the fly analysis of recent history to determine spam/ham is the current focus (exim configure is >110k currenty). It's extremely effective, but database intensive. Most of it, naturally, is reading, but results are logged for future SELECT's, and I'd like to be able to write to the master and read from the slaves to lighten the load (currently it can push 25k messages a day with about .04 load on a p3-800), but I want it to scale without having to use Oracle or a proxy (which I'm not sure would really work well anyway), and since there can be multiple databases, I was hoping that there was an easy way to indicate to which database one would be reading/writing.

Looks like patch time, since not many other people have done it. :)

Kelley Reynolds
President
Inside Systems, Inc.