Hi Elisha,

Currently Mistral doesn’t support any expiration policies for 
workflow/task/action runtime objects. It keeps them forever until someone 
deletes them manually.

I see the following ways of addressing your need:
Implement some cleanup component within Mistral (how to call it?) using its 
Scheduler component to periodically query and delete objects based on a 
criteria provided in a config.
Just implement something on top of Mistral API to do the same. The cons of this 
approach is that Mistral now doesn’t provide any flexible mechanism to do 
criteria-based search of its objects. There’s an adjacent BP for that [1]. 
Generally, there’s a number of things in Mistral API we are not satisfied with 
and we’ve been planning to design and suggest API v3 for Mistral to support 
those features (don’t confuse with DSL v3, there’s no plan for now to implement 
a new backwards incompatible DSL). So this option may not be effective from 
performance perspective.

I think it deserves its own blueprint so that we can discuss nuances.

[1] https://blueprints.launchpad.net/mistral/+spec/mistral-items-filtering 
<https://blueprints.launchpad.net/mistral/+spec/mistral-items-filtering>

Renat Akhmerov
@ Mirantis Inc.



> On 02 Jul 2015, at 13:37, ELISHA, Moshe (Moshe) 
> <moshe.eli...@alcatel-lucent.com> wrote:
> 
> Hey,
>  
> We are planning to use Mistral in production in the next few months.
>  
> We noticed that having even a simple workflow with a cron-trigger (For 
> example monitor and heal workflow) can create large amounts of data in the DB 
> (MariaDB).
>  
> Does Mistral have a mechanism / configuration of automatic deletion of old 
> executions?
> What is the best practice to handle this type of challenge?
>  
> Thanks.
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: openstack-dev-requ...@lists.openstack.org 
> <mailto:openstack-dev-requ...@lists.openstack.org>?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev 
> <http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev>
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to