Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Dave S. <dst...@ma...>]

Very slick. We will definitely test this out on our end.
=20
Are you using MyISAM or InnoDB for your table format? MyISAM seems too =
limited...
=20
Dave Strickler
MailWise LLC
617-933-5810 (direct)
www.mailwise.com ( http://www.mailwise.com/ )
"Intelligent E-mail Protection"





>>> Dan Faerch <da...@ha...> 3:23 PM Tuesday, May 30, 2006 >>>
Dave Strickler wrote:
> Two followup questions:
> 1. What table format do you use? MyISAM or InnoDB ?
>  =20
We use MyISAM and i believe it has become a pretty good table format..=20
Eg. our logservers each handle just below 2 gigs of data a day in one=20
table and we never get messed up tables or other problems.

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

Nope.. The only maintenance done, is the build-in cleanup routines in=20
SQLGrey (cleaning of old entries and such).
We also run postfix-transports and userlists, and a=20
spam/virus-quarantine system for all accounts on the same MySQL that=20
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=20
poweroutages or eg. a kernel-panic or the likes. That can mess up the=20
table a bit, but MySQL comes with a nice little tool called myisamchk=20
that usually repairs that without problems. And in my case, we started=20
clustering our SQL's for the mailsystem using MySQL replication, after =
i=20
added SQL-clustering support to SQLGrey. So should 1 database or table=20
be lost, i can simply replicate it from another server without loosing =
1=20
single record.



-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as ( http://sel.as/ )-us.falkag.net/sel?cmd=3Dlnk&kid=3D107521&b=
id=3D248729&dat=3D121642
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...=20
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

----------------------------
This message has been certified virus-free by MailWise Filter - The real-time, intelligent, e-mail firewall used to scan inbound and outbound messages for SPAM, Viruses and Content.  For more info visit: http://www.mailwise.com