Introduction
In order to provide the best experience, amazee.io may provision managed database services for use by Lagoon environments. Support for MySQL 8.0 is ending and all managed databases will be upgraded to MySQL 8.4.
How will environments be affected?
Environments running supported languages and Lagoon base images should verify that their application is compatile with MySQL 8.4.
** Add note that Drupal is fine? **
Environments running end of life (EoL) languages or Lagoon base images should upgrade to a supported version before verifying that their application is compatible with MySQL 8.4.
Known Issues
PHP
PHP versions < 7.4.4 do not support the new caching_sha2_password algorithm for MySQL authentication. Existing database users will not be migrated to the new algorithm, so applications will still be able to connect to the database. New databases will use the new algorithm for users, which will prevent applications from connecting.
Applications that are not able to connect to a database using caching_sha2_password algorithm must upgrade to a supported PHP version.
CLI Services
Lagoon base images for EoL languages, like PHP 7, contain old versions of the mariadb binary that do not support the new caching_sha2_password algorithm for MySQL authentication. Existing database users will not be migrated to the new algorithm, so mariadb will still be able to connect to the database. New databases will use the new algorithm for users, which will prevent mariadb from connecting.
When mariadb is not able to connect, it can prevent other tools like Drush and Lagoon tasks from completing.