Need Suggestion on the place where the data should be stored

Hello All,

Can you please tell me what is the best practice on storing the application specific data?

  1. Separate Mysql Server
  2. Different database on the same mysql server as camunda’s db
  3. Add tables on Same Database where camunda’s data is stored

i feel 3rd approach is less complex on the configuration side but Can you please confirm whether this is a good way to proceed the development?

Not authoritative, so take this with caution.

Options 1 and 2 are preferred.
This conforms to the idea of keeping your business data separate from your process-operation data. It will also allow you to maintain/report on your data at any time if you decide to move to a different workflow orchestrator (eg. Camunda 8)

Personally, Option 1 is the best, but if you can’t do that, then option 2 is the next-best thing.

1 Like

Hello @DineshDinesh and @GotnOGuts ,

I love the provided answer. I just would like to add one thing:

If you use a database directly, keep in mind that you can use the same transaction context as the process engine does.

I hope this helps


Thank you for the answer, Will proceed through option 1 :slight_smile:

1 Like

Thank you, point taken.

1 Like