First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the bottom of the list, as this is very hard to implement properly. The idea by [...]
Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the purposes of this example: We have 2 Servers in a Master-Slave topology. [...]
Hint: throttling xtrabackup
May 20, 2009 By Leave a Comment
Using xtrabackup for copying files can really saturate your disks, and that why we made special option
1 | --throttle=rate |
to limit rate of IO per second. But it really works when you do local copy. What about stream backup ? Even you copy just to remote box with
1 | innobackupex --stream=tar | ssh remotebox "tar xfi -" |
, read may be so intensive so [...]
Btw xtrabackup is not only backup..
May 7, 2009 By 13 Comments
It is obvious thing for me, but I just figured out it may be not common understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done in almost non-blocking way [...]
