Data synchronization between MySQL and MongoDB

Question

I am looking for a way to synchronize my data from MySQL to MongoDB. I do not want just to replicate my data, I want them to be permanently synchronized. Does anyone know if Tungsten Replicator would do the job ? I can see that it replicates data but what about replicating data automatically when changes are made in MySQL database ?

If not possible would you suggest any other solution to do this ?

Answer 1

Yes Tungsten Replicator provide real time synchronization between MySQL and Mongodb however to get your old data replicated you can use other tools like mongify to get old data. Best of Luck!

Answer 2

Yeah its possible to have data synchronization between MySQL and MongoDBusing tungsten replicator.But it has certain limitations where it does not replicate the DDL events.

kindly look into this link to achieve it.