Activiti Database Scalability

[awadhambika]

Hi,
We are planning to use ACTIVITI on a big scale in our organizations i.e. as an enterprise level solution for our Workflow related needs.
Now, we are assuming the below scenarios:
a) No. of Workflow processes = approx. 200
b) No. of instances per process = approx. 100000
c) No. of tasks per process = approx. 10
d) No. of processserver/local variables = 10

Total No. of process Instances = apprx. 200*100000 = 20 Million
Total No. OF Tasks = 20*10 = 200 Million
Total No. OF variables = 2 Billion

(Kindly correct if my calculation is wrong somewhere.)

Based on the above i am expecting ACTIVITI to handle data size of order billions.

My question is that, can ACTIVITI scale to such huge amount of data without addding any  overhead to the Data Base?
Please  suggest ideal DB size required for the same and optimization measures recommended.

Thanks,
Binit

[awadhambika]

Correction:
c) No. of tasks per process instance = approx. 10

[martin_grofcik]

Hi Binit,

It is not easy question. May be you can find more information here:
http://www.jorambarrez.be/blog/2012/06/28/the-activiti-performance-showdown/


Regards
Martin

[trademak]

You can cluster any number of Activiti instances to process this amount of process instances. So don't see a problem from an Activiti perspective. The database will probably be a bottleneck, so you might want to look into clustering the database as well.

Best regards,

[funvin]

Hi Binit,
Sorry for reviving the old thread, but just wanted to check if you did decide to go ahead with activiti and if it was able to scale. We are evaluating using activiti in our company, and our scales are no where near yours as of now, but as we expand use, they can start touching those numbers. Also, Activiti's ability to scale dictates our design decisions.
Thanks,
_vinay_

[trademak]

Activiti is designed as a stateless engine, so scalability should not be an issue.
You can add as many nodes as needed to an Activiti cluster.

Best regards,