Need Suggestion on the place where the data should be stored

Camunda 7 Topics Discussion & Questions
1

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?

2

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
3

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

Jonathan

4

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

1 Like
5

Thank you, point taken.

1 Like
6