Hi,
We are planning to create application with multiple flowable engine & multi tenant but connecting single database schema. And expecting the workload should be shared between the multiple engines, so that the application performance will not get affected when there is a high usage. Please let me know is any option to do the same.
Thanks in Advance.
Not sure if this would work: as long as you use different tenantIds and the same version of the engines, it’s ok for regular API usage. The async executor of each engine however, will poll all jobs, not tenant-based, which makes this setup not ideal.
It’s much easier to have a separate schema for this use case - what’s the reason why that’s not possible?
@joram Thanks for your response.
Actually we are looking for scalable engine. So that, we can scale up/down the number of engine based on the load which we expected. In such case, we can’t create/drop schema per engine. Please suggest.
Adding more engines won’t add more scalability automatically - the bottleneck will always be the relational database. So adding more Flowable nodes, IF they are idempotent would allow you to handle more load - as long as the relational database is able to handle it.
@joram Thanks for your response.
We will consider the separate schema for each engine as you suggested.
Please let me know, in a single spring boot application configuring multiple flowable engine is possible? Like each engine will point to different DB schema.
If that is feasible, please let me know how we can achieve that or share some documents/links for reference.
It’s technically possible, but you’ll be going against the defaults of Spring Boot which assumes one datasource and one transaction manager (e.g. through the spiring.datasource.xyz properties). You’ll need a separate datasource / transaction manager beans for each Flowable engine. Do note that each engine has a threadpool for the async executor, which will be running on the same node and potentially compete for resources.
@joram Thanks for your response.
I understand the points you mentioned.
Can you please recommend some documents / links here on configuring multiple flowable engine in single application. That would helps for me.