MYISAM performs really well, but it is one of the least reliable db engines available for MySQL. It also is not ACID compliant. If you care about reliability of your MySQL install, you should be using the Innodb engine, and make sure that your tables are defaulting to Innodb. If you compare Oracle vs. MySQL (which I have extensively), you come to the realization that in cases of power failure, limited disk failures, etc., that Oracle can prevent data corruption far better than MySQL, especially myisam. Once you get your MySQL db configured for Innodb, you will still have your tables in myisam- the Maatkit package (which is excellent) has a nifty way to convert myisam tables to innodb without downtime and without having to do a mysqldump. For a one time conversion of data between Oracle and MySQL, you can look at the Oracle Migration Workbench. I think MySQL offers a similar tool. Considering Sun bought MySQL, then Oracle bought Sun, I think the future is cloudy for MySQL. Not that it will go away, just that I cannot predict how it will evolve. MySQL is really popular with the garage-type outfits that need a basic database. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ujang Jaenudin Sent: Thursday, July 15, 2010 7:24 AM To: kjped1313@xxxxxxxxx Cc: wardbe@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: oracle and mysql i'm scripting perl for the synchronization, anyway, insert performance on myisam really beat oracle even with disable logging On 7/15/10, Kellyn <kjped1313@xxxxxxxxx> wrote: > I'm on vacation but this one caught my eye while watching the miles go by. > :) > > We are in the process of replacing *part* of our OLTP system with MySQL and > just leaving the reporting repository in Oracle. This new environment will > syncronize between MySQL and Oracle on different intervals all through sql > scripts and odbc. > > We are in testing right now so I can't give you a lot of performance data, > but its been interesting simplifying some of the Oracle features to work > with MySQL and enjoying the simplicity of how MySQL just works. :) > > ~Kellyn > Sent via BlackBerry from T-Mobile > > -----Original Message----- > From: Betsy Ward <wardbe@xxxxxxxxxxx> > Sender: oracle-l-bounce@xxxxxxxxxxxxx > Date: Wed, 14 Jul 2010 15:31:04 > To: <oracle-l@xxxxxxxxxxxxx> > Reply-To: wardbe@xxxxxxxxxxx > Subject: oracle and mysql > > I saw someone just posted a question about Oracle versus MySQL, and > since I'm researching this, thought I would ask out here... > > Has anyone on this list gotten an oracle database to talk to a mysql > database before? Similar to putting a dblink in oracle from one > instance to another, can you do that with oracle > mysql? Would you > be willing to share how you did it? > > I have been digging around and found the unixODBC package, which I > installed but when trying to install the mysql-connector driver, I am > getting errors. Is there any way to get this to work outside of using > the unixODBC package? > > TIA, > Betsy > -- > //www.freelists.org/webpage/oracle-l > > > -- thanks and regards ujang jaenudin jakarta - indonesia -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l