DB Migration script for MySQL from Camunda version 7.9 to 7.10

Camunda 7 Topics Discussion & Questions
1

Where can i find the migration scripts for upgrading from Camunda Version 7.9 to 7.10 for MySQL database?

1 Like
2

Hi @aravindhrs,

just download any 7.10 distribution from here: https://camunda.org/release/camunda-bpm/

Each Distribution includes a sql/upgrade-folder with everything you needs.

The files are on https://github.com/camunda/camunda-bpm-platform/tree/master/distro as well.

Hope this helps, Ingo

2 Likes
3

Thanks @Ingo_Richtsmeier.

We are already having running process instances in camunda 7.9. So we cant simply download 7.10.

We have to run upgrade scripts to migrate from 7.9 to 7.10, by without affecting running process instances.

My Approach for upgrading to 7.10 from 7.9:

  • We update the camunda versions in build.gradle file to 7.10 which was earlier 7.9.
  • Then run the update scripts specific to database from the link:

Is this approach is correct? and can we call it as proper version upgrade? or anything else we have to do to upgrade from camunda 7.9 to 7.10?

Note: I was using camunda spring boot starters.

1 Like
4

Hi @aravindhrs,

the idea is to just download the zip, unpack it somewhere and don’t start the server inside. A download to your computer won’t harm the running spring-boot application. (I have dozens of them on my computer, distros and sprint-boot-applications)

The database upgrade is described here: https://docs.camunda.org/manual/7.10/update/minor/79-to-710/#database-updates.

You have to run the script manually, as the Camunda engine won’t do to it for you. To download a distro is a simple approach, but you can clone the platform from github to get scriüpts to your hard disk as well.

The database change won’t influence running process instances as Camunda supports rolling upgrade with one minor version: https://docs.camunda.org/manual/7.10/update/rolling-update/

Hope this helps, Ingo

2 Likes
5

@Ingo_Richtsmeier I have downloaded .zip file from nexus repository and it has 3 folders create,drop and upgrade.

I was trying to upgrade from 7.9 to 7.11. I have executed the scripts from upgrade folder.

Do I need to execute the scripts from create & drop folders too?

1 Like
6

Hi @aravindhrs,

for migration only the upgrade scripts are relevant.
The create scripts create the database schema for the respective version and the drop scripts reverse the creation and drop everything.

Hope this helps.
Cheers,
Miklas

2 Likes