From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 18:27:38 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 08C8516A41F for ; Tue, 2 Aug 2005 18:27:38 +0000 (GMT) (envelope-from te@domecon.de) Received: from tartaros.domecon.de (tartaros.domecon.de [80.237.209.74]) by mx1.FreeBSD.org (Postfix) with ESMTP id B8C0E43D49 for ; Tue, 2 Aug 2005 18:27:36 +0000 (GMT) (envelope-from te@domecon.de) Received: (qmail 75574 invoked by uid 89); 2 Aug 2005 18:27:02 -0000 Received: from 84.155.74.113 by tartaros.domecon.de (envelope-from , uid 89) with qmail-scanner-1.25 (clamdscan: 0.83/705. spamassassin: 3.0.2. Clear:RC:0(84.155.74.113):SA:0(2.2/6.0):. Processed in 4.340142 secs); 02 Aug 2005 18:27:02 -0000 X-Spam-Status: No, hits=2.2 required=6.0 X-Spam-Level: ++ X-Qmail-Scanner-Mail-From: te@domecon.de via tartaros.domecon.de X-Qmail-Scanner: 1.25 (Clear:RC:0(84.155.74.113):SA:0(2.2/6.0):. Processed in 4.340142 secs) Received: from unknown (HELO fnord) (thomas.eisenbarth@domecon.de@84.155.74.113) by tartaros.domecon.de with AES256-SHA encrypted SMTP; 2 Aug 2005 18:26:58 -0000 Date: Tue, 2 Aug 2005 20:27:28 +0200 From: Thomas Eisenbarth To: Troy Settle Message-ID: <20050802202728.07748587@fnord> In-Reply-To: <42EFA2BC.4060808@psknet.com> References: <42EF8206.5000505@psknet.com> <42EF8714.9020409@jpri.com> <42EFA2BC.4060808@psknet.com> Organization: Donau-Ries Media-Consulting DoMeCon X-Mailer: Sylpheed-Claws 1.9.11 (GTK+ 2.6.8; i386-portbld-freebsd5.4) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-isp@freebsd.org, wertejuk@mwcis.com Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 18:27:38 -0000 Hi there, On Tue, 02 Aug 2005 12:43:40 -0400 Troy Settle 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@domecon.de tel/fax: 0700 03 66 32 66