Magento 2.4.2 and Aurora MySQL 8.0

[vencivatasccf8]

Hello,

We are having Magento 2.4.2 running with Aurora Mysql 5.7,

Can we upgrade the version of Aurora Mysql to 8.0.28?

I have found issue with 8.0.29 and Magento less than 2.4.5

MySQL version >= 8.0.29 is no longer compatible with Magento <= 2.4.5 #84
https://github.com/AdobeDocs/commerce-operations.en/issues/84

[johnwebdes40a5]

Hello @vencivatasccf8 

Steps to Downgrade MySQL:

Back Up Your Data: Ensure you have a complete backup of your database.

Remove the Current MySQL Version: Depending on your server setup, you might need to stop the MySQL service and uninstall the newer version.

Install the Compatible Version: Download and install MySQL 8.0.28 or earlier from the official MySQL website.

Restore Your Data: After installation, restore your database from the backup.

Hope it helps !

If you find our reply helpful, please give us kudos.

A Leading Magento Development Agency That Delivers Powerful Results, Innovation, and Secure Digital Transformation.

WebDesk Solution Support Team

Get a Free Quote | | Adobe Commerce Partner | Hire Us | Call Us 877.536.3789

[Milople]

Hello @vencivatasccf8,

Yes, you can upgrade your Aurora MySQL version to 8.0.28 if you're running Magento 2.4.2, but be cautious with versions beyond that (like 8.0.29 and above), as they are known to have compatibility issues with Magento versions below 2.4.5.

This issue was noted in the Magento community, where changes in MySQL 8.0.29 affected Magento’s database queries, causing incompatibility.

To ensure stability:

1. Backup your database and Magento files before upgrading to Aurora MySQL 8.0.28.
2. Test the upgrade in a staging environment to verify that there are no issues with core functionalities, especially around database operations and extensions that interact heavily with the database.
3. Consider updating to Magento 2.4.5 or higher in the future to avoid potential compatibility issues with newer MySQL releases.

If you encounter issues during the upgrade, reviewing logs and testing any custom queries can help identify if adjustments are needed.

If the issue is resolved, click Kudos and accept it as a solution.