Updating MySQL 8.0.0 to MySQL 8.4.10

0
Hi Reader,My application is deployed on EKS cluster on production environment.On AWS, I am using MySQL (8.0) as a database and now I want to upgrade the my sql version 8.4.10.Now I want to know that it updated version will cause any issue on existing data or any integration.Integration I have done areAmazon S3Email ConnectorAny ChartReportingPlease let me know regarding the compatibility of mendix 10.24.21 with mysql 8.4.10Thanks and Regards,Harshraj Singh
asked
2 answers
0

Upgrading from MySQL 8.0 to 8.4.x is generally a minor version upgrade, so your existing data should remain intact. However, I would recommend validating it in a lower environment before applying it to production.

From a Mendix perspective, your integrations such as Amazon S3, Email Connector, Any Chart, and Reporting are unlikely to be affected, as they do not depend directly on the MySQL version.

The main things to verify are:

  • Take a full database backup before upgrading.
  • Test application startup, database migrations (if any), and critical business flows after the upgrade.
  • Review the MySQL 8.4 release notes for any deprecated features or configuration changes that may affect your environment.


If you're running on AWS RDS, also check the upgrade path recommended by AWS, as they may require intermediate version upgrades depending on your current engine version.


Kindly mark this as the accepted answer if it helps.

answered
0

Hi Harshraj Singh


MySQL 8.4 support was officially added starting from Mendix 10.6. Since you're on Mendix 10.24.21, you are well within the supported range. actually MySQL 8.0 is no longer listed 8.4 is now the designated LTS branch, so this upgrade is the recommended path.


Secondly, MySQL 8.4 is backward-compatible with 8.0 at the data level (same InnoDB format). However, keep these Mendix-specific MySQL requirements in mind. And all of your modules[which you listed] will be running on top of application layer and have zero direct dependency on the MySQL.


And if you see there is no impact for you to migrate but to make sure it works well it is best to have DB backup and One critical issue will be Time zone tables[if you dont have such table then there is no problem].


I hope this helps!!


answered