Database Upgrade Query, Character Set / Collation

[Stephen Hames]

Hi All,

I have a question on doing an in-place upgrade from Rundeck 3.4 up to 4.x.

My existing instances use MySQL 5.7 and I intend to upgrade the database to MySQL 8 as recommended by the documentation.   However, it's not clear to me whether I need to do any further changes on the database (beyond the usual my.cnf edits) to upgrade Rundeck's database from UTF8mb3 to UTF8mb4, and the related collation settings.     

Does Rundeck's database upgrade mechanism handle this, or is there some additional manual work that needs to be done as part of the upgrade procedure?

I'm assuming that utf8mb4_0900_ai_ci is the preferred collation?

Thanks.

[rac...@rundeck.com]

Hello Stephen

If you want to upgrade 3.4.X to 4.14.1 (the latest version at this moment), the best (and quickest) approach is to export your instance and import in a fresh 4.14.1+MySQL 8 instance, take a look at this.

Anyway, I ran some utf8mb4_0900_ai_ci  collation tests with the following configuration (using MySQL 8.0.33 on Docker):

My my.cnf config:

[client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] collation-server = utf8mb4_0900_ai_ci init-connect='SET NAMES utf8mb4' character-set-server = utf8mb4

Rundeck runs well. In any case, make sure to test the config in a non-prod environment first.

Apologies for the delayed reply.

Regards!

​