OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Subject: Re: SQL Mail Delivery Options
From: Matthew Hawkins (matthewtopic.com.au)
Date: Mon Apr 03 2000 - 18:00:31 CDT

On 2000-04-04 00:26:14 +0200, Brad Knowles wrote:
> Consider yourself lucky, extremely lucky.

I'll consider myself extremely lucky too, and every other MySQL user I
know of. I haven't heard a single case of MySQL losing data.

It's another one of those FFS vs. ext2 debates - sync writes versus
async. Nobody has heard of a Linux system irrevocably losing data due
to async writes, but those against the concept (particularly because
_their_ favourite OS loses out big time in comparitave performance
benchmarks) seem to want to bad mouth it all the time.

> It has been our experience that MySQL doesn't scale, and doesn't
> provide transactional commit/rollback facilities

The MySQL manual even states WHY it doesn't do transactions, in a whole
section dedicated to the concept! RTFM! :-) It achieves the same
purpose of transactions using a different method that doesn't incur some
of the drawbacks of a transactional system.

> that Sybase has more than a few problems of it's own, but in general,
> it does tend to be quite a bit more powerful and robust than MySQL.

Well it also has many more years of development behind it. I've heard
very good things about Sybase.

Horses for courses. 

-- 
Matt