Tag Archives: Transportable Tablespace

–use-tts backup & restore

Posted on 06/02/2014 by Keith Hollman

In addition to my recent post, I just had to go into using the –use-tts for specific tables and selective backup sets. As all my schemas were employeesn, I thought it would be a good idea to run: mysqlbackup -uroot … Continue reading →

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, Recovery | Tagged , , , , , , , , | Leave a comment

MySQL Enterprise Backup: parallel config & backup n restore results.

Posted on 06/02/2014 by Keith Hollman

In this post I go into some performance metrics and time spent on using MySQL Enterprise Backup instead of mysqldump, and seeing how far I could go with some parallel configuration.

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, Recovery | Tagged , , , , , , , , , , | Leave a comment

MySQL Enterprise Backup: PITR Partial Online Recovery

Posted on 18/09/2013 by Keith Hollman

Here’s a look at using MySQL Enterprise Backup in a specific example: Consider a Backup Policy – Full Backup of the environment. – Complemental Incremental backups & online BinLogs. And the Restore: – Logical Restore. – Online, Zero impact. – … Continue reading →

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle, Oracle Linux, PITR, Recovery | Tagged , , , , , , , | 1 Comment