… replication while its broken or do the master-master/master-slave switchover when master is dying/dead. Yes, there are wrappers… following aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration of chef with PXC Finally, integration of HAProxy… SSTs with node1 (based on gcomm://node1 of node2) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… how to create a new GTID based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup from any server on the replication environment, master or slave: # innobackupex /destination/ In the destination folder there will be a file with the name xtrabackup_binlog_info: # cat xtrabackup_binlog_info…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…-info option to fail. Bug fixed #1180672. The format of xtrabackup_galera_info was missing the ‘:’ separator between the values of… backing up a server that is not a replication slave with the innobackupex –slave-info option, innobackupex failed with a fatal error… fixed #1177182. Release notes with all the bugfixes for Percona XtraBackup 2.1.2 are available in our online documentation. Bugs…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… be used to create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced… the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp* files in the datadir after applying incremental backups…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not creating xtrabackup_binlog_info file when… it was scanned by XtraBackup on startup and before XtraBackup attempted to copy it. Bug fixed #1079700. Orphaned xtrabackup_pid file left inside…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… be used to create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced… if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. Percona XtraBackup would…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… and bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support… server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not creating xtrabackup_binlog_info file when… output. Bug fixed #1157225. Redundant code has been removed from xtrabackup.cc. Bug fixed #1162765. Other bugs fixed: bug fixed #1158154…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads… and #1086978 (Raghavendra D Prabhu). Donor node would run XtraBackup indefinitely when xtrabackup tmpdir was set up on tmpfs. Bug fixed #1086978…
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
… to the bug https://bugs.launchpad.net/percona-xtrabackup/+bug/945161 while using percona-xtrabackup-2.0.6, so I update this…=192.168.10.118 –user=backup –password=23khfisF –slave-info –no-lock –safe-slave-backup /db/backup/tst_ch118_3/201305″ innodb…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… the appropriate xtrabackup binary. The tests live in dbqp/percona_tests/xtrabackup_basic and are named basic_test.py and slave_test.py, respectively. To run them: $./dbqp.py –suite=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path…
