… replication while its broken or do the master-master/master-slave switchover when master is dying/dead. Yes, there are wrappers… a HA setup is simple and uncomplicated. Their post focuses on following aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… both xtrabackup and the server, enhancing / expanding replication tests by creating heavy randgen loads against the master during backup and slave setup, and…_test.py and slave_test.py, respectively. To run them: $./dbqp.py –suite=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path…
Post: Btw xtrabackup is not only backup..
May 7, 2009 By 13 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 XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…: How would you migrate to XtradbCluster from a traditional Master Slave scenario when the data set is very large? Can you… to use it? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is backed up by the wrapper script called innobackupex, and not xtrabackup itself while holding…
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: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… wsrep_slave_threads=2 wsrep_cluster_name=pxctest wsrep_sst_method=xtrabackup wsrep_node_name=ip-10-112-39-98 log_slave_updates…:20:19 [Note] WSREP: Prepared SST request: xtrabackup|10.195.206.117:4444/xtrabackup_sst 120619 13:20:19 [Note] WSREP: wsrep… some iptables magic for the backwards connections. However in the setup described in this post this is not an issue, since…
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 15 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 9 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…
