Find Jobs
Hire Freelancers

Synchronise a MySQL table to a PostgreSQL table

$30-250 USD

Closed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 14727701

About the project

16 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of SINGAPORE
Singapore, Singapore
4.8
30
Payment method verified
Member since Oct 11, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.