Category Archives: MySQL Enterprise Backup

InnoDB Cluster: setting up Production… for disaster! (2/2)

Ok, so now we’re got our InnoDB Cluster a-clustering, MySQL Router a-routing, now we need some disaster to be a-disaster-recovering… Continue reading

Advertisements
Posted in Backup, InnoDB, innodb cluster, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, numactl, Oracle Linux, PITR, Recovery, Replication | Tagged , , , , , , | Leave a comment

InnoDB Cluster: setting up Production… for disaster! (1/2)

Want to setup InnoDB Cluster and be prepared for a Disaster Recovery scenario? Get ready: Here’s a way to set up InnoDB Cluster using the 3 environments, on Oracle Linux 7.2, 5.7.19 MySQL Commercial Server, MySQL Shell 8.0.3 DMR, MySQL … Continue reading

Posted in Backup, InnoDB, innodb cluster, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, numactl, Oracle, PITR, Recovery | Tagged , , , , , , , , , , , | Leave a comment

MySQL Enterprise Backup 3.10: Teasing compression.

Ok, so I wanted to look into the new compression options of MEB 3.10. And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your … Continue reading

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle, Recovery | Tagged , , , , , , , , , , , , | 2 Comments

–use-tts backup & restore

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.

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

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