Merge lp:~hrvojem/percona-xtrabackup/bug1100008-2.0 into lp:percona-xtrabackup/2.0
- bug1100008-2.0
- Merge into 2.0
Proposed by
Hrvoje Matijakovic
Status: | Merged | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Approved by: | Stewart Smith | ||||||||||||||||||||||||
Approved revision: | no longer in the source branch. | ||||||||||||||||||||||||
Merged at revision: | 500 | ||||||||||||||||||||||||
Proposed branch: | lp:~hrvojem/percona-xtrabackup/bug1100008-2.0 | ||||||||||||||||||||||||
Merge into: | lp:percona-xtrabackup/2.0 | ||||||||||||||||||||||||
Diff against target: |
293 lines (+54/-37) 9 files modified
doc/source/innobackupex/incremental_backups_innobackupex.rst (+9/-5) doc/source/innobackupex/innobackupex_option_reference.rst (+3/-3) doc/source/innobackupex/privileges.rst (+4/-1) doc/source/installation/compiling_xtrabackup.rst (+5/-5) doc/source/percona-theme/layout.html (+13/-15) doc/source/percona-theme/static/percona.com.css (+3/-3) doc/source/xtrabackup_bin/choosing_binary.rst (+7/-1) doc/source/xtrabackup_bin/incremental_backups.rst (+5/-1) innobackupex (+5/-3) |
||||||||||||||||||||||||
To merge this branch: | bzr merge lp:~hrvojem/percona-xtrabackup/bug1100008-2.0 | ||||||||||||||||||||||||
Related bugs: |
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Stewart Smith (community) | Approve | ||
Review via email: mp+143706@code.launchpad.net |
Commit message
Description of the change
To post a comment you must log in.
Revision history for this message
Stewart Smith (stewart) : | # |
review:
Approve
Revision history for this message
Alexey Kopytov (akopytov) wrote : | # |
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'doc/source/innobackupex/incremental_backups_innobackupex.rst' |
2 | --- doc/source/innobackupex/incremental_backups_innobackupex.rst 2012-06-04 10:29:26 +0000 |
3 | +++ doc/source/innobackupex/incremental_backups_innobackupex.rst 2013-01-17 15:19:29 +0000 |
4 | @@ -69,7 +69,7 @@ |
5 | |
6 | * Then, the uncommitted transaction must be rolled back in order to have a ready-to-use backup. |
7 | |
8 | -If you replay the commit ed transactions **and** rollback the uncommitted ones on the base backup, you will not be able to add the incremental ones. If you do this on an incremental one, you won't be able to add data from that moment and the remaining increments. |
9 | +If you replay the commited transactions **and** rollback the uncommitted ones on the base backup, you will not be able to add the incremental ones. If you do this on an incremental one, you won't be able to add data from that moment and the remaining increments. |
10 | |
11 | Having this in mind, the procedure is very straight-forward using the :option:`--redo-only` option, starting with the base backup: :: |
12 | |
13 | @@ -99,6 +99,10 @@ |
14 | |
15 | If the "completed OK!" message was shown, the final data will be in the base backup directory, ``BASE-DIR``. |
16 | |
17 | +.. note:: |
18 | + |
19 | + :option:`--redo-only` should be used when merging all incrementals except the last one. That's why the previous line doesn't contain the :option:`--redo-only` option. Even if the :option:`--redo-only` was used on the last step, backup would still be consistent but in that case server would perform the rollback phase. |
20 | + |
21 | You can use this procedure to add more increments to the base, as long as you do it in the chronological order that the backups were done. If you omit this order, the backup will be useless. If you have doubts about the order that they must be applied, you can check the file :file:`xtrabackup_checkpoints` at the directory of each one, as shown in the beginning of this section. |
22 | |
23 | Once you put all the parts together, you can prepare again the full backup (base + incrementals) once again to rollback the uncommitted transactions: :: |
24 | @@ -123,19 +127,19 @@ |
25 | |
26 | Incremental streaming backups can be performed with the |xbstream| streaming option. Currently backups are packed in custom **xbstream** format. With this feature taking a BASE backup is needed as well. |
27 | |
28 | - Taking a base backup: :: |
29 | +Taking a base backup: :: |
30 | |
31 | innobackupex /data/backups |
32 | |
33 | - Taking a local backup: :: |
34 | +Taking a local backup: :: |
35 | |
36 | innobackupex --incremental --incremental-lsn=LSN-number --stream=xbstream ./ > incremental.xbstream |
37 | |
38 | - Unpacking the backup: :: |
39 | +Unpacking the backup: :: |
40 | |
41 | xbstream -x < incremental.xbstream |
42 | |
43 | - Taking a local backup and streaming it to the remote server and unpacking it: :: |
44 | +Taking a local backup and streaming it to the remote server and unpacking it: :: |
45 | |
46 | innobackupex --incremental --incremental-lsn=LSN-number --stream=xbstream ./ | / |
47 | ssh user@hostname " cat - | xbstream -x -C > /backup-dir/" |
48 | |
49 | === modified file 'doc/source/innobackupex/innobackupex_option_reference.rst' |
50 | --- doc/source/innobackupex/innobackupex_option_reference.rst 2013-01-15 11:54:46 +0000 |
51 | +++ doc/source/innobackupex/innobackupex_option_reference.rst 2013-01-17 15:19:29 +0000 |
52 | @@ -92,8 +92,8 @@ |
53 | |
54 | .. option:: --no-lock |
55 | |
56 | - Use this option to disable table lock with ``FLUSH TABLES WITH READ LOCK``. Use it only if ALL your tables are InnoDB and you **DO NOT CARE** about the binary log position of the backup. |
57 | - If you are considering to use :option:`--no-lock` because your backups are failing to acquire the lock, this could be because of incoming replication events preventing the lock from succeeding. Please try using :option:`--safe-slave-backup` to momentarily stop the replication slave thread, this may help the backup to succeed and you then don't need to resort to using :option:`--no-lock` |
58 | + Use this option to disable table lock with ``FLUSH TABLES WITH READ LOCK``. Use this option to disable table lock with ``FLUSH TABLES WITH READ LOCK``. Use it only if ALL your tables are InnoDB and you **DO NOT CARE** about the binary log position of the backup. This option shouldn't be used if there are any ``DDL`` statements being executed or if any updates are happening on non-InnoDB tables (this includes the system MyISAM tables in the *mysql* database), otherwise it could lead to an inconsistent backup. |
59 | + If you are considering to use :option:`--no-lock` because your backups are failing to acquire the lock, this could be because of incoming replication events preventing the lock from succeeding. Please try using :option:`--safe-slave-backup` to momentarily stop the replication slave thread, this may help the backup to succeed and you then don't need to resort to using this option. |
60 | |
61 | .. option:: --no-timestamp |
62 | |
63 | @@ -113,7 +113,7 @@ |
64 | |
65 | .. option:: --redo-only |
66 | |
67 | - This option is passed directly to xtrabackup's :option:`xtrabackup --apply-log-only` option. This forces :program:`xtrabackup` to skip the "rollback" phase and do a "redo" only. This is necessary if the backup will have incremental changes applied to it later. See the |xtrabackup| :doc:`documentation <../xtrabackup_bin/incremental_backups>` for details. |
68 | + This option should be used when preparing the base full backup and when merging all incrementals except the last one. It is passed directly to xtrabackup's :option:`xtrabackup --apply-log-only` option. This forces :program:`xtrabackup` to skip the "rollback" phase and do a "redo" only. This is necessary if the backup will have incremental changes applied to it later. See the |xtrabackup| :doc:`documentation <../xtrabackup_bin/incremental_backups>` for details. |
69 | |
70 | .. option:: --remote-host=HOSTNAME |
71 | |
72 | |
73 | === modified file 'doc/source/innobackupex/privileges.rst' |
74 | --- doc/source/innobackupex/privileges.rst 2012-07-31 04:46:23 +0000 |
75 | +++ doc/source/innobackupex/privileges.rst 2013-01-17 15:19:29 +0000 |
76 | @@ -64,6 +64,9 @@ |
77 | .. code-block:: sql |
78 | |
79 | mysql> CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 's3cret'; |
80 | - mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bkpuser'; |
81 | mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost'; |
82 | mysql> FLUSH PRIVILEGES; |
83 | + |
84 | +.. note:: |
85 | + |
86 | + Connection-related parameters are only recognized in the [client] and [mysql] groups in configuration files. Adding custom groups like [xtrabackup] will work only if XtraBackup binary is used, it will not work with the innobackupex. |
87 | |
88 | === modified file 'doc/source/installation/compiling_xtrabackup.rst' |
89 | --- doc/source/installation/compiling_xtrabackup.rst 2012-11-20 16:32:59 +0000 |
90 | +++ doc/source/installation/compiling_xtrabackup.rst 2013-01-17 15:19:29 +0000 |
91 | @@ -25,7 +25,7 @@ |
92 | In ``RPM``-based distributions, you need to: :: |
93 | |
94 | $ yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr \ |
95 | - bison libtool ncurses5-devel |
96 | + bison libtool ncurses-devel zlib-devel |
97 | |
98 | Compiling with :command:`build.sh` |
99 | ---------------------------------- |
100 | @@ -37,9 +37,9 @@ |
101 | ================== ========= ============================================ |
102 | Value Alias Server |
103 | ================== ========= ============================================ |
104 | - innodb51_builtin 5.1 build against built-in InnoDB in MySQL 5.1 |
105 | - innodb51 plugin build against InnoDB plugin in MySQL 5.1 |
106 | - innodb55 5.5 build against InnoDB in MySQL 5.5 |
107 | + innodb51_builtin 5.1 build against built-in InnoDB in MySQL 5.1 |
108 | + innodb51 plugin build against InnoDB plugin in MySQL 5.1 |
109 | + innodb55 5.5 build against InnoDB in MySQL 5.5 |
110 | xtradb51 xtradb build against Percona Server with XtraDB 5.1 |
111 | xtradb55 xtradb55 build against Percona Server with XtraDB 5.5 |
112 | ================== ========= ============================================ |
113 | @@ -52,4 +52,4 @@ |
114 | |
115 | and you go for a coffee, at your return |XtraBackup| will be ready to be used. The |xtrabackup| binary will be located in the ``percona-xtrabackup/src`` subdirectory. |
116 | |
117 | -After this you'll need to copy innobackupex and the corresponding xtrabackup binary to some directory listed in the PATH environment variable, e.g. /usr/bin. |
118 | +After this you'll need to copy |innobackupex| (in the root folder used to retrieve |XtraBackup|) and the corresponding xtrabackup binary (in the src folder) to some directory listed in the PATH environment variable, e.g. ``/usr/bin``. |
119 | |
120 | === modified file 'doc/source/percona-theme/layout.html' |
121 | --- doc/source/percona-theme/layout.html 2013-01-11 12:56:00 +0000 |
122 | +++ doc/source/percona-theme/layout.html 2013-01-17 15:19:29 +0000 |
123 | @@ -61,7 +61,9 @@ |
124 | +1-208-473-2904 (USA - Sales) |
125 | </div> |
126 | <div style="padding-bottom: 4px;"> |
127 | - +44-208-133-0309 (UK - Sales) |
128 | + +44-208-133-0309 (UK - Sales)<br /> |
129 | + 0-800-051-8984 (UK - Sales)<br /> |
130 | + 0-800-181-0665 (GER - Sales)<br /> |
131 | </div> |
132 | <div style="padding-bottom: 4px;"> |
133 | +1-877-862-4316 (Emergency) |
134 | @@ -209,12 +211,12 @@ |
135 | <!-- <div id="stickywrapper"> --> |
136 | <!-- <div id="stickycontent"> --> |
137 | <div id="header"><div class="header"> |
138 | - <div class="logo"><a href="http://www.percona.com/" onfocus="this.blur()"><img src="http://s3.percona.com/ui-logo.png" alt="Percona Performance Consulting Experts" width="240" height="55" /></a></div> |
139 | + <div class="logo"><a href="http://www.percona.com/" onfocus="this.blur()"><img src="http://s3.percona.com/ui-logo.png" alt="Percona Performance Consulting Experts" width="220" height="55" /></a></div> |
140 | <div class="right"> |
141 | <div class="searchlink"><a onmouseover="SEARCH.Open()"><img id="searchlink-anchor" src="http://s2.percona.com/ui-search.png" alt="" /></a></div> |
142 | <span class="inv"><![CDATA[<noindex>]]></span> |
143 | <div class="navicontainer"><div class="navi"> |
144 | - <span id="navilink-span-menu-914"><a href="/about-percona" title="" id="navilink-a-menu-914">About</a></span><span id="navilink-span-menu-915"><a href="/products" title="" id="navilink-a-menu-915">Products</a></span><span id="navilink-span-menu-916"><a href="/software" id="navilink-a-menu-916">Software</a></span><span id="navilink-span-menu-918"><a href="/resources" title="" id="navilink-a-menu-918">Resources</a></span><span id="navilink-span-menu-919"><a href="/news-and-events" title="" id="navilink-a-menu-919">News & Events</a></span><span id="navilink-span-menu-920"><a href="/contact" id="navilink-a-menu-920">Contact Us</a></span><span id="navilink-span-menu-1060"><a href="/live" title="" id="navilink-a-menu-1060">Percona Live</a></span> </div></div> |
145 | + <span id="navilink-span-menu-914"><a id="navilink-a-menu-914" href="/about-percona">About</a></span><span id="navilink-span-menu-915"><a id="navilink-a-menu-915" href="/products">Products</a></span><span id="navilink-span-menu-1125"><a id="navilink-a-menu-1125" title="" href="/software">Software</a></span><span id="navilink-span-menu-918"><a id="navilink-a-menu-918" href="/resources">Resources</a></span><span id="navilink-span-menu-919"><a id="navilink-a-menu-919" title="" href="/news-and-events">News/Events</a></span><span id="navilink-span-menu-1129"><a id="navilink-a-menu-1129" href="/percona-community">Community</a></span><span id="navilink-span-menu-920"><a id="navilink-a-menu-920" title="" href="/contact">Contact</a></span><span id="navilink-span-menu-1060"><a id="navilink-a-menu-1060" title="" href="/live">Percona Live</a></span> </div></div> |
146 | <span class="inv"><![CDATA[</noindex>]]></span> |
147 | </div> |
148 | </div></div><!-- /.header /#header --> |
149 | @@ -317,7 +319,7 @@ |
150 | Call us: 1-888-316-9775 • <a href="/contact">Contact Us</a><br> |
151 | MySQL and InnoDB are trademarks of Oracle Corp.<br> |
152 | Proudly running <a href="/software/percona-server/">Percona Server<span id="recentServerVersion"></span></a><br> |
153 | - Copyright © 2006-2011 Percona Ireland Ltd<br> |
154 | + Copyright © 2006-2011 Percona Inc.<br> |
155 | <a href="/about-us/policies/">Copyright, Trademark, and Privacy Policy</a> • <a href="/sitemap/">Sitemap</a> |
156 | <span class="inv"><!--[CDATA[</noindex-->]]></span> |
157 | </div> |
158 | @@ -326,18 +328,13 @@ |
159 | </div> |
160 | {%- endblock %} |
161 | <span class="inv"><!--[CDATA[<noindex-->]]></span> |
162 | -<div id="submenus"> |
163 | - <div class="navi-dropdown" id="navi-dropdown-menu-914"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/about-us/our-mission">Mission</a></div><div class="item"><a href="/about-us/our-team">Team</a></div><div class="item"><a href="/about-us/customers">Customers</a></div><div class="item"><a href="/about-us/careers">Careers</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div class="navi-dropdown" id="navi-dropdown-menu-915"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/mysql-support">MySQL Support</a></div><div class="item"><a href="/mysql-consulting">MySQL Consulting</a></div><div class="item"><a href="/training">MySQL Training</a></div><div class="item"><a href="/development">MySQL Server Development</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div class="navi-dropdown" id="navi-dropdown-menu-916"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/software">Percona Software for MySQL</a></div><div class="item"><a href="/software/percona-server">Percona Server with XtraDB</a></div><div class="item"><a href="/software/percona-xtradb-cluster">Percona XtraDB Cluster</a></div><div class="item"><a href="/software/percona-toolkit">Percona Toolkit</a></div><div class="item"><a href="/software/percona-monitoring-plugins">Percona Monitoring Plugins</a></div><div class="item"><a href="/software/mysql-innodb-data-recovery-tools">Data Recovery Toolkit</a></div><div class="item"><a href="/software/percona-xtrabackup">Percona XtraBackup</a></div><div class="item"><a href="/software/percona-xtradb">Percona XtraDB</a></div><div class="item"><a href="http://www.percona.com/downloads/">Downloads</a></div><div class="item"><a href="/software/repositories">Repositories</a></div><div class="item"><a href="/software/documentation">Documentation</a></div><div class="item"><a href="http://forum.percona.com">Forum</a></div><div class="item"><a href="http://groups.google.com/group/percona-discussion">Google Discussion</a></div><div class="item"><a href="https://launchpad.net/percona-server">Launchpad</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div class="navi-dropdown" id="navi-dropdown-menu-918"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/webinars">Webinars</a></div><div class="item"><a href="/about-us/blogs">Blogs</a></div><div class="item"><a href="/about-us/presentations">Technical Presentations</a></div><div class="item"><a href="/about-us/books">Books by Percona Authors</a></div><div class="item"><a href="/about-us/mysql-white-papers">White Papers</a></div><div class="item"><a href="/about-us/mysql-case-studies">Case Studies</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div class="navi-dropdown" id="navi-dropdown-menu-919"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/percona-news">In The News</a></div><div class="item"><a href="/about-us/pressreleases">Press Releases</a></div><div class="item"><a href="/live-2">Percona Live Conferences</a></div><div class="item"><a href="/mysql-events">MySQL Events</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div class="navi-dropdown" id="navi-dropdown-menu-920"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/contact/24x7-emergency">24x7 Emergency</a></div><div class="item"><a href="/contact/sales">Sales & General Inquiries</a></div><div class="item"><a href="/contact/billing">Billing Inquiries</a></div><div class="item"><a href="https://customers.percona.com/">Customer Portal Login</a></div><div class="item"><a href="/contact/phone-directory">Phone Directory</a></div><div class="item"><a href="/subscribe">Subscribe to Newsletter</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div class="navi-dropdown" id="navi-dropdown-menu-1060"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="http://www.percona.com/live/nyc-2012/">New York 2012</a></div><div class="item"><a href="http://www.percona.com/live/london-2012/">London 2012</a></div><div class="item"><a href="http://www.percona.com/live/mysql-conference-2012/">MySQL Conference & Expo 2012</a></div><div class="item"><a href="/live">Previous Percona Live Events</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div> |
164 | - |
165 | - |
166 | - |
167 | - |
168 | - <div id="search-dropdown" class="search-dropdown"> |
169 | +<div id="submenus"> |
170 | +<div id="navi-dropdown-menu-914" class="navi-dropdown" style="position: absolute; left: 401.133px; top: 96px; display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/about-us/our-mission">Mission</a></div><div class="item"><a href="/about-us/our-team">Team</a></div><div class="item"><a href="/about-us/customers">Customers</a></div><div class="item"><a href="/about-us/careers">Careers</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-915" class="navi-dropdown" style="display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/mysql-support">MySQL Support</a></div><div class="item"><a href="/mysql-consulting">MySQL Consulting</a></div><div class="item"><a href="/training">MySQL Training</a></div><div class="item"><a href="/development">MySQL Server Development</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-1125" class="navi-dropdown" style="position: absolute; left: 532.933px; top: 96px; display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/software">Percona Software for MySQL</a></div><div class="item"><a href="/software/percona-server">Percona Server with XtraDB</a></div><div class="item"><a href="/software/percona-xtradb-cluster">Percona XtraDB Cluster</a></div><div class="item"><a href="/software/percona-toolkit">Percona Toolkit</a></div><div class="item"><a href="/software/percona-monitoring-plugins">Percona Monitoring Plugins</a></div><div class="item"><a href="/software/mysql-innodb-data-recovery-tools">Data Recovery Toolkit</a></div><div class="item"><a href="/software/percona-xtrabackup">Percona XtraBackup</a></div><div class="item"><a href="/software/percona-xtradb">Percona XtraDB</a></div><div class="item"><a href="/downloads">Downloads</a></div><div class="item"><a href="/software/repositories">Repositories</a></div><div class="item"><a href="/software/documentation">Documentation</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-918" class="navi-dropdown" style="display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/webinars">Webinars</a></div><div class="item"><a href="https://tools.percona.com/wizard">MySQL Configuration Wizard</a></div><div class="item"><a href="https://tools.percona.com/query-advisor">MySQL Query Advisor</a></div><div class="item"><a href="/about-us/blogs">Blogs</a></div><div class="item"><a href="/about-us/presentations">Technical Presentations</a></div><div class="item"><a href="/about-us/books">Books by Percona Authors</a></div><div class="item"><a href="/about-us/mysql-white-papers">White Papers</a></div><div class="item"><a href="/about-us/mysql-case-studies">Case Studies</a></div><div class="item"><a href="http://percona.tv/">Videos</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-919" class="navi-dropdown" style="display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/percona-news">In The News</a></div><div class="item"><a href="/about-us/pressreleases">Press Releases</a></div><div class="item"><a href="/live-2">Percona Live Conferences</a></div><div class="item"><a href="/mysql-events">MySQL Events</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-1129" class="navi-dropdown" style="display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="http://forum.percona.com/">Forums</a></div><div class="item"><a href="http://groups.google.com/group/percona-discussion">Google Discussion Group</a></div><div class="item"><a href="https://launchpad.net/percona-server">Launchpad</a></div><div class="item"><a href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog</a></div><div class="item"><a href="http://twitter.com/percona">Twitter</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-920" class="navi-dropdown" style="display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="/contact/24x7-emergency">24x7 Emergency</a></div><div class="item"><a href="/contact/sales">Sales & General Inquiries</a></div><div class="item"><a href="/contact/billing">Billing Inquiries</a></div><div class="item"><a href="https://customers.percona.com/">Customer Portal Login</a></div><div class="item"><a href="/contact/phone-directory">Phone Directory</a></div><div class="item"><a href="/subscribe">Subscribe to Newsletter</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div><div id="navi-dropdown-menu-1060" class="navi-dropdown" style="display: none;"><div class="navi-dropdown-header-l"><!-- //--></div><div class="navi-dropdown-content"><div class="item"><a href="http://www.percona.com/live/mysql-conference-2013/">MySQL Conference & Expo 2013</a></div><div class="item"><a href="http://www.percona.com/live/london-2012/">London 2012</a></div><div class="item"><a href="http://www.percona.com/live/nyc-2012/">New York 2012</a></div><div class="item"><a href="http://www.percona.com/live/mysql-conference-2012/">MySQL Conference & Expo 2012</a></div><div class="item"><a href="/live">Previous Percona Live Events</a></div></div><div class="navi-dropdown-footer"><!-- //--></div></div> <div class="search-dropdown" id="search-dropdown" style="display: none;"> |
171 | <div class="search-dropdown-header"><!-- //--></div> |
172 | <div class="search-dropdown-content"> |
173 | <div class="search-info">Search Percona.com:</div> |
174 | - <form method="get" action="http://search.percona.com/search/" id="search-form"> |
175 | - <div class="form"><input type="text" id="search-input" name="q" maxlength="100"></div> |
176 | + <form id="search-form" action="http://search.percona.com/search/" method="get"> |
177 | + <div class="form"><input type="text" maxlength="100" name="q" id="search-input"></div> |
178 | </form> |
179 | </div> |
180 | <div class="search-dropdown-footer"><!-- //--></div> |
181 | @@ -353,11 +350,12 @@ |
182 | <!-- /GA //--> |
183 | <!-- NAVI //--> |
184 | <script type="text/javascript">//<![CDATA[ |
185 | -var navi = [{id:"menu-914", direction: "l"},{id:"menu-915", direction: "l"},{id:"menu-916", direction: "l"},{id:"menu-918", direction: "l"},{id:"menu-919", direction: "l"},{id:"menu-920", direction: "l"},{id:"menu-1060", direction: "l"}]; |
186 | +var navi = [{id:"menu-914", direction: "l"},{id:"menu-915", direction: "l"},{id:"menu-1125", direction: "l"},{id:"menu-918", direction: "l"},{id:"menu-919", direction: "l"},{id:"menu-1129", direction: "l"},{id:"menu-920", direction: "l"},{id:"menu-1060", direction: "l"}]; |
187 | for(var i = 0, c = navi.length; i < c; i++) { |
188 | -window.jQuery('#navilink-a-' + navi[i].id).bind('mouseover',{id: navi[i].id, direction:navi[i].direction}, function(e) { NAVI.Open(e.data.id, e.data.direction); } ); |
189 | + window.jQuery('#navilink-a-' + navi[i].id).bind('mouseover',{id: navi[i].id, direction:navi[i].direction}, function(e) { NAVI.Open(e.data.id, e.data.direction); } ); |
190 | } |
191 | window.jQuery('#search-form').bind('submit', function() { window.location.href = jQuery('#search-form').attr('action') + jQuery('#search-input').val(); return false; }); |
192 | + |
193 | //]]></script> |
194 | <!-- /NAVI //--> |
195 | <script type="text/javascript"> |
196 | |
197 | === modified file 'doc/source/percona-theme/static/percona.com.css' |
198 | --- doc/source/percona-theme/static/percona.com.css 2012-07-13 10:36:41 +0000 |
199 | +++ doc/source/percona-theme/static/percona.com.css 2013-01-17 15:19:29 +0000 |
200 | @@ -103,7 +103,7 @@ |
201 | float:left; |
202 | overflow:hidden; |
203 | padding:20px 0; |
204 | - width:240px; |
205 | + width:220px; |
206 | zoom:1 |
207 | } |
208 | |
209 | @@ -112,7 +112,7 @@ |
210 | overflow: hidden; |
211 | zoom: 1; |
212 | float: left; |
213 | - width: 240px; |
214 | + width: 220px; |
215 | padding: 20px 0px; |
216 | } |
217 | |
218 | @@ -121,7 +121,7 @@ |
219 | overflow: hidden; |
220 | zoom: 1; |
221 | float: left; |
222 | - width: 720px; |
223 | + width: 740px; |
224 | height: 35px; |
225 | padding: 30px 0px; |
226 | } |
227 | |
228 | === modified file 'doc/source/xtrabackup_bin/choosing_binary.rst' |
229 | --- doc/source/xtrabackup_bin/choosing_binary.rst 2011-07-07 05:32:50 +0000 |
230 | +++ doc/source/xtrabackup_bin/choosing_binary.rst 2013-01-17 15:19:29 +0000 |
231 | @@ -14,6 +14,12 @@ |
232 | MySQL 5.0.* ``xtrabackup_51`` |
233 | MySQL 5.1.* ``xtrabackup_51`` |
234 | MySQL 5.1.* with InnoDB plugin ``xtrabackup`` |
235 | -Percona Server 5.1 and 5.5 ``xtrabackup`` |
236 | MySQL 5.5.* ``xtrabackup_55`` |
237 | +MariaDB 5.1.* ``xtrabackup`` |
238 | +MariaDB 5.2.* ``xtrabackup`` |
239 | +MariaDB 5.3.* ``xtrabackup`` |
240 | +MariaDB 5.5.* ``xtrabackup_55`` |
241 | +Percona Server 5.0 ``xtrabackup_51`` |
242 | +Percona Server 5.1 ``xtrabackup`` |
243 | +Percona Server 5.5 ``xtrabackup_55`` |
244 | ============================== =================== |
245 | |
246 | === modified file 'doc/source/xtrabackup_bin/incremental_backups.rst' |
247 | --- doc/source/xtrabackup_bin/incremental_backups.rst 2011-07-07 05:32:50 +0000 |
248 | +++ doc/source/xtrabackup_bin/incremental_backups.rst 2013-01-17 15:19:29 +0000 |
249 | @@ -84,7 +84,11 @@ |
250 | |
251 | Preparing the second incremental backup is a similar process: apply the deltas to the (modified) base backup, and you will roll its data forward in time to the point of the second incremental backup: :: |
252 | |
253 | - xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base \ |
254 | + xtrabackup --prepare --target-dir=/data/backups/base \ |
255 | --incremental-dir=/data/backups/inc2 |
256 | |
257 | +.. note:: |
258 | + |
259 | + :option:`--apply-log-only` should be used when merging all incrementals except the last one. That's why the previous line doesn't contain the :option:`--apply-log-only` option. Even if the :option:`--apply-log-only` was used on the last step, backup would still be consistent but in that case server would perform the rollback phase. |
260 | + |
261 | If you wish to avoid the notice that |InnoDB| was not shut down normally, when you have applied the desired deltas to the base backup, you can run :option:`--prepare` again without disabling the rollback phase. |
262 | |
263 | === modified file 'innobackupex' |
264 | --- innobackupex 2013-01-15 01:39:48 +0000 |
265 | +++ innobackupex 2013-01-17 15:19:29 +0000 |
266 | @@ -2695,7 +2695,9 @@ |
267 | # MariaDB 5.1.* - xtrabackup |
268 | # MariaDB 5.2.* - xtrabackup |
269 | # MariaDB 5.3.* - xtrabackup |
270 | -# Percona Server >= 11.0 - xtrabackup |
271 | +# Percona Server 5.0 - xtrabackup_51 |
272 | +# Percona Server 5.1 - xtrabackup |
273 | +# Percona Server 5.5 - xtrabackup_55 |
274 | # MySQL 5.5.* - xtrabackup_55 |
275 | # MariaDB 5.5.* - xtrabackup_55 |
276 | |
277 | @@ -2971,7 +2973,7 @@ |
278 | |
279 | =item --no-lock |
280 | |
281 | -Use this option to disable table lock with "FLUSH TABLES WITH READ LOCK". Use it only if ALL your tables are InnoDB and you DO NOT CARE about the binary log position of the backup. |
282 | +Use this option to disable table lock with "FLUSH TABLES WITH READ LOCK". Use it only if ALL your tables are InnoDB and you DO NOT CARE about the binary log position of the backup. This option shouldn't be used if there are any DDL statements being executed or if any updates are happening on non-InnoDB tables (this includes the system MyISAM tables in the mysql database), otherwise it could lead to an inconsistent backup. If you are considering to use --no-lock because your backups are failing to acquire the lock, this could be because of incoming replication events preventing the lock from succeeding. Please try using --safe-slave-backup to momentarily stop the replication slave thread, this may help the backup to succeed and you then don't need to resort to using this option. |
283 | |
284 | =item --no-timestamp |
285 | |
286 | @@ -2992,7 +2994,7 @@ |
287 | |
288 | =item --redo-only |
289 | |
290 | -This option is passed directly to xtrabackup's --apply-log-only option. This forces xtrabackup to skip the "rollback" phase and do a "redo" only. This is necessary if the backup will have incremental changes applied to it later. See the xtrabackup documentation for details. |
291 | +This option should be used when preparing the base full backup and when merging all incrementals except the last one. This option is passed directly to xtrabackup's --apply-log-only option. This forces xtrabackup to skip the "rollback" phase and do a "redo" only. This is necessary if the backup will have incremental changes applied to it later. See the xtrabackup documentation for details. |
292 | |
293 | =item --remote-host=HOSTNAME |
294 |
Was changing "Percona Ireland Ltd" back to "Percona Inc." intentional?