why camunda uses h2 as a default database? what is the advantages and disadvantages of using h2 database?
Hi @nandhini,
Camunda uses h2 by default as an in-memory database. That means it does not require additional setup. In consequence, getting started, building prototypes or writing unit tests is easy. On the downside, we do not recommend h2 for production for pretty much the same reasons.
Cheers,
Thorben
1 Like
thanks @thorben. So when we will switch from h2 database to other databases like mysql? Only in terms of production purpose or is there any other reason related to memory or storage?
That is totally up to you. I suggest you make yourself familiar with the databases you are interested in and their features and tooling. I can’t make that decision for you 
Cheers,
Thorben
can many applications uses h2 database at same time when it is in embedded mode or server mode?
Yes, depending on configuration. You’ll find detailed answers and configuration options in the h2 docuimentation.
Cheers,
Thorben