Re: oracle and mysql
Date: Thu, 15 Jul 2010 18:24:19 +0700
Message-ID: <AANLkTimiOv34DRd-TgaWMYXvsuuw-q_kO0VAMX7Quuu__at_mail.gmail.com>
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_at_yahoo.com> 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_at_earlham.edu>
> Sender: oracle-l-bounce_at_freelists.org
> Date: Wed, 14 Jul 2010 15:31:04
> To: <oracle-l_at_freelists.org>
> Reply-To: wardbe_at_earlham.edu
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- thanks and regards ujang jaenudin jakarta - indonesia -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 15 2010 - 06:24:19 CDT