RE: oracle and mysql

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: <ujang.jaenudin@xxxxxxxxx>, <kjped1313@xxxxxxxxx>
  • Date: Thu, 15 Jul 2010 10:54:19 -0400

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


Other related posts: