[Cialug] Web services platform

[Dave J. Hala Jr.]

One of my beefs has always been that people say MySQL is not an
"Enterprise" class db, it doesn't scale, blah, blah, blah...

Its a bunch of Hoeey. Yes, mysql 3 and 4 don't have all the "features"
of Oracle, DB2, etc. However if you are creating your Web services, you
don't need all the feature bloat. With the exception of transactions,
there are other ways to get the same results. If you can't live without
one of those features, use MySQL 5.0

Mysql is rock solid, brutally fast and less hardware intensive than many
of the so-called "Enterprise Class DB's" In fact, for the last four
years a Mysql database has been processing 25,000 applications a month
for Energy assistance without even the slightest hiccup. Again, the
reality is often very differant than the hype.

You can always cover your butt by using a db abstraction layer. That
way, if get some developers that can't think "Outside of Corporate
Context" you can always have them cough up a billion dollars and switch
to MSSQL, Oracle or DB2.

My point is, define your needs, then try it for yourself -and remember,
we always think we need more "features" than we actually do.


On Mon, 2005-11-28 at 20:37, Tony Bibbs wrote:
> Let me be one of the first to say don't count MySQL out.  C'mon, it 
> finally has views, stored procedures and triggers...oh my.
> 
> Also from my stand point if you like GUI clients MySQL Admin and MySQL 
> Query Browser is hard to beat.  But, as I'm sure the Postgres fanatics 
> will say, they've had that for years.
> 
> --Tony
> 
> Josh More wrote:
> > 
> > I recommend SUSE Enterprise Linux with either Enterprise DB or Oracle.
> >  
> > SUSE Enterprise is backed by Novell both financially and for support.
> > Having needed to compare both Novell and Red Hat support, I can tell you
> > that Novell wins hands down.  Additionally, having taken both the Red Hat
> > and the Novell certifications, they are technically comparable.
> >  
> > For the database, I feel that Postgresql wins hands-down over mysql
> > due to the feature set.  Enterprise DB is just postgresql with support.
> > The company has not, however, been around that long.  Depending on
> > your need, you may want to consider going with Oracle's new "free"
> > database.  It is full Oracle and not crippled in function.  It is, however,
> > crippled in scalability.  However, for PHP+Apache, it should do just fine.
> > (Free as in beer, not speech)
> >  
> > Lastly, I would caution against Sun.  I have no issues with their 
> > technology.
> > However, from a business perspective, I personally feel that they are
> > ripe for acquisition in the next few years. Hence, I would not bet my 
> > company's
> > future direction on them.
> >  
> >  
> > 
> > 
> > 
> > -- 
> > -Josh More, RHCE, CISSP, NCLP
> > morej at alliancetechnologies.net
> > 515-245-7701
> > 
> >  >>>jcbailey at code0.net 11/28/05 5:39 pm >>>
> > I'm currently working on a PHP+Apache2+SomeDB project at the company I work
> > for. We're primarily a Windows shop, but Unix could make it also. The
> > biggest issue is support for whatever platform is chosen. Personally, my
> > experience is with Debian/Ubuntu, but as far as I know, both don't have
> > major commercial backers (yes, I know Ubuntu has one, but how long have they
> > been around)?
> > 
> > I'm pretty much looking for everyones opinions on what experiences they have
> > had with the following *nix/DBs. I'm leaning to Solaris 10/Postgres, but
> > that is new ground for me. What does everyone think about this? Best support
> > cost vs support offered is important also..
> > 
> > * Windows 2000/2003
> > * RHEL
> > * SUSE Enterprise Linux
> > * Solaris 10
> > 
> > * PostgreSQL
> > * MS-SQL
> > * MySQL
> > 
> > 
> > Jon
> > 
> > 
> > 
> > Cialug mailing list
> > Cialug at cialug.org
> > http://cialug.org/mailman/listinfo/cialug
> > 
> > 
> > ------------------------------------------------------------------------
> > 
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > http://cialug.org/mailman/listinfo/cialug
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606