Mysql to Oracle as close to real-time as possible.
I was needing to implement mysql in a project, but one of the requirements is that i need to be able to push/pull the data in as close to real-time as possible to an Oracle db.
I noticed that an arcsight snort agent connects to mysql, and sends alerts pretty close to real-time (i haven't timed them or anything) to arcsight. It's a large java process that connects to mysql via jdbc i believe, and sends alerts via some kind of syslog.
Regardless, is the jdbc process just 'listening' and the mysql db is pushing data to it, or is the jdbc process running queries constantly to see if there is new data?
I would like to know if anyone has any kind of 'real-time' replication going to some other database other than mysql (that is as close to free as possible), written in whatever (preferably perl) that will run on linux/solaris.
I noticed some talk about using DBD::Multiplex to do it, but i am not sure what kind of development feat it would take to do something like that.
Dan
Subject
Views
Written By
Posted
Mysql to Oracle as close to real-time as possible.
4220
July 20, 2006 07:39AM
2370
November 27, 2006 01:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.