Showing posts with label MEB. Show all posts
Showing posts with label MEB. Show all posts

Mysql Enterprise Backup verison 3.11 New Feature - Optimistic Backup



A quick post.  I have also been looking at MEB 3.11 (we currently use 3.10).  There is a new feature called ‘Optimistic Backup’.  This feature maybe worth considering as it allows you to specify tables (or a time) that most tables were not changed during the backup, it will then not backup any redo, undo or system data.  This will reduce the apply time. 

So if you have a database backup that is heavy on apply this maybe worth considering.

MySQL Enterprise Backup, Using Incrementals

As an experiment I have been testing MySQL Enterprise Backuip (MEB) and incremental backups. 

MySQL Enterprise Backup (MEB) Compress Option

I have used compression tools before and was interested to understand a little more about MEB's use of compression.  Jumping straight in, here are a couple of points to consider:
  • the backup compression feature only applies to InnoDB tables.  
  • when InnoDB tablespace files are compressed during backup, they receive the extension .ibz rather than the usual .ibd extension.  
  • you can only use the --compress option for full backups, not for incremental backups.

MySQL Enterprise Backup (MEB) 3.8 and Parallel Performance


I am currently looking at the newest version of MEB.  I have some experience of 3.7 and was keen to experiment the new version


MySQL Enterprise Backup (MEB) 3.7 - Backup and Restore Examples

I have been working with MEB and put a few examples of working with MEB on-line.  It's not a comprehensive list of everything MEB does but hopefully will be enough to get things started.  For a more comprehensive information please see the documentation.
http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/index.html