Category Archives: backup

MySQL Online Backup with xtrabackup

My last post about backups was a while ago. Although it is still valid, it’s not advisable to use it as daily backup. For that we can use XtraBackup. With XtraBackup, you can take online backups without interrupt the server … Continue reading


Liked? Help and Share!
Posted in backup, MySQL | Leave a comment

MySQL Backup Strategy – Slides

Hi there, it’s been a few months since Percona Live London has finished, but I managed just now to get sometime to post the slides from my presentation about backups. Please, take a look and feel free to comment. Pdf … Continue reading


Liked? Help and Share!
Posted in backup, MySQL, Security | Leave a comment

MySQL 5.6 Replication with GTID – Global Transaction ID

Hi guys, Early February Oracle released the new version of MySQL named 5.6, one of the enhancements is the GTID (Global Transaction ID) GTID is an unique identifier which will be added at each transaction, and will be very useful … Continue reading


Liked? Help and Share!
Posted in backup, binlog, install, replication | 2 Comments

Consistent backup – snapshot

Hi guys, today let’s learn about how to have a consistent backup (snapshot) First of all, in what situations do we use a snapshot? 1. Lets say that your production server now will have a replica, how do you do … Continue reading


Liked? Help and Share!
Posted in backup | 2 Comments