topic Re: Working against two databases in Alfresco Archive

Working against two databases

tan-tan — Thu, 26 Mar 2015 08:33:09 GMT

Hi,I'm evaluating Activiti as BPM engine.My company has currently two data centers with full redundancy between them.We're using mySql for our own server using master-master configuration, while the auto-incremented ids are skipped by ten, while one data-center creates new records with 10, 20, 30, e

Re: Working against two databases

yvoswillens — Thu, 26 Mar 2015 10:19:08 GMT

Hi,

for this scenario you can use the UUID generator (as described here: http://www.activiti.org/userguide/#advanced.uuid.generator) .
This generator will create IDs based on time and the ethernet address of the machine.

Regards,

Yvo

Re: Working against two databases

tan-tan — Thu, 26 Mar 2015 11:51:19 GMT

Thank you.
Can you think of any other issue that could be raised by such architecture?
Do you know if someone tried it before?

Re: Working against two databases

jbarrez — Tue, 31 Mar 2015 08:02:04 GMT

I depends on how the database replication is configured. I can see scenarios where the data hasn't been synced yet and is needed on a certain node. But i don't know the details of your setup of course.

I have no knowledge of anyone else taking this approach.