… time by syncing the frm files. Enable –slave-info when backing up from a slave so you know what the position you… typically 3x-5x smaller vs compressed xtrabackup Typically we upload mydumper backups to s3 vs xtrabackup given the time needed to upload… Strategies on retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and sysbench on the client node. # yum -y… 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…
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
…, and it is quite easy to add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is… big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge reception of a network packet (not… during this period. I believe that, with integration with Percona XtraBackup and its incremental backup features, it is possible to have…
Comment: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
January 13, 2010 By 20 Comments
… throws error xtrabackup –backup –user=root –password=test \ –no-defaults \ –slave-info \ –datadir=/data/comdb-slave/mysql/datafiles/ \ –socket=/data/comdb-slave/var/run… root 178688 Jan 13 18:39 xtrabackup_logfile Not sure why this is happening. The slave is good and replicating data from…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
… mktemp error. Bug fixed #1080829 (Alex Yurchenko). XtraBackup donor would run XtraBackup indefinitely if the xtrabackup –tmpdir was on tmpfs. Bug fixed #1086978 (Alex Yurchenko). In some cases non-uniform foreign key reference could cause a slave…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…deployments Support of Percona XtraBackup for Snapshot State Transfer. This feature is available in pre-release series for XtraBackup 2.0 …“parallel replication”. Automatic node provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or …
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… on all nodes or not commited at all. Forget about slaves being out-of-sync with master. 3. Nodes are able… to Cluster. No manual cloning of slave and copying to new box. Using Percona XtraBackup as transport to transfer data between nodes…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to … Xtrabackup. Many other tools have similar option. This option can be especially helpful when backing up data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… Percona Server is great help in this case. Changing Slave Role Changing Slave role, such as swapping active and passive masters in… 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…
