topic Re: 24x7 activiti database? in Alfresco Archive

24x7 activiti database?

mingway — Thu, 18 Apr 2013 15:10:08 GMT

Hi,We need high availability activiti engine, 24x7. If we bring down activiti database(oracle) for maintenance, and switch to a backup db, how can we handle those in-progress process instances in the down database? How can we move the running data to the backup db?Is there any mechanism? I think ba

Re: 24x7 activiti database?

jbarrez — Thu, 18 Apr 2013 17:56:04 GMT

I think the easiest is to do it on the DB level. I only have experience with mysql on that front, but there we used a setup with master-slave replication where we could divert traffic to one of the slaves when we needed to take down the master. I don't know about Oracle, but I'm sure they'll have something similar.

Re: 24x7 activiti database?

mingway — Thu, 18 Apr 2013 19:22:33 GMT

Thanks, jbarrez!

We do use shareplex to sync up data between 2 dbs. But even that small latency is not acceptable. So still trying to find some solution.

Re: 24x7 activiti database?

jbarrez — Mon, 22 Apr 2013 09:09:56 GMT

I remember that I worked with a sysadmin before that used dns routing for that.
He switched all traffic to a certain db for a while, upgraded the other db (or whatever) and brought it back online and restored the dns.

But I'm no sysadmin. But I really think that's the area you should look into rather than on the application level.

Re: 24x7 activiti database?

laures — Thu, 02 May 2013 09:47:06 GMT

i'm currently evaluating activiti and have a similar problem:

we require application based replication capabilities. currently all data is replicated using jpa and eclipseLink.

is it possible to configure the persistence of activitiy to replicate its data to multiple connections?
Is it possible to implement a custom persistence mechanism?

Greetings,
Alexander

Re: 24x7 activiti database?

jbarrez — Mon, 06 May 2013 08:54:56 GMT

> is it possible to configure the persistence of activitiy to replicate its data to multiple connections?

No, not out of the box that is. I don't know if it exists for other databases, but I remember using in the past a driver for my database which did something similar for me.

> Is it possible to implement a custom persistence mechanism?

It is possible, it is open code after all … but I won't go down that path. It will take you a lot of time and will make it difficult to upgrade to new versions.