I have the following architecture:
I am importing data from an SQL database into mongodb. I am using an importer to transfer data to mongodb, which provides data to a website through an API.
Importing can take a couple of minutes, and if it fails, I would like to be able to roll back (it would be nice to be able to rollback several imported goods) or refuse a database / collections of unsettled rows (if you think of it as SQL transactions).
, . , . temp db, . , -, . - db-, ( ).
concurrency?
:
:
cron, , . , , SQL-db. SQL-db .
, URL- SQL db.
, .