Update MySQL to 8.0

[csweichel]

We're still running on MySQL 5.7 which is rather slow on some schema modifications - something that MySQL 8 does much better.

Steps forward

1. Analyse the upgrade guide to make sure we're not relying on defaults that have changed
2. update chart dependency to pull in 8.0
3. if need be, bump the TypeORM mysql dependency
4. run db-tests
5. observe server and ws-manager bridge for any DB-related errors

[csweichel]

/schedule

[mrsimonemms]

This is details in this SO Post. I'll give a brief overview

MySQL 8 authentication has changed which causes a few issues with NodeJS as they've changed the plugin from mysql_native_password to caching_sha2_password. None of the MySQL plugins for NodeJS support this new authentication mechanism.

There's a couple of workarounds:

• if you have access to the run command (eg, if it's in a Docker container), append the command with --default-authentication-plugin=mysql_native_password
• if it's a cloud instance, run ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MyNewPass';

Although I've never investigated it, these shouldn't affect the speed of the schema modifications.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[JanKoehnlein]

This issue has been set to scheduled by our automation because the label "meta:stale" was added. Unscheduling

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.