MySQL and HeatWave

  • August 29, 2013

MySQL Enterprise Backup 3.9.0 – An Insight

Guest Author



MySQL Enterprise Backup team is excited to announce the new release of MySQL Enterprise Backup (MEB) 3.9.0.


MEB 3.9.0 focusses more on the ease of use of the product and addresses some of the challenges faced currently by database administrators.  With growing data the need for hardware for database backups has significantly increased. Keeping that in mind MEB 3.9.0 has extended the product capability to save disk space during backup and restore.  MEB 3.9.0 has also enhanced some of the existing features helping MEB users to perform their tasks in a more user friendly way without much overhead. 

Product Enhancements

 MEB 3.9.0 is a major release with the following valuable features.

·         Single Step Restore

-  Direct restore from backup directory or backup image to the target server

-     The restore process is simple and faster and saves significant disk space

-  This addresses the customer requirement Bug #68390 Enterprise Backup requires 2x disk space of data dir to restore 

Core feature in this release as it gives advantage of both disk space and performance and thus saving resources.


·         Selective Backup and Restore

- MEB 3.9.0 has an improved version to do a selective backup and restore of a single or a subset of tables.

- This is done using TTS (Transportable Table Spaces) and without any need for manual entry of MySQL statements.

- This feature helps in adding the backed up tables onto the same or different online server.

- DBAs would benefit a lot from the ease of use of this command.

·         Full Instance Backup

- This feature helps in providing a complete backup so that the restored server can be run with exactly the same configuration as that of the backed up server.

- This helps the DBAs in easy restoration as most of the server details are backed up and available for the restored server to start.


·         Skip Unused Pages  

- When this feature is enabled MEB skips unused Innodb pages while taking backups. This helps in reduced backup size when there is lot of unused pages in the database.

- This helps in low storage space requirement for the backups taken.


·         Console Output Logging

- MEB errors are now redirected to a log file for every operation by default so that it can be referred later to analyze any issues.

- This relieves DBAs from the overhead of saving the error stream to a file manually or performing the operation again for debugging.



For a detailed overview on the above features please refer 3.9.0 documentation.

MEB 3.9.0 is supported  on Windows, Oracle Enterprise Linux, RHEL 4, 5, SLES 10,11, Solaris 10 Sparc and X86. Solaris 11 Sparc and X86 is also supported in this release.

In a nutshell, MEB 3.9.0 has extended the backup and restore capabilities making life easier for database administrators.

Stay tuned to read more blogs about the new features in the next coming days.


Join the discussion

Comments ( 4 )
  • Valerii Kravchuk Friday, August 30, 2013

    Is there any way to restore just one partition from MEB backup? See http://bugs.mysql.com/bug.php?id=70196 for potential use case.

  • guest Tuesday, September 10, 2013

    InnoDB does not support export/import of individual partitions and hence MEB selective backup does not support it

  • Priya Jayakumar Monday, September 16, 2013

    InnoDB does not support export/import of individual partitions and hence MEB selective backup does not support it

  • guest Thursday, September 4, 2014

    Innodb 5.5 and 5.6 does not support export/import of individual partitions and hence MEB selective backup does not support it

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.