I am attempting to backup my MySQL server running MariaDB 10.6.18 using Percona

MySQL & MariaDB Percona XtraBackup
1

I am attempting to backup my MySQL server running MariaDB 10.6.18 using Percona XtraBackup. However, during the backup process, I encounter the following error:

2024-07-09T17:39:44.067790+09:00 0 [ERROR] [MY-011825] [Xtrabackup] Unsupported server version: ‘10.6.18-MariaDB-0ubuntu0.22.04.1’
2024-07-09T17:39:44.067802+09: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
2024-07-09T17:39:44.067810+09:00 0 [Note] [MY-011825] [Xtrabackup] Please use Percona XtraBackup 2.4 for this database.

I am currently using Percona XtraBackup version 8.0.35-31, which seems incompatible with MariaDB 10.6.18. Could you please advise on the recommended approach to resolve this issue or suggest any alternative solutions? Thank you.

2

Hi there,

Please have a look on Mariabackup Overview - MariaDB Knowledge Base
MariaBackup was forked from Percona Xtrabackup and this is MariaDB’s solution to take backups.

I hope that will help.
Thanks,
Tibi

3

Hello @hong,
To expand on what Tibor said, MariaDB uses a different on-disk structure for certain aspects of InnoDB. It was decided years ago that PXB would not continue supporting this odd fork. If you want to backup MariaDB, you need to use their tool since they diverged from everyone else.

If you want to migrate to Percona MySQL, you should do a logical dump/import using GitHub - mydumper/mydumper: Official MyDumper Project