How to synchronize MySQL database to MongoDB database

NoSQL is very popular, but to use it in a real environment, many people may still have a lot of concerns. A common practice is to write double data, first observe the situation and then decide whether to migrate. The following tool may be a boon for those students who want to migrate from MySQL to MongoDB. This is not a simple data import tool, but a real-time synchronization of data in MySQL to MongoDB. It is equivalent to MongoDB as a MySQL from library. This tool is based on an open source project called tungsten-replicator, and the tools are all open source. You can directly checkout the code to install and use it now. Schematic: The effect after installation: Execute the following SQL for creating tables and inserting data in MySQL: mysql> create table foo(id int primary key, msg varchar(35)); Query OK, 0 rows affected (0.05 sec) mysql> insert into foo values(1, ‘hello from MySQL!’); Query OK, 1 row affected (0.00 sec) The corresponding data can then be found in MongoDB: > show collections foo system.indexes > db.foo.find(); { “_id” : ObjectId(“4dc55e45ad90a25b9b57909d”), “1” : “1”, “2” : “hello from MySQL!” }