Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Ray B. <rj_...@rj...>]

Dan Faerch wrote:
> 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.
>
Hi Dan

Can I ask for spam/antivirus system you are using that uses MySQL?

Regards
Ray


> 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.
>
>
>
> -------------------------------------------------------
> 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-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users


-- 
Ray Booysen
rj_...@rj...