Re: postfix + dspam + mysql + (imap & pop) for virtual domains and relaying

[Seth Mattinen <sethm@rollernet.us>]

Roberto C. Sanchez wrote:
> On Thu, Oct 12, 2006 at 04:22:21PM -0600, David Bishop wrote:
> > 5) mysql as the database to hold the aliases, uids, usernames, and
> > passwords (of course?).  We're looking for this to scale, and nothing
> > says scalability and 'enterpriseness' like throwing stuff in a database.
> I know that I have been "flamed" in the past for my insistence that
> people stay away from MySQL.  So, here I go again: please don't use
> MySQL.  I know that they have gotten better of late, but their new
> features are just that: new.  There are superior free choices of
> databases out there.  I know some folks prefer Firebird, though I cannot
> say anything about it one way or the other as I am not familiar with it.
> However, I would highly recommend PostgreSQL.  Escpecially if you are
> looking for great scalability, I believe PostrgeSQL is the best you can
> get without shelling out $$$$ for DB2 or Oracle.

I'll just chime in here really quick - I use MySQL because it had native 
replication. The replication solution for postgres felt kind of hackish 
to me when I looked at it, and I felt more comfortable with something 
that didn't look like an afterthought. (With odd warnings/procedures for 
upgrades.) That said, I haven't had a problem with MySQL. I'm sure 
postgres is great and all, but I need to do stuff like hardware load 
balancing across multiple slaves.

Of course this may have changed since I first looked at it, but that's 
why I went down the MySQL path years ago.

--
Seth Mattinen		sethm@rollernet.us
Roller Network LLC