… recover a single table # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export… with the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i…: Import: 9 indexes have been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…coming weeks. Major features include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ plugin Log …was released last year), there have been over 3,500 commits to Drizzle from around 50 contributors… small amounts of code. Installing Drizzle 7.1.33-stable The source tar package is …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 25, 2012 By 20 Comments
… friends, for percona xtrabackup, i think there are three problems which forced us using FLUSH TABLES WITH READ LOCK. 1. copy meta… a hot backup without using FLUSH TABLES WITH READ LOCK: 1. do not do any ddl operations in the progress of… our engine, no other engines used. 3. get binlog file and binlog postion information from xtrabackup_binlog_pos_innodb file since InnoDB…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…1 | | 10291 | root | localhost | dumptest | Query | 0 | NULL | show processlist | 0 | 0 | 2 | +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ 3… option with Percona Xtrabackup. Many other tools…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…| | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row in set (1.73 …for the duration of operation. You can also use Percona Xtrabackup, LVM or other database backup approach which does not …
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
Percona is glad to announce the release of Percona XtraBackup 1.6.3 on 22 September, 2011 (Downloads are available here and from… tables are executed while taking a backup, an upgrade to XtraBackup 1.6.3 is strongly recommended. Under this scenario, if the server…_file_per_table option is being used, an upgrade to XtraBackup 1.6.3 isstrongly recommended. Under this scenario, if the server version…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… two often asked question about xtrabackup: 1) Does it work only with XtraDB or with InnoDB also ? A: xtrabackup is designed to work… of xtrabackup from source code. If you are not comfortable with building from source we provide the binaries for xtrabackup-0.3 New version of xtrabackup contains the feature which is missed in InnoDB…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…’) NOT NULL, `url_title` varchar(255) NOT NULL, `isexternal` tinyint(3) unsigned NOT NULL, `revert_domain` varchar(255) NOT NULL, `url…-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: 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 … tools that support it and different level of compression ( 1,2,3 for qpress; -1 and -5 for other tools) The raw results… ration, but speed is impressive, and maybe we will ship xtrabackup with this compression LZO is even faster in decompression than…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 18 Comments
… the Percona XtraDB Cluster. 1. The Cluster consists of Nodes. Recommended configuration is to have at least 3 nodes, but you can… SST available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup with support of XtraDB Cluster will be released soon, so… to another (SST applies FLUSH TABLES WITH READ LOCK command). Xtrabackup SST does not require READ LOCK for full time, only…
