Solved

Slow mySQL Restores

  • 29 November 2021
  • 1 reply
  • 34 views

Userlevel 2
Badge +6
  • Commvault Certified Expert
  • 18 replies

Hi, 

What would be the best way to move forward with a mySQL backup/restore when the traditional backup/restore have slow performance?  Backup is decent but restore of a few GB in a single table takes hours to complete. 
So, with restore performance in mind, would it be best to update the license model to enable Enterprise SBT-bases backups? Or would a block-based backup be the best way to go? 

/Patrik

icon

Best answer by Sunil 29 November 2021, 17:25

View original

1 reply

Userlevel 4
Badge +7

Hi @Patrik 

The problem with restoring tables from dump based backup is that, even if you need only a few tables we will first have to restore the entire DB dump and then import the tables you need from that database.

Block level restore would minimize the amount of data needs to be restored by restoring only the blocks needed. You can give it a try.

 

Thanks,

Sunil

 

Reply