Synchronise a MySQL table to a PostgreSQL table

We have a working MySQL db which has a table that receives up to 1000 new records per minute. We need to make a script that periodically reads the data, filters it for duplicates and process some of the timestamps before writing the data into another PostgreSQL table on another server.

All this needs to be done with the smallest delay possible between the data being written into MySQL and the data being processed and copied to PostgreSQL. We have to avoid duplicate records in the target PostgreSQL db at all costs.

I am looking for people with experience in processing large amounts of data in a relatively short time and who can build the system as close to realtime syncing as possible. I am open to all design suggestions and can deliver sample databases for the successful bidder to start work on.

Skills: Linux, MySQL, PHP, PostgreSQL

See more: convert mysql password table md5, short description skill experience php mysql ajax, mysql look table, php mysql html table display, php mysql display table css, mysql create table longtext, format php mysql display table, form insert data php mysql, saving data php mysql ajax, sorting data php mysql, mysql create table csv file, php mysql query table, asp getting data form mysql database, import data external mysql, extract data as400 mysql, world zip code data base mysql, search data fields mysql database, mysql lookup table, serial data tcpip mysql, mysql move table

About the Employer:
( 30 reviews ) Singapore, Singapore

Project ID: #14727701