… 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…_sst_xtrabackup in 5.5.30 can’t do those except parallel, the one in 5.5.31 will handle them all, also XB 2.1…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying the dirty tablespace files while…_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex… I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that come to…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… with the name xtrabackup_binlog_info: # cat xtrabackup_binlog_info mysql-bin.000002 1232 c777888a-b6df-11e2-a604-080027635ef5:1-4 Now it… MASTER TO MASTER_HOST=”10.0.1.1“, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
…-xtrabackup-2.0.6/bin/xtrabackup lrwxrwxrwx root/root 0 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/innobackupex-1.5.1 -> innobackupex drwxr-xr-x root/root 0 2013-03-19 17:29:38 percona-xtrabackup….* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2.* – xtrabackup # MariaDB 5.3.* – xtrabackup # Percona Server 5.0 – xtrabackup_51 # Percona Server 5.1 – xtrabackup # Percona Server 5.5 – xtrabackup…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from… new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented…. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5.6. This option can be used to produce 5.6-style…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup. After being deprecated in previous version, option –remote-host has been completely removed in Percona XtraBackup 2.1. Percona XtraBackup can…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
Percona is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL beta on April 22, 2013. Downloads are… XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0. Basic support means that these versions are are recognized by XtraBackup, and…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL. After being deprecated in previous version, option –remote-host has been completely removed in Percona XtraBackup for MySQL 2.1…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 18, 2013. Downloads are available… did not work correctly for latest Percona Server and MySQL 5.1 releases which could cause innobackupex to fail. Bugs fixed #1181092… #1177182. Release notes with all the bugfixes for Percona XtraBackup 2.1.2 are available in our online documentation. Bugs can be…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… and MariaDB. MySQL 5.5 replaced MySQL 5.4 as next planned GA release. Percona releases GA version of Percona Xtrabackup – open source alternative to Innodb Hot backup. MySQL 5.1.46 is GA and MySQL 5.5.4 is not…
