how to integrate databases?

MySQL & MariaDB Percona XtraBackup
1

hello everyone.

we have several mysql DB. And we have the plan that integrates each DB with mariadb galera.
And we will integrate db one at a time.

But I don’t know that how to integrate db using XtraBackup in progressively.
I have used XtraBackup at a single instance(database).

only method is mysqldump?

2

Hi,

what storage engine you are using for all those databases? and in which MariaDB galera version you want integrate those all?
If its innodb and you are using InnoDB_file_per_table then with 5.6, you can also import individual tables.
[url]Percona XtraBackup