Backup whole mysql instance using xtrabackup

Question

Hi,Doing some testing around mysql protection. Do we have an option to backup whole mysql instance using xtrabackup. Default configuration do :for all discovered databases; do xtrybackup ...[]  --databases dbname; doneIt would be nice to have an option to protect whole instance at once. In case of lots of databases under instance iterating by each database can be time consuming. Thanks.

Sudheer · Accepted Answer

Currently we don’t have the xtrabackup to backup all the databases in MySQL server.We are have it in our Road Map, to support full instance backup using xtrabackup.

lborek · Answer

Currently we don’t have the xtrabackup to backup all the databases in MySQL server.
We are have it in our Road Map, to support full instance backup using xtrabackup.

Thanks. When it will be available?

Backup per database, when there is more than one database, generates space overhead and give pore performance. Full instance protection sounds like easy solution.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded