List:General Discussion« Previous MessageNext Message »
From:mfatene Date:June 6 2005 4:27pm
Subject:Re: mirroring oracle database
View as plain text  
resubmitted

Selon mfatene@stripped:

> Hi,
> what is tour oracle version ?
>
> such tool can be done easily if you put your oracle database in archivelog.
> Be
> carrefull to datatypes and create your mysql database with innodb storage.
>
> Beginning the game, you can use LogMiner. A simple batch can extract the redo
> SQL statements and apply them to your mysql database.
>
> This will be another Heterogeneous DataGuard architecture. Why not if you
> have
> not stored procedures, triggers, views ... in your oracle database. This will
> surprise me if you answer me "i haven't".
>
> Since it's a "test like", you can install mysql v5 which supports those
> concepts.
>
> A+
>
> Mathias
>
> Selon Edward Peschko <esp5@stripped>:
>
> > On Sun, Jun 05, 2005 at 04:41:16PM -0700, sol beach wrote:
> > > IMO, you have much more a lively imagination than realistic, in depth
> > > & technical knowlege in either MYSQL or Oracle.
> > > Current production MYSQL does NOT have stored procedures.
> >
> > Current production mysql doesn't, but current development does (5.02).
> >
> > Given that this is something that is coming online about 6 months down the
> > fly,
> > and is a direction that we are thinking about moving, and given how much
> > that such an effort would save you - and given the fact that all the data
> > in question is being backed up in an oracle database, as far as I can see,
> > the risk is minor and the rewards major.
> >
> > All it really has to do is keep data for a minor interval (say, a day).
> Then
> > it can be synced with the oracle database in a batch job.
> >
> > I say its worth a shot. If its not doable now, its perhaps doable in 6
> > months.
> > And some people agree with me apparently:
> >
> >     http://www.convert-in.com/ora2sql.htm
> >
> > which I was thinking about reverse engineering to an extent as a starting
> > point.
> >
> > Thanks for the vote of confidence btw, and the elegent, almost
> statesman-way
> > that you expressed it..
> >
> > But seriously, why the testy response? Are you affiliated in any way with
> > oracle?
> > Isn't the whole point of mysql to ultimately provide a RDBMS that can be
> used
> > instead of DB2 or Oracle anyways?
> >
> > And does anybody have helpful, real, experience along these lines that
> they'd
> > like to share rather than just opinions?
> >
> > Ed
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
>
>
>


Thread
mirroring oracle databaseEdward Peschko6 Jun
  • Re: mirroring oracle databaseMartijn Tonies6 Jun
Re: mirroring oracle databaseEdward Peschko6 Jun
  • Re: mirroring oracle databasemfatene6 Jun
Re: mirroring oracle databasemfatene6 Jun