Merge lp:~hrvojem/percona-xtrabackup/rn-2.0.7-2.0 into lp:percona-xtrabackup/2.0

Proposed by Hrvoje Matijakovic on 2013-05-06
Status: Merged
Approved by: Alexey Kopytov on 2013-05-06
Approved revision: no longer in the source branch.
Merged at revision: 555
Proposed branch: lp:~hrvojem/percona-xtrabackup/rn-2.0.7-2.0
Merge into: lp:percona-xtrabackup/2.0
Diff against target: 156 lines (+81/-7)
4 files modified
doc/source/conf.py (+4/-2)
doc/source/installation/apt_repo.rst (+2/-0)
doc/source/release-notes/2.0/2.0.7.rst (+63/-0)
doc/source/xtrabackup_bin/exporting_importing_tables.rst (+12/-5)
To merge this branch: bzr merge lp:~hrvojem/percona-xtrabackup/rn-2.0.7-2.0
Reviewer Review Type Date Requested Status
Alexey Kopytov (community) 2013-05-06 Approve on 2013-05-06
Review via email: mp+162585@code.launchpad.net
To post a comment you must log in.
Alexey Kopytov (akopytov) wrote :

Approved with one minor comment:

> On the destination server running |Percona Server| with |XtraDB| or |MySQL| 5.6, with :term:`innodb_expand_import` enabled

This sounds like innodb_expand_import must be enabled on MySQL 5.6 as well. Needs to be rephrased to make clear only XtraDB requires that option.

review: Approve
550. By Hrvoje Matijakovic on 2013-05-06

- XtraBackup 2.0.7 release notes

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/conf.py'
2--- doc/source/conf.py 2013-03-20 06:09:32 +0000
3+++ doc/source/conf.py 2013-05-06 13:57:23 +0000
4@@ -51,9 +51,9 @@
5 # built documents.
6 #
7 # The short X.Y version.
8-version = '2.0.6'
9+version = '2.0.7'
10 # The full version, including alpha/beta/rc tags.
11-release = '2.0.6'
12+release = '2.0.7'
13
14 # The language for content autogenerated by Sphinx. Refer to documentation
15 # for a list of supported languages.
16@@ -108,6 +108,8 @@
17
18 .. |XtraBackup| replace:: *XtraBackup*
19
20+.. |Percona XtraBackup| replace:: *Percona XtraBackup*
21+
22 .. |Percona Server| replace:: *Percona Server*
23
24 .. |Percona| replace:: *Percona*
25
26=== modified file 'doc/source/installation/apt_repo.rst'
27--- doc/source/installation/apt_repo.rst 2013-04-30 07:33:04 +0000
28+++ doc/source/installation/apt_repo.rst 2013-05-06 13:57:23 +0000
29@@ -28,6 +28,7 @@
30 ------
31
32 * 6.0 (squeeze)
33+ * 7.0 (wheezy)
34
35 Ubuntu
36 ------
37@@ -35,6 +36,7 @@
38 * 10.04LTS (lucid)
39 * 12.04LTS (precise)
40 * 12.10 (quantal)
41+ * 13.04 (raring)
42
43 Experimental Repository
44 =======================
45
46=== added file 'doc/source/release-notes/2.0/2.0.7.rst'
47--- doc/source/release-notes/2.0/2.0.7.rst 1970-01-01 00:00:00 +0000
48+++ doc/source/release-notes/2.0/2.0.7.rst 2013-05-06 13:57:23 +0000
49@@ -0,0 +1,63 @@
50+============================
51+|Percona| |XtraBackup| 2.0.7
52+============================
53+
54+Percona is glad to announce the release of Percona XtraBackup 2.0.7 on May 6, 2013. Downloads are available from our download site `here <http://www.percona.com/downloads/XtraBackup/XtraBackup-2.0.7/>`_ and :doc:`Percona Software Repositories </installation>`.
55+
56+This release is the current GA (Generally Available) stable release in the 2.0 series.
57+
58+New Features
59+=============
60+
61+ This version of |Percona XtraBackup| has implemented full support for new |MySQL| 5.6 features (``GTID``, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files).
62+
63+ |Percona XtraBackup| has implemented support for the `InnoDB Buffer Pool Preloading <http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html#innodb-preload-buffer-pool>`_ introduced in |MySQL| 5.6. Starting with |MySQL| 5.6 buffer pool dumps can be produced and loaded for faster server warmup after the start. This feature is similar to the `Dump/Restore of the Buffer Pool <http://www.percona.com/doc/percona-server/5.5/management/innodb_lru_dump_restore.html>`_ in |Percona Server|. |MySQL| 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup is restored buffer pool dump can be loaded by the server either automatically on startup or on demand.
64+
65+ Time interval between checks done by log copying thread is now configurable by :option:`innobackupex --log-copy-interval`. Making the interval configurable allows to reduce the time between checks which can prevent |XtraBackup| failures that are caused by the log records in the transactional log being overwritten before they are copied by the log copying thread.
66+
67+ |Percona XtraBackup| now stores the ``GTID`` value in the :file:`xtrabackup_binlog_info` when doing the backup of |MySQL| and |Percona Server| 5.6 with the :option:`innobackupex --slave-info`. Example of how this information can be used to create/restore a slave can be found in `this blogpost <http://www.mysqlperformanceblog.com/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/>`_.
68+
69+ |Percona XtraBackup| option :option:`xtrabackup --export` now supports transportable tablespaces introduced in |MySQL| 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ``ALTER TABLE IMPORT TABLESPACE`` on |MySQL| and |Percona Server| 5.6 as described in :ref:`export_import_tables` guide.
70+
71+Bugs Fixed
72+==========
73+
74+ ``xtrabackup_56`` binary was present in ``rpm`` and ``deb`` packages, but it was missing from the source ``.tar.gz`` package. Fixed by adding the missing binary to ``.tar.gz`` as well. Bug fixed :bug:`1158948`.
75+
76+ |innobackupex| could crash when taking the 5.6 backup due to linking the wrong ``SSL`` library. Bug fixed :bug:`1168540`.
77+
78+ |Percona XtraBackup| would crash when preparing the 5.6 backup with partitioned tables. Bug fixed :bug:`1169169`.
79+
80+ Tables that were dropped between taking a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed :bug:`856400`.
81+
82+ |Percona XtraBackup| would leave stale ``xtrabackup_tmp*`` files in the :term:`datadir` after applying incremental backups. Bug fixed :bug:`1079135`.
83+
84+ Fixed couple of warnings found in |innobackupex| when all warnings have been made ``FATAL``. Bug fixed :bug:`1116177`.
85+
86+ If there are thousands of tables and slow IO then |Xtrabackup| can spend a lot of time opening all the tablespaces. Optimization has been implemented and |XtraBackup| now avoids loading non-relevant tablespaces when partial backup is being taken which speeds up the backup process. Bug fixed :bug:`1130145`.
87+
88+ |Percona XtraBackup| didn't initialize per-thread data in the log copying thread which could cause |XtraBackup| to crash. Bug fixed :bug:`1166888`.
89+
90+ Package dependency has been changed from abstract ``mysql`` to real ``/usr/bin/mysql`` file, because ``rpm`` packages from *Oracle* no longer satisfied ``mysql`` dependency which is required by the |XtraBackup| ``rpms``. Bug fixed :bug:`1095972`.
91+
92+ |Percona XtraBackup| would fail when preparing the |MySQL| 5.6 backup if the log files were bigger than 4G on the source server. Bug fixed :bug:`1164979`.
93+
94+ Due to different implementation in |MySQL| 5.6 error messages were not printed to ``stderr`` directly. Because of that all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed :bug:`1169971`.
95+
96+ |innobackupex| would still run with ``FLUSH TABLES WITH READ LOCK`` even if |xtrabackup| would fail when copying logs. Fixed by terminating |xtrabackup| process immediately on log copying failure. Bug fixed :bug:`1170806`.
97+
98+ |innobackupex| would fail if the ``SQL_MODE`` was set to ``ANSI_QUOTES``. Bug fixed :bug:`945161`.
99+
100+ Missing space_id from ``*.ibd.meta`` would lead to assertion. Fixed by replacing the assertion with the error message. Bug fixed :bug:`1112224`.
101+
102+ Fixed the typo in the |innobackupex| error output. Bug fixed :bug:`1157225`.
103+
104+ When building from source ``innodb56`` target didn't have an option to disable DTrace like ``innodb55`` has. Fixed by adding ``-DENABLE_DTRACE=OFF`` build option for ``innodb56`` as well. Bug fixed :bug:`1169509`.
105+
106+ |innobackupex| wasn't handling the :option:`innodb_data_file_path` option which could cause backup to fail. Bug fixed :bug:`1169726`.
107+
108+ For the *Debian* and the *Linux* binaries, the :option:`--version` message which should include the revision was showing "undefined". Bug fixed :bug:`1171721`.
109+
110+ Redundant code has been removed from ``xtrabackup.cc``. Bug fixed :bug:`1162765`.
111+
112+Other bug fixes: bug fixed :bug:`1158154`, bug fixed :bug:`1170340`, bug fixed :bug:`1088309`, bug fixed :bug:`1088307`.
113
114=== modified file 'doc/source/xtrabackup_bin/exporting_importing_tables.rst'
115--- doc/source/xtrabackup_bin/exporting_importing_tables.rst 2013-03-06 09:17:17 +0000
116+++ doc/source/xtrabackup_bin/exporting_importing_tables.rst 2013-05-06 13:57:23 +0000
117@@ -1,8 +1,10 @@
118+.. _export_import_tables:
119+
120 ================================
121 Exporting and Importing Tables
122 ================================
123
124-In standard InnoDB, it is not normally possible to copy tables between servers by copying the files, even with :term:`innodb_file_per_table`. However, with the |xtrabackup| binary, you can export individual tables from any |InnoDB| database, and import them into |Percona Server| with |XtraDB|. (The source doesn't have to be |XtraDB|, but the destination does.) This functionality requires :term:`innodb_file_per_table` to be used on both servers, and requires :term:`innodb_expand_import` to be enabled on the destination server. It only works on individual :term:`.ibd` files, and cannot export a table that is not contained in its own :term:`.ibd` file.
125+In |InnoDB| versions prior to 5.6, it is not possible to copy tables between servers by copying the files, even with :term:`innodb_file_per_table`. However, with the |xtrabackup| binary, you can export individual tables from any |InnoDB| database, and import them into |Percona Server| with |XtraDB| or |MySQL| 5.6. (The source doesn't have to be |XtraDB| or or |MySQL| 5.6, but the destination does.) This functionality requires :term:`innodb_file_per_table` to be used on both servers, and requires :term:`innodb_expand_import` to be enabled on the destination server. It only works on individual :term:`.ibd` files, and cannot export a table that is not contained in its own :term:`.ibd` file.
126
127 Let's see how to export and import the following table: ::
128
129@@ -27,19 +29,24 @@
130 $ find /data/backups/mysql/ -name export_test.*
131 /data/backups/mysql/test/export_test.exp
132 /data/backups/mysql/test/export_test.ibd
133-
134-These two files are all you need to import the table into a server running |Percona Server| with |XtraDB|.
135+ /data/backups/mysql/test/export_test.cfg
136+
137+These three files are all you need to import the table into a server running |Percona Server| with |XtraDB| or |MySQL| 5.6.
138+
139+.. note::
140+
141+ |MySQL| uses ``.cfg`` file which contains |InnoDB| dictionary dump in special format. This format is different from the ``.exp`` one which is used in |XtraDB| for the same purpose.
142
143 Importing the Table
144 ===================
145
146-On the destination server running |Percona Server| with |XtraDB|, with :term:`innodb_expand_import` enabled, create a table with the same structure, and then perform the following steps:
147+On the destination server running |Percona Server| with |XtraDB| and :term:`innodb_expand_import` option enabled, or |MySQL| 5.6, create a table with the same structure, and then perform the following steps:
148
149 * Execute ``ALTER TABLE test.export_test DISCARD TABLESPACE;``
150
151 * If you see the following message, then you must enable :term:`innodb_file_per_table` and create the table again: ``ERROR 1030 (HY000): Got error -1 from storage engine``
152
153-* Copy the exported files to the ``test/`` subdirectory of the destination server's data directory
154+* Copy the exported files to the ``test/`` subdirectory of the destination server's data directory
155
156 * Execute ``ALTER TABLE test.export_test IMPORT TABLESPACE;``
157

Subscribers

People subscribed via source and target branches