Mysql – Syinc databases theSQL to Oracle

data synchronizationmysql-5.6oracle-8i

I'm new in "databaase administration"
the problem I am facing is that I want to have an exact copy of a table, from MySQL database (website database) to oracle database (a local one).

What I've done till now

Searched for two days.

I installed MySQL connector/odbc on the 'oracle machine' and successfully connected to the remote MySQL database

Also I can execute queries from the oracle machine like:

select * from remote_table;

and it shows the expected results,

The problem here is:
Is there a way to sync these two databases (mySQL to oracle), or at least update the local one every midnight..

About the two machines

Both machines are running Windows OS

local one :
Running Windows XP
Oracle 8i

remote one :
Running Windows 8.1
MySql 5.6.17

Best Answer

well i created a small program using java packages :

mysql-connector-java-5.1.18-bin.jar

and aoracle jdbc driver :

classes12.zip (this version for oracle 8i)

with mysql connector i can run a "select" statements an read from mysql databse, and then i build an "insert" statement to instert them in the oracle database.

this was the best solution i found

PROBLEM

MySQL needs to be very explicit when flushing to disk in Windows. You have caught on to this when you did STOP SLAVE; and START SLAVE;

You said you are using sync-binlog = 1. That's great. That only addresses half the log file issues.

SOLUTION (or at least SUGGESTION)

You need to synchronize all other replication components

[mysqld]
sync-binlog = 1
sync-relay-log = 1
sync-relay-log-info = 1
sync-master-info = 1

The SQL thread reads binlog events of the master from the relay logs. Doing sync-binlog only flushes master logs. By flushing relay logs and the associated replication status files, this should make reading replication status and binlog events from the relay logs more accurate.

Here is the MySQL Documentation for these options

Give it a Try !!!

CAVEAT: There may be a small impact on disk I/O. Please monitor it.

Best Answer

Related Solutions

Sql-server – Real-time merge of two databases on different servers

MySQL Master-Master Replication not syncing

PROBLEM

SOLUTION (or at least SUGGESTION)

Give it a Try !!!

Related Question