RE: Anyone using "Enterprise implementation"?

["Hutchinson, Andrew" <andrew.hutchinson () Vanderbilt Edu>]

That used to be a weakness, but not any longer if you use the new InnoDB
engine.  It has full transaction support.  However, if I remember
correctly, performance tests of MySQL show that its performance
advantage over many other db's evaporates when transactions are used.  

IMHO, the main reason for using MySQL is that it can be mind-bendingly
fast if you have it set up *without* transaction support.  If you need
transaction support, I would choose PostgreSQL - it's free, open, and
has support not only for transactions but also for triggers, stored
procedures, and all of the other nifty little things that make a
full-featured rdbms handy.

Again, this is my OPINION, not gospel.  I don't want a database holy war
here - it's a Snort list, after all...

Andrew Hutchinson - Network Security
Vanderbilt University Medical Center
(615) 936-2856


> -----Original Message-----
> From: Tom Van Overbeke [mailto:tvanoverbeke () ccncsi net] 
> Sent: Wednesday, August 27, 2003 9:25 AM
> To: Snort-Users (E-mail)
> Subject: RE: [Snort-users] Anyone using "Enterprise implementation"?
>
>
> ***********************
> Your mail has been scanned by InterScan MSS. - en dat is maar goed ook
> ***********************
>
>
> Wasn't one of the weaknesses of mysql that you can't do a 
> rollback of a
> transaction ? once you change a record, there's no way to go back.
>
> other db's such as a oracle, require a commit statement before data is
> actually changed. as long as you don't do a commit, it's only 
> in your sql
> session that you see the changes in the database.
>
>
> Tom.
>
>
> > -----Original Message-----
> > From: snort-users-admin () lists sourceforge net
> > [mailto:snort-users-admin () lists sourceforge net]On Behalf Of Rich
> > Adamson
> > Sent: 27 August 2003 15:31
> > To: snort-users () lists sourceforge net
> > Subject: Re: [Snort-users] Anyone using "Enterprise implementation"?
> >
> >
> >
> > > > I wouldn't recommend using mysql in an 'Enterprise'
> > environment for anything
> > > > that matters to you.
> > >
> > > By what reasons would you make such a comment?  Could you clarify
> > > this statement?
> >
> > FWIW, I've worked with multiple companies (not small ones)
> > that use MySql
> > for lots of different apps (not just snort), and they are
> > happy with it.
> > Obviously, it doesn't have all the features that some
> > commercial databases
> > include, but when properly configured & tuned, can handle
> > very large databases.
> >
> > I'd suggest the majority of the negative comments towards
> > MySql on this
> > list are either sourced by individuals that don't have a 
> clue, or, by
> > professional database administrators that know exactly where
> > the weaknesses
> > are (and how to deal with those in some reasonable/acceptable way).
> >
> > Given individual investments in training, your milage may vary.
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Snort-users mailing list
> > Snort-users () lists sourceforge net
> > Go to this URL to change user options or unsubscribe:
> > https://lists.sourceforge.net/lists/listinfo/snort-users
> > Snort-users list archive:
> > http://www.geocrawler.com/redir-sf.php3?list=snort-users
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Snort-users mailing list
> Snort-users () lists sourceforge net
> Go to this URL to change user options or unsubscribe:
> https://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users