Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

Hello, we are running OSQuery/Fleet and have the database going through MySQL 8.0. I just received word from our DBAs that they will be looking to upgrade to 8.4 with EOL for mysql coming up next year. Can anyone confirm if fleet will work with this version? Thanks

Fleet is currently tested using MySQL versions 8.0.36, 8.4.3, and 9.1.0! 

thanks! is this posted anywhere? I couldnt find it

It is :)

<https://fleetdm.com/docs/deploy/reference-architectures#:~:text=Fleet%20requires%20at%20least%20MySQL%20version%208.0.36%2C%20and%20is%20tested%20using%20the%20InnoDB%20storage%20engine%20with|https://fleetdm.com/docs/deploy/reference-architectures#:~:text=Fleet%20requires%20at%20least%20MySQL%20version%208.0.36%2C%20and%20is%20tested%20using%20the%20InnoDB%20storage%20engine%20with>%20versions%208.0.36%2C%208.4.3%2C%20and%209.1.0.