MySQL Performance

[Thomas Eisenbarth]

Hi there,

On Tue, 02 Aug 2005 12:43:40 -0400
Troy Settle <troy at psknet.com> wrote:

> that time, I hope to have a dedicated MySQL server up and running,
> though I'm not sure I'll want to run my mail server off a remote
> database.

Well, you definitively don't want to run a webserver, a mta and the
database on a host having such a load. ;-)
I always try to avoid situation where a service
depends on a single-point-of-failure-service like mysql.
Don't understand me wrong, mysql is stable for most of the time, but if
you want to offer reliable high availability e-mail you at least need a
mysql-cluster. (and please remember that maybe ldap fits your meets
much better ;-))
The next question is if you have mailbox/account-
checking on your mta at smtp-session to (try to) avoid spam and if you
want to have a secondary mail exchange. (which then needs access to you
mysql oder ldap-service)
As you can see, it's not a simple question.
But as a good friend of mine always says: "If it would be easy, someone
else would do it" ;-)

Greetings from Germany

-- 
Thomas Eisenbarth, Donau-Ries Media-Consulting, DoMeCon
web:   http://www.domecon.de   email:   info at domecon.de
tel/fax:  0700 03 66 32 66