Merge lp:~hrvojem/percona-xtrabackup/doc-48-2.1 into lp:percona-xtrabackup/2.1

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Alexey Kopytov
Approved revision: no longer in the source branch.
Merged at revision: 635
Proposed branch: lp:~hrvojem/percona-xtrabackup/doc-48-2.1
Merge into: lp:percona-xtrabackup/2.1
Diff against target: 122 lines (+62/-6)
5 files modified
doc/source/howtos/recipes_ibkx_compressed.rst (+1/-1)
doc/source/howtos/recipes_ibkx_partition.rst (+44/-0)
doc/source/innobackupex/parallel_copy_ibk.rst (+15/-3)
doc/source/innobackupex/streaming_backups_innobackupex.rst (+1/-1)
doc/source/percona-theme/layout.html (+1/-1)
To merge this branch: bzr merge lp:~hrvojem/percona-xtrabackup/doc-48-2.1
Reviewer Review Type Date Requested Status
Alexey Kopytov (community) Approve
Review via email: mp+176405@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) wrote :

Same comments as in the 2.0 MP.

review: Needs Fixing
Revision history for this message
Alexey Kopytov (akopytov) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/howtos/recipes_ibkx_compressed.rst'
2--- doc/source/howtos/recipes_ibkx_compressed.rst 2012-06-04 10:29:26 +0000
3+++ doc/source/howtos/recipes_ibkx_compressed.rst 2013-07-24 09:37:32 +0000
4@@ -24,7 +24,7 @@
5 Preparing the backup
6 --------------------
7
8-Before you can prepare the backup you'll need to uncompress all the files with `qpress <http://www.quicklz.com/>`_. You can use following one-liner to uncompress all the files: ::
9+Before you can prepare the backup you'll need to uncompress all the files with `qpress <http://www.quicklz.com/>`_ (which is available from `Percona Software repositories <http://www.percona.com/doc/percona-xtrabackup/2.1/installation.html#using-percona-software-repositories>`_). You can use following one-liner to uncompress all the files: ::
10
11 $ for bf in `find . -iname "*\.qp"`; do qpress -d $bf $(dirname $bf) && rm $bf; done
12
13
14=== modified file 'doc/source/howtos/recipes_ibkx_partition.rst'
15--- doc/source/howtos/recipes_ibkx_partition.rst 2012-09-19 11:35:43 +0000
16+++ doc/source/howtos/recipes_ibkx_partition.rst 2013-07-24 09:37:32 +0000
17@@ -103,3 +103,47 @@
18
19 mysql> ALTER TABLE name_p4 IMPORT TABLESPACE;
20
21+Restoring from the backups in version 5.6
22+-----------------------------------------
23+
24+The problem with server versions up to 5.5 is that there is no server support to import either individual partitions or all partitions of a partitioned table, so partitions could only be imported as independent tables. In |MySQL| and |Percona Server| 5.6 it is possible to exchange individual partitions with independent tables through ``ALTER TABLE`` ... ``EXCHANGE PARTITION`` command.
25+
26+.. note::
27+
28+ In |Percona Server| 5.6 variable :option:`innodb_import_table_from_xtrabackup` has been removed in favor of |MySQL| `Transportable Tablespaces <http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html>`_ implementation.
29+
30+When importing an entire partitioned table, first import all (sub)partitions as independent tables: ::
31+
32+ mysql> CREATE TABLE `name_p4` (
33+ `id` int(11) NOT NULL AUTO_INCREMENT,
34+ `name` text NOT NULL,
35+ `imdb_index` varchar(12) DEFAULT NULL,
36+ `imdb_id` int(11) DEFAULT NULL,
37+ `name_pcode_cf` varchar(5) DEFAULT NULL,
38+ `name_pcode_nf` varchar(5) DEFAULT NULL,
39+ `surname_pcode` varchar(5) DEFAULT NULL,
40+ PRIMARY KEY (`id`)
41+ ) ENGINE=InnoDB AUTO_INCREMENT=2812744 DEFAULT CHARSET=utf8
42+
43+To restore the partition from the backup tablespace needs to be discarded for that table: ::
44+
45+ mysql> ALTER TABLE name_p4 DISCARD TABLESPACE;
46+
47+Next step is to copy the ``.cfg`` and ``.ibd`` files from the backup to |MySQL| data directory: ::
48+
49+ $ cp /mnt/backup/2013-07-18_10-29-09/imdb/name#P#p4.cfg /var/lib/mysql/imdb/name_p4.cfg
50+ $ cp /mnt/backup/2013-07-18_10-29-09/imdb/name#P#p4.ibd /var/lib/mysql/imdb/name_p4.ibd
51+
52+Last step is to import the tablespace: ::
53+
54+ mysql> ALTER TABLE name_p4 IMPORT TABLESPACE;
55+
56+We can now create the empty partitioned table with exactly the same schema as the table being imported: ::
57+
58+ mysql> CREATE TABLE name2 LIKE name;
59+
60+Then swap empty partitions from the newly created table with individual tables corresponding to partitions that have been exported/imported on the previous steps ::
61+
62+ mysql> ALTER TABLE name2 EXCHANGE PARTITION p4 WITH TABLE name_p4;
63+
64+In order for this operation to be successful `following conditions <http://dev.mysql.com/doc/refman/5.6/en/partitioning-management-exchange.html>`_ have to be met.
65
66=== modified file 'doc/source/innobackupex/parallel_copy_ibk.rst'
67--- doc/source/innobackupex/parallel_copy_ibk.rst 2013-04-29 09:29:00 +0000
68+++ doc/source/innobackupex/parallel_copy_ibk.rst 2013-07-24 09:37:32 +0000
69@@ -1,8 +1,11 @@
70 .. _parallel-ibk:
71
72-=====================================================================
73- Accelerating with :option:`--parallel` copy and `--compress-threads`
74-=====================================================================
75+=================================
76+ Accelerating the backup process
77+=================================
78+
79+Accelerating with :option:`--parallel` copy and `--compress-threads`
80+--------------------------------------------------------------------
81
82 When performing a local backup or the streaming backup with |xbstream| option, multiple files can be copied concurrently by using the :option:`--parallel` option. This option specifies the number of threads created by |xtrabackup| to copy data files.
83
84@@ -25,3 +28,12 @@
85
86 Before applying logs, compressed files will need to be uncompressed.
87
88+Accelerating with :option:`--rsync` option
89+------------------------------------------
90+
91+In order to speed up the backup process and to minimize the time ``FLUSH TABLES WITH READ LOCK`` is blocking the writes, option :option:`innobackupex --rsync` should be used. When this option is specified, |innobackupex| uses ``rsync`` to copy all non-InnoDB files instead of spawning a separate ``cp`` for each file, which can be much faster for servers with a large number of databases or tables. |innobackupex| will call the ``rsync`` twice, once before the ``FLUSH TABLES WITH READ LOCK`` and once during to minimize the time the read lock is being held. During the second ``rsync`` call, it will only synchronize the changes to non-transactional data (if any) since the first call performed before the ``FLUSH TABLES WITH READ LOCK``.
92+
93+.. note::
94+
95+ This option cannot be used together with :option:`innobackupex --remote-host` or :option:`innobackupex --stream` options.
96+
97
98=== modified file 'doc/source/innobackupex/streaming_backups_innobackupex.rst'
99--- doc/source/innobackupex/streaming_backups_innobackupex.rst 2013-04-29 09:29:00 +0000
100+++ doc/source/innobackupex/streaming_backups_innobackupex.rst 2013-07-24 09:37:32 +0000
101@@ -12,7 +12,7 @@
102
103 |innobackupex| starts |xtrabackup| in :option:`--log-stream` mode in a child process, and redirects its log to a temporary file. It then uses |xbstream| to stream all of the data files to ``STDOUT``, in a special ``xbstream`` format. See :doc:`../xbstream/xbstream` for details. After it finishes streaming all of the data files to ``STDOUT``, it stops xtrabackup and streams the saved log file too.
104
105-When compression is enabled, |xtrabackup| compresses all output data, including the transaction log file and meta data files, using the specified compression algorithm. The only currently supported algorithm is 'quicklz'. The resulting files have the qpress archive format, i.e. every \*.qp file produced by xtrabackup is essentially a one-file qpress archive and can be extracted and uncompressed by the `qpress file archiver <http://www.quicklz.com/>`_. New algorithms (gzip, bzip2, etc.) may be added later with minor efforts.
106+When compression is enabled, |xtrabackup| compresses all output data, including the transaction log file and meta data files, using the specified compression algorithm. The only currently supported algorithm is 'quicklz'. The resulting files have the qpress archive format, i.e. every \*.qp file produced by xtrabackup is essentially a one-file qpress archive and can be extracted and uncompressed by the `qpress file archiver <http://www.quicklz.com/>`_ which is available from `Percona Software repositories <http://www.percona.com/doc/percona-xtrabackup/2.1/installation.html#using-percona-software-repositories>`_. New algorithms (gzip, bzip2, etc.) may be added later with minor efforts.
107
108 Using |xbstream| as a stream option, backups can be copied and compressed in parallel which can significantly speed up the backup process.
109
110
111=== modified file 'doc/source/percona-theme/layout.html'
112--- doc/source/percona-theme/layout.html 2013-05-22 11:21:52 +0000
113+++ doc/source/percona-theme/layout.html 2013-07-24 09:37:32 +0000
114@@ -78,7 +78,7 @@
115
116 <div class="side-column-block">
117 <div class="a-btn-container">
118- <a title="Download PDF Manual for Percona XtraBackup 2.1" href="http://form.percona.com/PerconaXtraBackup2.1.2OperationsManual--5.20.13.html" class="a-btn-new">
119+ <a title="Download PDF Manual for Percona XtraBackup 2.1" href="http://form.percona.com/PerconaXtraBackup2.1SeriesOperationsManual--5.24.13.html" class="a-btn-new">
120 <span class="a-btn-text">Download Manual</span>
121 <span class="a-btn-fixed-slide-text">PDF for version 2.1</span>
122 <span class="a-btn-icon-right"><span></span></span>

Subscribers

People subscribed via source and target branches