[Cialug] Web services platform

Tue Nov 29 07:57:35 CST 2005

I know.... We need very beefy hardware for the current system. I assume you use MySQL in a commercial environment, correct? If so, do you pay for any support/licensing?

Jon

________________________________

From: cialug-bounces at cialug.org on behalf of Dave J. Hala Jr.
Sent: Tue 11/29/2005 7:54 AM
To: Central Iowa Linux Users Group
Subject: RE: [Cialug] Web services platform

You've got a lot of hardware there. If you use mysql 3 or 4 You'll need
to tweak your mysql,cnf to take advantage of the ram.

On Tue, 2005-11-29 at 07:45, Bailey, Jonathan C wrote:
> I'm actually going to use it for a knowledge base. I'm using ADODB for database abstraction. We'll be running it on dual Xeons with 3GB of RAM. We'll have 1 box as primary and 1 box as a hot spare.
> 
>
> Jon
>
> ________________________________
>
> From: cialug-bounces at cialug.org on behalf of Dave J. Hala Jr.
> Sent: Tue 11/29/2005 7:37 AM
> To: Central Iowa Linux Users Group
> Subject: Re: [Cialug] Web services platform
>
>
>
> 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
>
> _______________________________________________
> 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

_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 9691 bytes
Desc: not available
Url : http://cialug.org/pipermail/cialug/attachments/20051129/dc0814a5/attachment.bin