Are there any notes around upgrading to mysql 8.0?...
# fleetj
James
03/27/2025, 2:57 AMAre there any notes around upgrading to mysql 8.0? I noticed that support for 5.7 was dropped without much communication...
I'm going back over the PRs and seems like the note at https://github.com/fleetdm/fleet/pull/20225#pullrequestreview-2163468038 was not respected 😞
z
Zay Hanlon
03/27/2025, 1:22 PMHi @James! I posted an update and pinned it to the channel here: https://osquery.slack.com/archives/C01DXJL16D8/p1721091538419079
I'm sorry you missed it 😞 Please let me know if there's a better way that you'd like to see critical updates on the community here. It's tough to balance getting important updates to folks here without creating a ton of spam.
We also had a note at the top of release notes in v4.55 here: https://github.com/fleetdm/fleet/releases?q=mysql+5.7&expanded=true
Zay Hanlon
03/27/2025, 1:24 PMAs far as instructions to upgrade go, we've been pointing our customers here - https://dev.mysql.com/blog-archive/inplace-upgrade-from-mysql-5-7-to-mysql-8-0/ (FWIW, seems to be a relatively painless process)
Zay Hanlon
03/27/2025, 1:24 PMPlease let us know here if you have any Fleet related issues upgrading
j
James
03/28/2025, 4:23 AMI noted back a while ago that mysql is a no-go for us (see https://github.com/fleetdm/fleet/issues/18265#issuecomment-2060221340)
James
03/28/2025, 4:23 AMWe'd likely be running percona xtradb; I will have to see if an inplace upgrade is easy or not (we use an operator)
z
Zay Hanlon
03/28/2025, 7:30 PMThanks @James - Let us know how it goes.
While we see some community members using Percona, we have stated that it is not officially supported by Fleet. We only support, test, and QA our releases on MySQL. I've heard some rumblings about support for other db's in the future, but there is nothing set in stone yet.