Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle to MySQL integration

Re: Oracle to MySQL integration

From: Mark <simmons_mark_at_yahoo.com>
Date: 10 Mar 2004 12:09:54 -0800
Message-ID: <5366fb41.0403101209.1684aafc@posting.google.com>


I was thinking along the lines of a product like Golden Gate that reads the Oracle logs and applies them to MySQL.

We have a requirement to support about 200 transactions/second into the denormalized model. We can easily do this with a pure Oracle model, but the hardware/software licensing is very expensive.

Any other input would appreciated.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

Mark Bole <makbo_at_pacbell.net> wrote in message news:<AZ92c.20481$g45.1013_at_newssvr29.news.prodigy.com>...
> Mark wrote:
>
> > Our company is contemplating using MySQL for denormalized R/O WEB
> > transactions that don't require read consistency.
> >
> > Does anyone have any recommendations on the best method to move data
> > from a normalized Oracle database into a de-normalized MySQL database?
> >
> > Thanks.
> >
> > Mark
>
> Use a tool such as JDBC, Perl DBI, or ODBC. Make one connection to your
> Oracle source database and another to your MySQL target database.
>
> For each de-normalized relation, "insert into target select [using
> de-normalized relation] from source".
>
> --Mark Bole
Received on Wed Mar 10 2004 - 14:09:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US