RE: Usage of mySQL in enterprise environments
Title: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > 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 <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [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.net > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [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). >
RE: Usage of mySQL in enterprise environments
Speaking of the amphibians, there is also a TOAD-like tool for MySQL. It's called "tora" (http://www.globecom.se/tora) and it's free on Linux. -Original Message- Sent: Tuesday, March 18, 2003 9:14 AM To: Multiple recipients of list ORACLE-L 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [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.net -- Author: INET: [EMAIL PROTECTED] 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: [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.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [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).
RE: Usage of mySQL in enterprise environments
Hemant - We have been using mySQL for some applications. It seems to work well for some situations, especially mostly queries. It might work well for your information stores. Can you start on mySQL but plan on switching to Oracle as a contingency. Since mySQL is free, you wouldn't be out a lot of licensing fees. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 18, 2003 5:04 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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).
