Synchronisation of data between MySQL and Oracle
Posted on 2007-10-10
I currently have a Point of Sales system project where we will host a local POS server in each retail outlet and at every 15mins it will replicate the latest data back to the central POS server at the data centre. However POS application requires real time sales data from our online retail system where the data is residing in an Oracle 10g server in the data centre. Thus the MySQL needs to import data from Oracle and then then export back to Oracle again. I have the following concerns:
- Is the method of hosting a local POS server and replicating it to the central POS server at every 15min a good enough practice? If there is a better architecture pls advise.
- What is the best way, process, interval, format for MySQL to import sales and members data from Oracle and sync the POS MySQL back to Oracle? Who draw from who at each point of time?
- There are potentially transactional problems in synchronisation from local POS to POS server, Oracle to POS and POS to Oracle. How to solve these problems?
Pls advise. Thank you.