… snapshot and compare to original state Slave setup Similar to our basic test except we create a slave from the backup, replicating from… both xtrabackup and the server, enhancing / expanding replication tests by creating heavy randgen loads against the master during backup and slave setup, and…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…in traditional master-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge reception…during this period. I believe that, with integration with Percona XtraBackup and its incremental backup features, it is possible to have…
Post: Btw xtrabackup is not only backup..
May 7, 2009 By 12 Comments
… 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 ( true for InnoDB setups) for cloned server. Here is command innobackupex-1.5.1 –stream=tar /tmp/ –slave-info | ssh user…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
… XtraDB engine. Second, we provide wsrep_sst_xtrabackup script, which allows to use Percona XtraBackup for node provisioning. Percona Server+Galera is… reads and writes). You can perform writes to ANY node. Setup of 3-master active MySQL Replication is practically impossible. 2… to Cluster. No manual cloning of slave and copying to new box. Using Percona XtraBackup as transport to transfer data between nodes…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… Codership is going to support LVM snapshot and xtrabackup which will make the setup of new node even easier. The current annoyance… it will provide 
, but efforts on test setup and deployment should be comparable with MMM setup. – Scale Writes. Galera allows to write… in the same state, there is no “slave behind”. When you read from any slave, you read actual data. Although it also…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… this case. Changing Slave Role Changing Slave role, such as swapping active and passive masters in Master-Master setup is often cause of… hours until they all could be done with. Slave Read Traffic Changes Slave read traffic impacts replication performance dramatically and even if… take many forms. It can be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
….75) = 19h48m). If you wanted to do something like setup a new slave with a 24-hour old backup, and apply the… the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs… be lessened by a MySQL Server feature – parallel execution on slaves. Lets hope that it can get enough testers so…
Comment: Global Transaction ID and other patches available!
May 15, 2009 By 9 Comments
We use this primarily to do slave clones….. I saw your note about xtrabackup doing clones but I have not yet had a chance to look at it. Our current setup works 
