Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Usage of mySQL in enterprise environments
We're a big user of MySQL here and I wouldn't compare it to MS Access any
more than I would compare Oracle to MS Access. MySQL has made great strides
in the last couple of years and once InnoDB matures a bit it'll add a lot of
features that MySQL currently lacks, like transaction processing.
Postgres is definitely more "Oracle-like" and we looked into it as a possible replacement for MySQL but stuck with MySQL for performance reasons (although some of the performance problems we had with Postgres might have been self-inflicted -- I won't go into details).
BTW, hot backups and roll-forward are, indeed, available with MySQL. We're also using MySQL's replication feature with great success.
I wouldn't be surprised if, in a couple of years, we drop Oracle completely and go 100% MySQL. Oracle's ridiculous pricing schemes and general lack of response to customers (or at least us) have frustrated us no end. Once MySQL/InnoDB matures a bit we'll have no reason to waste money on Oracle.
--Walt Weaver
Bozeman, Montana
> -----Original Message-----
> From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> Sent: Tuesday, March 18, 2003 7:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Usage of mySQL in enterprise environments
>
>
> Hemant,
>
> MySql is akin to M$ Access. Use it accordingly for
> things that can be lost
> forever without damage. Seriously in a MySql database each
> schema is a
> subdirectory of where they put the database main directory.
> That point is not a
> negotiable item either, it's in /var/mysql (if memory
> serves). Then each table
> and index become separate files within the subdirectory.
> Backup is COLD only
> and while Immodb does handle transactional data there is no
> such thing as roll
> forward and the table(s) have to be specifically configured
> to use it. Also it
> is NOT free but close thereto ($549 per server at last look see).
>
> In my opinion a better choice is PostGreSql
> (www.postgresql.org). It's a
> totally free download, comes in RPM's which makes install so
> much easier, can do
> a "hot backup" or more likely an export, is totally
> transactional, the database
> directory is an environment variable so you can put it
> anywhere. An it's speed
> is comparable to MySql, but it does stored
> functions/procedures, etc... Much
> more like Oracle, but not exactly the same. For a zero cost
> database I find it
> very nice. Heck it even comes with a TOAD like (close, but
> way no cookie) query
> tool!!
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: Hemant K Chitale <hkchital_at_singnet.com.sg>
> Date: 3/18/2003 3:03 AM
>
>
> I've been asked to consider whether we can use
> mySQL for non-critical, but probably, enterprise-wide
> databases [e.g. information stores].
>
> How good is the feedback on mySQL handling Queries,
> Transactions, ConcurrentUserCounts and DatabaseSize ?
>
> Hemant K Chitale
> http://hkchital.tripod.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hemant K Chitale
> INET: hkchital_at_singnet.com.sg
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: wweaver_at_rightnow.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Mar 18 2003 - 10:23:51 CST