Hello,
I want to verify that I am upgrading properly MySQL from version 5.7 to version 8 for a service that uses Camunda 7.17.11-ee.
These are the steps that I do:
- Start the service on an empty MySQL 8 database and allow Flyway to create the schema
Flyway will execute these scripts:
- 7.15__initial_camunda_engine_setup.sql
- all scripts that will migrate Camunda to version 7.17
- all remaining scripts that are related to the service database
-
After the schema is created stop the service and run the AWS DMS task that will migrate the data from the MysQL 5.7 database to the MySQL 8 database.
If the service is not stopped the data migration will not be done properly and the checksums will not match for some of the Camunda tables in MySQL 5.7 and MySQL 8.
During the data migration the AWS DMS task prints warnings “Unexpected charset utf8mb3 for column”, that does not affect the data migration. -
After the data is migrated for each table the checksum is the same in MySQL 5.7 database and in MySQL 8 database.
-
Start the service and start using it.
Is there something that I am missing to do?
The Camunda sql scripts set collation utf8_bin that is converted automatically to utf8mb3 in MySQL 8, is this a problem because the recommended collation is utf8mb4 ?