Someone from the team left the internet free on a server and mysql was automatically updated to version 8.0.30. Now we have a system without backup because xtrabackup 8.0.29 is incompatible. I’ve been checking for over a month to see if the new version of xtrabackup has been released. Is there any release date for the mysql 8.0.30 compatible version?
Hi @CESAR_MURILO_DA_SILV , thanks for posting your question to the Percona forums
We generally release PXB within 30 days of our MySQL releases. Since we don’t have a Percona Server for MySQL 8.0.30 release yet, I would say we are still more than a month out.
We’re tracking the PXB 8.0.30 release in Log in - Percona JIRA Which doesn’t yet have a set release date. I see there are 4 unclosed BLOCKER tasks there so it could be some time before the release is available.
Mr. Coburn, the link that you’ve listed below - I can’t view those issues, it’s likely internal only:
We just completed an upgrade to 8.0.30 and are dependent upon Percona’s extrabackup. Moving down to 8.0.29 is not-ideal due to bugs in Mysql.
ETA on Xtrabackup 8.0.30 or recommend a work around that allows a streaming backup with replication recovery?
Hi @dcgawl , welcome to the Percona forums!
I’ve asked internally about whether we have a date for release. I’ll update this thread as I learn further details
In terms of streaming backup, you may want to consider using a logical backup system such as mydumper in the interim so that you can take consistent backups of your 8.0.30 environment.
Some background info on why XtraBackup 8.0.30 is still in the works: Oracle rewrote the redo logging functionality in this version (see our blog post MySQL 8.0 Dynamic Redo Log Sizing for details), and XtraBackup needs to be updated to adapt to these changes. This work is tracked in this Jira issue: PXB-2866 - Make PXB 8.0.30 be able to backup 8.0.29 (and prior) server
Is there a way to get the XtraBackup 8.0.30 beta version for testing?
Our scenario is quite simple we want to backup MySQL 8.0.30 from one server and restore to another MySQL 8.0.30 server, we don’t need backwards compatibility with MySQL 8.0.29 or previous versions of MySQL.
Exactly, we have the same scenario with Adrian_Muscan
Red Hat EL 8 and it’s derivates are rolling out mysql-server 8.0.30 to production.
We also have such a use-case So when?
Is there any progress with xtrabackup for mysql >= 8.0.30 ? I tried to search for any official anouncement but I’m unable to find it anywere . Thanks in advance
The release notes are available here:
Percona XtraBackup 8.0.30-23 (2022-11-14) - Percona XtraBackup
All good, 8.0.30 works ok with mysql .30 and .31.
However, this thing is not nice Error Message: Found tables with row versions due to INSTANT ADD/DROP columns - Percona XtraBackup
Agreed - this change is unfortunate, but we had to cope with the upstream changes after the fact.
Had same with 8.0.29 after updating nextcloud some days ago. After table optimization everything worked as expected.