Upgrading to Bonita 7.9.* in production
I'm not running myself a Bonita server in production with MySQL but I pretty sure someone will be able to share some feedback here.
Just a quick note about MySQL configuration: MySQL 8 recommend to use
utf8mb4 as default encoding but due to limitation related to index size in MySQL Bonita is currently only able to support
utf8mb3 (see the note in Bonita documentation).
Also if you not already did I recommend to read the documentation about migration.