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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
