AnsweredAssumed Answered

Working against two databases

Question asked by tan-tan on Mar 26, 2015
Latest reply on Mar 31, 2015 by jbarrez
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, etc. ids and the second data-center creates the ids with 11, 21, 31, etc., this way new records with the same id won't be created simultaneously in both data-centers.
I understand that in each data-center I can seamlessly run activiti-explorer on multiple machines against the same mySql server.
Can I do that with two databases that synchronized constantly between them in two different data-centers?
How can I overcome the id uniqueness issue if the id is created by the engine?