Real-Time Local-Cloud SQL Sync
Budget: $250 – $750 USD
I’m looking for a reliable way to mirror my on-premise SQL database to AWS RDS in real time. The web service you build will capture every change that hits the local tables—customer information, inventory data, and transaction records—then push those changes up to the cloud with minimal latency.
My priorities are:
• Zero data loss and consistent state between the two stores, even when connectivity drops temporarily.
• Latency low enough to feel immediate to downstream apps that rely on the cloud copy.
• A straightforward deployment path: I should be able to install the service on a Windows or Linux host beside the local database, point it at the RDS instance, and watch it run.
Deliverables
1. Source code for the sync service (language and framework of your choice, as long as it’s stable and well-documented).
2. A configuration file or GUI where I can map local tables to their cloud counterparts.
3. Step-by-step setup guide covering prerequisites, initial full load, and ongoing change data capture.
4. A quick test plan so I can verify real-time replication on my end.
If you have experience with change data capture, logical replication, or building similar pipes into AWS RDS, let’s talk details and timelines.
My priorities are:
• Zero data loss and consistent state between the two stores, even when connectivity drops temporarily.
• Latency low enough to feel immediate to downstream apps that rely on the cloud copy.
• A straightforward deployment path: I should be able to install the service on a Windows or Linux host beside the local database, point it at the RDS instance, and watch it run.
Deliverables
1. Source code for the sync service (language and framework of your choice, as long as it’s stable and well-documented).
2. A configuration file or GUI where I can map local tables to their cloud counterparts.
3. Step-by-step setup guide covering prerequisites, initial full load, and ongoing change data capture.
4. A quick test plan so I can verify real-time replication on my end.
If you have experience with change data capture, logical replication, or building similar pipes into AWS RDS, let’s talk details and timelines.