Test LMS and Studio devstack with MySQL 8.0

[iamsobanjaved]

As we are approaching the deadline for Django 4.2 upgrade, we are blocked on MySQL 8.0 upgrade. Kindly test the devstack LMS and Studio with MySQL 8.0.

(Copied A/C from SRE tickets)

A/C

Beta Give feedback

1. ENSURE data is exported from mysql57 and imported to mysql80 using the dbcopy8 make command. To export and import data from mysql57 to mysql80 container, run make command make dev.dbcopy8.<mysql-database-name> i.e. make dev.dbcopy8.reports will export database reports from mysql57 container to mysql80 container.
2. ENSURE smoke test are run
3. ENSURE devstack provision script for your services work with mysql80 container, Provision scripts for ecommerce in devstack repo:
4. ENSURE any issues are raised or addressed

[jmbowman]

Copying from https://2u-internal.atlassian.net/servicedesk/customer/portal/15/DOS-3927 that temporarily grew out of this:

After discussing with Adam Blackwell, we think all that’s needed here is to switch the services and provisioning CI workflow over to use MySQL 8 instead of 5.7. That should catch the most obvious bugs in the switch, and then we should communicate out that the switch has been made in devstack and ask people to update their dev environments as soon as practical. Then regular development work should flush out most of the problems that we’d be likely to catch with a manual testing effort anyway, as long as we allow some time for it before updating stage.

[iamsobanjaved]

Related PRs:

• fix: updated lms and cms mysql dependency to 8.0 openedx-unsupported/devstack#1165
• fix: replaced mysql57 hosts with mysql80 #33147

[farhanumar]

@adzuci Should we ask all the service owners to create PRs for their respective services and then Arbi-bom merge all PR into one PR for mysql8 final cutover of all the services? what do you suggest?

[adzuci]

Chatting with @jmbowman about this. I would like Soban or a member of arbi-bom update devstack for all services at once and to then notify #tech-devedx and post to discuss.edx.org.

[iamsobanjaved]

Upgraded MySQL to 8.0 in devstack in the following PRs:

• fix: replaced mysql57 hosts with mysql80 #33147
• feat: upgrade mysql to 8.0 openedx-unsupported/devstack#1189