DB preference for multi-instances Camunda deployment

Hello guys,

Do you have any preferences (e.g. Postgres or MySQL) for multi-instances Camunda deployment? Lets say 2 instances.

I prefer MySQL, because we are using Amazon RDS instance of MySQL engine and also easier.

You can check supported environments page for more insights about databases:

https://docs.camunda.org/manual/7.9/introduction/supported-environments/#databases

https://docs.camunda.org/manual/7.10/user-guide/process-engine/database/#database-schema

And Cluster setup:

https://docs.camunda.org/manual/7.9/introduction/architecture/