Mongodb support?

I notice there is a mongodb branch. right now I am seeking a nosql (distributed db) . we are using workflow heavily. There are about 1.5T for the history data.
mongodb supports transaction now, is there any plan to merger the latest master branch to the mongodb branch. then I can start work on it.

thanks.

Hi,

Is it just for the historic data that you want NoSQL? Or does the whole DB need to be MongoDB for scale?

Just asking as there may be options to use a different approach (e.g. MongoDB as a datasource for history; async history pumping data to MongoDB). The more you can share about the volume of active instances and historical, the more help we may be able to give.

The MongoDB branch is pretty well tested by us but we’ve been waiting for others to kick it around too.

Cheers
Paul.

It’s more than happy that we can place all data in mongodb.

I think the ideal is to use mongodb as datasource

By the way from release notes: https://github.com/flowable/flowable-engine/releases/tag/flowable-6.4.0

not sure it fully support or partial support?

The mongodb branch just transtorm the rs table record into mongodb document with one table to one document,one column to one property. If you use mongodb like this,you loss rs db’s relation query power,can’t using document faced advantages . For example ,in mogodb we shoud save one process instance data all in one document,include process base info,history activity,historic vars,historic comments.

The mongodb repo was indeed a direct transformation of the relation model to mongo. The idea was to try out the (then newly released) transactions in Mongo and see how it behaved compared against a relational database. And of course to see if people had interest in contributing and building it further out.

If you look deeper into the code, you’ll see the basics are there but many methods are not yet implemented. As @ylyly states, it would need a revision of the way the data is stored to store it in a format more native to mongodb. So right now it is more in an experimental state than anything else.

If you want to learn more, there was a talk on JAX London about it last year: https://www.youtube.com/watch?v=vzgU1lZ1h3U

hi joram & ylyly,

thank your information much!

As mongodb supports lookup(something like rdb join). may be we can achieve the same as rdb does.

@joram,


by the way if I want to implement these @todo, where is the right start point? where can I get some documents?

[
](https://forum.flowable.org/u/joram)
Thanks,
Ken Cheng

Is mongo db(full support) planned in next release (6.5 or next)? Or is it still at POC stage?

Hi,

Yes, what’s there works but it has not been fully implemented, optimized or heavily tested by us yet. We’d love feedback from people trying it out.

Cheers, Paul.

1 Like

@PHH Any further update on the release of support for Mongo. Are there any test or experiment results or benchmarks available for mongo support?

We’ve not had any further feedback, so very happy for anyone to test and benchmark.

Cheers
Paul.

Hi,

Any news on MongoDB support as datasource.

Thanks!

No changes yet - we are starting to see interest in this, but we really need community testing and feedback to help progress it at this stage.

Cheers
Paul.

I understand.
Thanks for the update.
Michel