… one table with size 13Gb what was filled during about 2.5 years. The table is: CREATE TABLE `link_out104` ( `domain_id…-r–r– 1 root root 13832814592 Sep 10 14:41 link_out104.ibd So to get statistics we run: xtrabackup –stats –tables… factor should be quite good. To check that, there is xtrabackup –stats for index domain_id created for table in Barracuda…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
Playing with last version of xtrabackup and compress it I noticed that gzip is unacceptable slow … that support it and different level of compression ( 1,2,3 for qpress; -1 and -5 for other tools) The raw results are available… ration, but speed is impressive, and maybe we will ship xtrabackup with this compression LZO is even faster in decompression than…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 13 Comments
…1.5.1: Waiting for ibbackup (pid=7630) to suspend innobackupex-1.5.1: Suspend file ‘/var/lib/mysql/xtrabackup_suspended’ xtrabackup: suspend-at-end is enabled. xtrabackup…
Comment: xtrabackup-0.3, binaries and stream backup
March 20, 2009 By 11 Comments
…= /var/lib/mysql … #>innobackupex-1.5.1 –databases=saturn –user=root –password=******* –slave-info /tmp InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase…1558149409) 090321 0:41:00 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the …
Post: Percona Server and XtraBackup for MacOS – experimental binaries
May 2, 2011 By 9 Comments
… 5.5 : http://www.percona.com/downloads/TESTING/Percona-Server-55/Percona-Server-5.5.11-20.2/release-5.5.11-20.2/114/MacOSX/ Percona Server 5.1…/Percona-Server-5.1.56-12.7/release-5.1.56-12.7/226/MacOSX/ Percona XtraBackup: http://www.percona.com/downloads/TESTING/XtraBackup-MacOSX/ Please…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… MySQL 5.6 integration with Percona Software. Percona Toolkit 2.1 already supports MySQL 5.6. Improved support is coming in Percona Toolkit 2.2 which… Plugins are also MySQL 5.6 compatible. Percona Xtrabackup support for MySQL 5.6 is coming next month with Percona Xtrabackup 2.0.6. Though…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…XtraBackup for Snapshot State Transfer. This feature is available in pre-release series for XtraBackup 2.0 Despite Galera 2…binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. … XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or …, `CityName` varchar(100) DEFAULT NULL, `State` char(2) DEFAULT NULL, `StateFips` varchar(10) DEFAULT NULL, `…-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup=1…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
…5.5.15 ? First of course, Percona Server+Galera is based on our XtraDB engine. Second, we provide wsrep_sst_xtrabackup…I want to highlight some points again. 1. It is new High Availability + Scalability …master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
….mysql.com/doc/refman/5.6/en/replication-gtids…+—————+——————————————+ | gtid_purged | 9a511b7b-7059-11e2-9a24-08002762b8af:1-2 | +—————+——————————————+ Now we take a…purged are our new friends. Xtrabackup still doesn’t support…
