Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Dan F. <da...@ha...>]

Dave Strickler wrote:
> Two followup questions:
> 1. What table format do you use? MyISAM or InnoDB ?
>   
We use MyISAM and i believe it has become a pretty good table format.. 
Eg. our logservers each handle just below 2 gigs of data a day in one 
table and we never get messed up tables or other problems.

> 2. Do you run any sort of maintenance on the SQLGrey tables?
>
>   

Nope.. The only maintenance done, is the build-in cleanup routines in 
SQLGrey (cleaning of old entries and such).
We also run postfix-transports and userlists, and a 
spam/virus-quarantine system for all accounts on the same MySQL that 
runs SQLGrey on each box and MySQL has never let me down.

Its lovely to have a system that just hums away in the corner ;)

The only bad experience i have with MySQL is related to things like 
poweroutages or eg. a kernel-panic or the likes. That can mess up the 
table a bit, but MySQL comes with a nice little tool called myisamchk 
that usually repairs that without problems. And in my case, we started 
clustering our SQL's for the mailsystem using MySQL replication, after i 
added SQL-clustering support to SQLGrey. So should 1 database or table 
be lost, i can simply replicate it from another server without loosing 1 
single record.