Can Mariabackup import from a Percona Xtrabackup backup?
Hi, We have a Maria DB 5.5 replica set running on Centos 7. With this OS version about to become end of life, we are planning an upgrade of our replica set to RHEL 9 and Maria DB 10.5. My general plan is to add a new replica secondary to the mix, running Maria DB 10.5 and then promote that server to be primary and replace the other replica members with a new secondary that is also running Maria DB 10.5. My question is, since Mariabackup didn't exist in Maria DB 5.5, is it possible to backup our existing Maria databases with Percona Xtrabackup and then have Mariabackup (from Maria DB 10.5) import that backup on the new server? Thanks, Bryan
Hi Bryan, 10.5 has only a year of maintenance to go - https://mariadb.org/about/#maintenance-policy With your infrequent updates wouldn't 10.11 be a better fit? The crash safety during table alterations of 10.6 at least is a good feature to have. On the mechanism itself, sounds like a good plan to me. You should always do the --prepare from the version you backed up with, in this case Percona Xtrabackup. After this is done the datadir can be used directly by MariaDB 10.5. No MariaDB-backup intervention is needed. You may want to use MariaDB-backup to create the replicas from the promoted 10.5 primary. On Fri, 7 Jun 2024 at 04:29, Bryan K. Walton via discuss <discuss@lists.mariadb.org> wrote:
Hi,
We have a Maria DB 5.5 replica set running on Centos 7. With this OS version about to become end of life, we are planning an upgrade of our replica set to RHEL 9 and Maria DB 10.5.
My general plan is to add a new replica secondary to the mix, running Maria DB 10.5 and then promote that server to be primary and replace the other replica members with a new secondary that is also running Maria DB 10.5.
My question is, since Mariabackup didn't exist in Maria DB 5.5, is it possible to backup our existing Maria databases with Percona Xtrabackup and then have Mariabackup (from Maria DB 10.5) import that backup on the new server?
Thanks, Bryan _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
participants (2)
-
Bryan K. Walton
-
Daniel Black