cancel
Showing results for 
Search instead for 
Did you mean: 

Live DB/Activiti Upgrade

jlew
Champ in-the-making
Champ in-the-making
Is it possible to do a live upgrade where we update the database schema while old version of Activiti is running?

Our application runs in a complex environment with many servers and we have a requirement where we can not shutdown the entire cluster at the same time to perform and upgrade.

So are the database upgrades normally backwards compatible?  I know activity has a schema check which is what prompted this question.

Normally we direct traffic off some of our clusters and then shutdown our applications to apply db changes and upgraded software.  Then we bring up the upgraded machines and repeat on the next. Currently we have all instances running on the same database and now we are evaluating what are the options for future upgrades.

Does the engine support this?  Ideally we would like to just divert traffic, allow current processes to get to a hold/completed state, shutdown applications, apply db upgrades, upgrade Activiti jars, bring back up, then repeat on the other nodes (skipping the db upgrade as it was already performed).

Thanks
1 REPLY 1

frederikherema1
Star Contributor
Star Contributor
In theory, this is possible, as the db-version check is only done when the engine boots. If you can guarantee that no active processes are running (also, no jobs are being executed) you can be sure that no data is being used that might be updated (although most activiti upgrade-scripts don't contain any data-manupilations, only DDL's).