Unify Multiple Local Databases in a Remote Central Database

Hi @kevinadi,

Thanks for the reply.

Does this mean that you want a copy of all client’s data in the central server?

Yes, this is what we want.

I’m wondering, if having a central server is the main use case, why do you need to install a local MongoDB on the client at all? Is it possible to just use a single centralized database and all client connect to it instead?

Unfortunately, each client needs its own local database. I agree that this would be the best scenario.

I am almost achieving my goal with Debezium and Kafka MongoDb Sink Connector. With Debezium, I have a CDC pipeline and Kafka streaming all my data to the global database.
For now, my setup is just failing for update operations. I am going to create a new topic with all the information regarging this issue.