Solved

Backup whole mysql instance using xtrabackup

  • 24 February 2021
  • 2 replies
  • 286 views

Userlevel 2
Badge +7

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; done

It 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. 

icon

Best answer by Sudheer 24 February 2021, 11:39

View original

2 replies

Badge +1

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.  

Userlevel 2
Badge +7

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. 

Reply