Re: Free ware databases: which are worth the money?

Yahoo runs on MySQL using a mix of MyISAM and InnoDB table types along with heavy use of replication to multiple slaves.

The MySQL InnoDB table type supports transations and versioning, (Oracle-style consistent non-locking reads).

See http://www.mysql.com/doc/I/n/InnoDB_overview.html

And http://jeremy.zawodny.com/mysql/managing-mysql-replication.html (there are more presentations in that directory)

PostgreSQL is also worth trying, especially if you need stored procedures (MySQL doesn't have them yet).

Tim.

On Fri, Aug 02, 2002 at 02:33:29AM -0800, Mark Teehan wrote:
> Hi,
> we are investigating some freeware databases for deployment on systems that
> dont justify the cost of an oracle license, on linux. What databases out
> these can cope with a OLTP load, all transaction based, with some
> reporting? Uncomplicated databases, with mid size volumes of transactions
> (say low millions) and some reporting queries? I guess reliability is the
> primary concern, if something can be built as solidly as an oracle
> instance, with whatever OS protection this would need, then its a starting
> point for making a non oracle freeware enterprise database.
> Anyone have any suggestions on what I should download first?
>
> Thanks!
> Mark Teehan
> Singapore
> ---------------------------- ERG Group --------------------------
> The contents of this email and any attachments are confidential
> and may only be read by the intended recipient.
> -----------------------------------------------------------------
>
> ---------------------------- ERG Group --------------------------
> The contents of this email and any attachments are confidential
> and may only be read by the intended recipient.
> -----------------------------------------------------------------
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Teehan
> INET: mteehan_at_erggroup.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
-- 
Author: Tim Bunce
  INET: Tim.Bunce_at_pobox.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).