Tag Archives: MEB
InnoDB Cluster: Recovering an instance with MySQL Enterprise Backup.
Ok, so if you’re reading this, then I can guess you’ve got a MySQL InnoDB Cluster in an awkard shape, i.e. you need to restore a backup and add the instance back into the cluster, so we have all our instances again. Continue reading
Posted in Backup, innodb cluster, MEB, MySQL 8, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle Linux, Recovery, Replication, Uncategorized Tagged enterprise backup, innodb cluster, instance restore, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, mysql innodb cluster, mysqlbackup, Recovery 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
–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 --use-tts, backup, backup performance, enterprise backup, MEB, MySQL, mysqlbackup, Transportable Tablespace, TTS 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 backup, backup performance, MEB, MySQL, mysqlbackup, partial recovery, recovery times, restore, Transportable Tablespace, TTS, Utilities Leave a comment