Bug Report: XtraBackup with MySQL 8.4

[L3o-pold]

Overview of the Issue

After upgrading from MySQL 8.0 to MySQL 8.4, backup are now longer working with vitess/lite:v21.0.1 docker image.

Reproduction Steps

Deploy a cluster with MySQL 8.4 and vitess/lite:v21.0.1.

Run vtctldclient --server=localhost:15999 --alsologtostderr BackupShard --concurrency=1 commerce/-80

See the error: time:{seconds:1736873755 nanoseconds:644556941} file:"xtrabackupengine.go" line:416 value:"xtrabackup stderr: 2025-01-14T16:55:55.644443-00:00 0 [ERROR] [MY-011825] [Xtrabackup] This version of Percona XtraBackup can only perform backups and restores against MySQL 8.0 and Percona Server 8.0"

Binary Version

Docker image Version: 21.0.1 (Git revision 3d4f41db2fbc32611c7d2ea2af3dc68b9d962415 branch 'HEAD') built on Tue Dec  3 05:32:30 UTC 2024 by vitess@buildkitsandbox using go1.23.3 linux/amd64

Operating System and Environment details

docker

Log Fragments

time:{seconds:1736873755 nanoseconds:644556941} file:"xtrabackupengine.go" line:416 value:"xtrabackup stderr: 2025-01-14T16:55:55.644443-00:00 0 [ERROR] [MY-011825] [Xtrabackup] This version of Percona XtraBackup can only perform backups and restores against MySQL 8.0 and Percona Server 8.0"

[L3o-pold]

seems like we "miss" a 8.4 bootstrap image https://github.com/vitessio/vitess/tree/main/docker/bootstrap 🤔

[frouioui]

That's a good point. We don't publish any lite image that contains MySQL84.

We stopped using bootstrap for lite, now we would have to modify the docker/utils/install_dependencies.sh script to include install steps for 8.4 and add a new Dockerfile under docker/lite for 84 that uses the new path in the install_dependencies script. This new Dockerfile would be built and pushed like the other images in the Build Docker Images workflow.

[L3o-pold]

Are we interested in making this? A new image for now, and maybe in the future making this the default (for lite image) as MySQL 8.4 is LTS?

[frouioui]

I think we are interested in doing this for now, yes. The long term goal was to eventually get rid of mysqld in the lite image but that happened to be more challenging than it needs, specially with vtop and other mysql dependencies we ship (xtrabackup, mysqlsh, mysqlbinlog, etc).

[L3o-pold]

I will draft a PR this week then

[frouioui]

Awesome, much appreciated 🙏🏻