Upgrade from mysql 8.0 to 8.4 before 31 July 2026

[ianheggie-oaf]

Problem

AWS will charge us more if we don't update to MySQL 8.4 by 31 July 2026:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.VersionMgmt.html#MySQL.Concepts.VersionMgmt.ReleaseCalendar

Describe the solution you'd like

• Document all that went wrong with the upgrade to 8.0
• Add tests to protect
• Perform the upgrade

Describe alternatives you've considered

Manual testing (UGH)

Additional context

• EPIC: Fix openaustralia/twfy/parser post mysql 8.0 changeover openaustralia#788

[benrfairless]

@ianheggie-oaf I'm confused about why this issue is in PlanningAlerts - PlanningAlerts uses PSQL, not MySQL?