Separate db for camunda and business model

Camunda 7 Topics Discussion & Questions
1

Hi,

I have app based on camunda. Schema contains camunda tables and business model.
I would like to separate them but i don’t know best practise in this area.

Questions:

1.Is it best practise to have separate schema? If Yes why ?
2.Is it required to have separate schema? If yes why ?
3. Is there value added?
4. Pros and cons to have separate schema?

2

Hello my friend!

There is no “recommended best practice”.

It all depends on the context and specific needs of your project.
I particularly like separate DBs, as I believe the advantages in my projects are greater…

  • I have total isolation, facilitating the maintenance and visualization of data (if you want to see data related to the camunda process, you have its database… if you want to access business data, you have your own database for this);
  • We can better manage access permissions;
  • I have better performance, because for example, when we have camunda’s history and metrics activated, this generates numerous records in the camunda database, and adding this to the records in your domain database, will undoubtedly affect its performance and its “scale” it will have to be in greater proportion.
  • You can have Camunda’s SQL database (for example, Postgress) and a NoSQL database like MongoDB or even a DynamoDB as a database for the business.

The pros are basically the ones I mentioned above (isolation facilitating data maintenance and management, permissions/access management and performance gains).

The cons in my opinion are:

  • Complexity in infrastructure maintenance;
  • Increased complexity in a possible “data migration”;
  • Separate banks may increase the cost of the project.

But I say again, the best path will depend on the context of your business… there are contexts in which separate banks are even a requirement, such as regulated sectors, such as health, finance and some others.

I hope this helps!

William Robert Alves

1 Like
3

If an answer clarified your question or solved your problem, please mark the answer as “Solution”, so that other users can quickly find the answer they are looking for, if their question is the same as yours.

This will also ensure that this topic is closed correctly and saved for future consultation by other community members who may need it.

Use this as a good practice when using the forum! :smile:

Thanks in advance!

William Robert Alves