Merge lp:~hrvojem/percona-xtradb-cluster/doc-58 into lp:percona-xtradb-cluster

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Raghavendra D Prabhu
Approved revision: no longer in the source branch.
Merged at revision: 571
Proposed branch: lp:~hrvojem/percona-xtradb-cluster/doc-58
Merge into: lp:percona-xtradb-cluster
Diff against target: 1142 lines (+337/-439)
24 files modified
doc-pxc/source/conf.py (+4/-4)
doc-pxc/source/errata.rst (+23/-0)
doc-pxc/source/howtos/cenots_howto.rst (+1/-1)
doc-pxc/source/index.rst (+20/-14)
doc-pxc/source/installation.rst (+2/-2)
doc-pxc/source/installation/apt_repo.rst (+2/-2)
doc-pxc/source/installation/compiling_xtradb_cluster.rst (+1/-1)
doc-pxc/source/installation/yum_repo.rst (+5/-1)
doc-pxc/source/intro.rst (+3/-3)
doc-pxc/source/limitation.rst (+6/-4)
doc-pxc/source/manual/bootstrap.rst (+0/-5)
doc-pxc/source/manual/state_snapshot_transfer.rst (+3/-14)
doc-pxc/source/manual/xtrabackup_sst.rst (+66/-26)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst (+0/-19)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst (+0/-16)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst (+0/-38)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst (+0/-56)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst (+0/-20)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst (+0/-44)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst (+0/-84)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst (+0/-73)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst (+78/-0)
doc-pxc/source/release-notes/release-notes_index.rst (+4/-12)
doc-pxc/source/upgrading_guide_55_56.rst (+119/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-xtradb-cluster/doc-58
Reviewer Review Type Date Requested Status
Raghavendra D Prabhu (community) Approve
Review via email: mp+195994@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Approved after changes and discussion.

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc-pxc/source/conf.py'
2--- doc-pxc/source/conf.py 2013-09-05 13:37:01 +0000
3+++ doc-pxc/source/conf.py 2013-11-21 11:30:55 +0000
4@@ -53,9 +53,9 @@
5 # built documents.
6 #
7 # The short X.Y version.
8-version = '5.5.31'
9+version = '5.6.14'
10 # The full version, including alpha/beta/rc tags.
11-release = '5.5.31-23.7.5'
12+release = '5.6.14-25.1'
13
14 # The language for content autogenerated by Sphinx. Refer to documentation
15 # for a list of supported languages.
16@@ -171,7 +171,7 @@
17 html_title = 'Percona XtraDB Cluster Documentation'
18
19 # A shorter title for the navigation bar. Default is the same as html_title.
20-html_short_title = 'XtraDB Cluster Docs'
21+html_short_title = 'Percona XtraDB Cluster 5.6 Documentation'
22
23 # The name of an image file (relative to this directory) to place at the top
24 # of the sidebar.
25@@ -244,7 +244,7 @@
26 # Grouping the document tree into LaTeX files. List of tuples
27 # (source start file, target name, title, author, documentclass [howto/manual]).
28 latex_documents = [
29- ('index', 'PerconaXtraDBCluster.tex', u'Percona XtraDB Cluster Documentation',
30+ ('index', 'PerconaXtraDBCluster-5.6.tex', u'Percona XtraDB Cluster Documentation',
31 u'Percona Ireland Ltd. 2012-2013', 'manual'),
32 ]
33
34
35=== added file 'doc-pxc/source/errata.rst'
36--- doc-pxc/source/errata.rst 1970-01-01 00:00:00 +0000
37+++ doc-pxc/source/errata.rst 2013-11-21 11:30:55 +0000
38@@ -0,0 +1,23 @@
39+.. _errata:
40+
41+===============================
42+ Percona XtraDB Cluster Errata
43+===============================
44+
45+Known Issues
46+-------------
47+
48+Following are issues which may impact you while running PXC:
49+ - wsrep_causal_reads being ON can introduce temporary stalls due to MDL lock conflicts.
50+ - Create Table As Select (CTAS) can cause deadlocks and server hang when used with explicit TEMPORARY tables.
51+ - bug :bug:`1226185`: percona-xtrabackup-20 may get installed as a dependency instead of latest percona-xtrabackup during a fresh install due to certain yum issues. This can be avoided by specifying ``percona-xtrabackup`` explicitly in the install command line.
52+ - bug :bug:`1192834`: Joiner may crash after SST from donor with compaction enabled. Workaround is to disable the index compaction (compact under [xtrabackup]), if enabled. This crash requires specific configuration, hence you may not be affected. Also, this doesn't require any fix from PXC, but Xtrabackup with the fix included should do.
53+ - bug :bug:`1098566`: :variable:`innodb_data_home_dir`/:variable:`innodb_log_group_home_dir` is not supported. Depends on bug :bug:`1164945` for the fix.
54+
55+Also make sure to check limitations page :ref:`here <limitations>`. You can also review this `milestone <https://launchpad.net/percona-xtradb-cluster/+milestone/future-5.5>`_ for features/bugfixes to be included in future releases (i.e. releases after the upcoming/recent release).
56+
57+Incompatibilities
58+-------------------
59+
60+Following are incompatibilities between PXC 5.5.33 (and higher) and older versions:
61+ - wsrep_sst_donor now supports comma separated list of nodes as a consequence of bug :bug:`1129512`. This only affects if you use this option as a list. This is not compatible with nodes running older PXC, hence **entire** cluster will be affected as far as SST is concerned, since donor nodes won't recognise the request from joiner nodes if former are not upgraded. Minimal workaround is to upgrade Galera package or to not use this new feature (wsrep_sst_donor with single node can still be used). However, upgrading the full PXC is strongly recommended, however, just upgrading PXC galera package will do for this.
62
63=== modified file 'doc-pxc/source/howtos/cenots_howto.rst'
64--- doc-pxc/source/howtos/cenots_howto.rst 2013-09-05 13:37:01 +0000
65+++ doc-pxc/source/howtos/cenots_howto.rst 2013-11-21 11:30:55 +0000
66@@ -37,7 +37,7 @@
67
68 Following command will install |Percona XtraDB Cluster| packages: ::
69
70- $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client
71+ $ yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56
72
73 When these two commands have been executed successfully on all three nodes |Percona XtraDB Cluster| is installed.
74
75
76=== modified file 'doc-pxc/source/index.rst'
77--- doc-pxc/source/index.rst 2013-09-05 13:37:01 +0000
78+++ doc-pxc/source/index.rst 2013-11-21 11:30:55 +0000
79@@ -3,29 +3,33 @@
80 You can adapt this file completely to your liking, but it should at least
81 contain the root `toctree` directive.
82
83-==================================================
84-Welcome to Percona XtraDB Cluster's documentation!
85-==================================================
86-
87-Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users.
88-
89-Percona XtraDB Cluster provides:
90+==========================================
91+ Percona XtraDB Cluster 5.6 Documentation
92+==========================================
93+
94+.. warning::
95+
96+ Please note: |Percona XtraDB Cluster| 5.6 is BETA quality software. It should *NOT* be used in production environments.
97+
98+|Percona XtraDB Cluster| is High Availability and Scalability solution for MySQL Users.
99+
100+|Percona XtraDB Cluster| provides:
101
102- * Synchronous replication. Transaction either commited on all nodes or none.
103+ * Synchronous replication. Transaction either committed on all nodes or none.
104
105 * Multi-master replication. You can write to any node.
106
107- * Parallel applying events on slave. Real “parallel replication”.
108+ * Parallel applying events on slave. Real "parallel replication".
109
110 * Automatic node provisioning.
111
112 * Data consistency. No more unsynchronized slaves.
113
114-Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning:
115-
116- * Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server
117-
118- * Application compatibility. There is no or minimal application changes required to start work with Percona XtraDB Cluster
119+|Percona XtraDB Cluster| is fully compatible with |MySQL| or |Percona Server| in the following meaning:
120+
121+ * Data compatibility. |Percona XtraDB Cluster| works with databases created in |MySQL| / |Percona Server|.
122+
123+ * Application compatibility. There is no or minimal application changes required to start work with |Percona XtraDB Cluster|.
124
125
126 Introduction
127@@ -37,6 +41,7 @@
128
129 intro
130 limitation
131+ errata
132
133 Installation
134 ============
135@@ -47,6 +52,7 @@
136
137 installation
138 installation/compiling_xtradb_cluster
139+ upgrading_guide_55_56
140
141 Features
142 ========
143
144=== modified file 'doc-pxc/source/installation.rst'
145--- doc-pxc/source/installation.rst 2013-09-05 13:37:01 +0000
146+++ doc-pxc/source/installation.rst 2013-11-21 11:30:55 +0000
147@@ -33,7 +33,7 @@
148
149 Once the repository is set up, use the following commands: ::
150
151- $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client
152+ $ yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56
153
154 More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`centos_howto` tutorial.
155
156@@ -42,7 +42,7 @@
157
158 Once the repository is set up, use the following commands: ::
159
160- $ sudo apt-get install percona-xtradb-cluster-server-5.5 percona-xtradb-cluster-client-5.5
161+ $ sudo apt-get install percona-xtradb-cluster-server-5.6 percona-xtradb-cluster-client-5.6
162
163 More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`ubuntu_howto` tutorial.
164
165
166=== modified file 'doc-pxc/source/installation/apt_repo.rst'
167--- doc-pxc/source/installation/apt_repo.rst 2013-09-05 13:37:01 +0000
168+++ doc-pxc/source/installation/apt_repo.rst 2013-11-21 11:30:55 +0000
169@@ -39,6 +39,7 @@
170 * 12.04LTS precise
171 * 12.10 quantal
172 * 13.04 raring
173+ * 13.10 saucy
174
175
176 Install XtraDB Cluster
177@@ -46,8 +47,7 @@
178
179 Following command will install Cluster packages: ::
180
181- $ sudo apt-get install percona-xtradb-cluster-client-5.5 \
182- percona-xtradb-cluster-server-5.5 percona-xtrabackup
183+ $ sudo apt-get install percona-xtradb-cluster-client-5.6 percona-xtradb-cluster-server-5.6
184
185 Percona `apt` Experimental repository
186 =====================================
187
188=== modified file 'doc-pxc/source/installation/compiling_xtradb_cluster.rst'
189--- doc-pxc/source/installation/compiling_xtradb_cluster.rst 2013-09-05 13:37:01 +0000
190+++ doc-pxc/source/installation/compiling_xtradb_cluster.rst 2013-11-21 11:30:55 +0000
191@@ -4,7 +4,7 @@
192
193 The source code is available from the *Launchpad* project `here <https://launchpad.net/percona-xtradb-cluster>`_. The easiest way to get the code is with :command:`bzr branch` of the desired release, such as the following: ::
194
195- bzr branch lp:percona-xtradb-cluster
196+ bzr branch lp:percona-xtradb-cluster/5.6
197
198 You should then have a directory named after the release you branched, such as ``percona-xtradb-cluster``.
199
200
201=== modified file 'doc-pxc/source/installation/yum_repo.rst'
202--- doc-pxc/source/installation/yum_repo.rst 2013-09-05 13:37:01 +0000
203+++ doc-pxc/source/installation/yum_repo.rst 2013-11-21 11:30:55 +0000
204@@ -30,7 +30,11 @@
205
206 Following command will install Cluster packages: ::
207
208- $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client xtrabackup
209+ $ yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56 percona-xtrabackup
210+
211+.. warning::
212+
213+ In order to sucessfully install |Percona XtraDB Cluster| ``socat`` package will need to be installed first.
214
215 Percona `yum` Experimental repository
216 =====================================
217
218=== modified file 'doc-pxc/source/intro.rst'
219--- doc-pxc/source/intro.rst 2013-09-05 13:37:01 +0000
220+++ doc-pxc/source/intro.rst 2013-11-21 11:30:55 +0000
221@@ -49,14 +49,14 @@
222 Components
223 ==========
224
225-*Percona XtraDB Cluster* is based on `Percona Server with XtraDB <http://www.percona.com/software/percona-server/>`_
226+|Percona XtraDB Cluster| is based on `Percona Server with XtraDB <http://www.percona.com/software/percona-server/>`_
227 and includes `Write Set Replication patches <https://launchpad.net/codership-mysql>`_.
228-It uses the `Galera library <https://launchpad.net/galera>`_, version 2.x,
229+It uses the `Galera library <https://launchpad.net/galera>`_, version 3.x,
230 a generic Synchronous Multi-Master replication plugin for transactional applications.
231
232 Galera library is developed by `Codership Oy <http://www.codership.com/>`_.
233
234-Galera 2.x supports such new features as:
235+Galera 3.x supports such new features as:
236 * Incremental State Transfer (|IST|), especially useful for WAN deployments,
237 * RSU, Rolling Schema Update. Schema change does not block operations against table.
238
239
240=== modified file 'doc-pxc/source/limitation.rst'
241--- doc-pxc/source/limitation.rst 2013-09-05 13:37:01 +0000
242+++ doc-pxc/source/limitation.rst 2013-11-21 11:30:55 +0000
243@@ -9,14 +9,16 @@
244 - Currently replication works only with |InnoDB| storage engine. Any writes to tables of other types, including system (mysql.*) tables, are not replicated. However, DDL statements are replicated in statement level, and changes to mysql.* tables will get replicated that way. So, you can safely issue: CREATE USER..., but issuing: INSERT INTO mysql.user..., will not be replicated.
245
246 - Unsupported queries:
247- * LOCK/UNLOCK TABLES cannot be supported in multi-master setups.
248+
249+ * ``LOCK/UNLOCK TABLES`` cannot be supported in multi-master setups.
250 * lock functions (GET_LOCK(), RELEASE_LOCK()... )
251
252 - Query log cannot be directed to table. If you enable query logging, you must forward the log to a file: log_output = FILE. Use general_log and general_log_file to choose query logging and the log file name.
253
254- - Maximum allowed transaction size is defined by wsrep_max_ws_rows and wsrep_max_ws_size. LOAD DATA INFILE processing will commit every 10K rows. So large transactions due to LOAD DATA will be split to series of small transactions.
255-
256- - Due to cluster level optimistic concurrency control, transaction issuing COMMIT may still be aborted at that stage. There can be two transactions writing to same rows and committing in separate XtraDB Cluster nodes, and only one of the them can successfully commit. The failing one will be aborted. For cluster level aborts, XtraDB Cluster gives back deadlock error code:
257+ - Maximum allowed transaction size is defined by :variable:`wsrep_max_ws_rows` and :variable:`wsrep_max_ws_size` variables. ``LOAD DATA INFILE`` processing will commit every 10K rows. So large transactions due to ``LOAD DATA`` will be split to series of small transactions.
258+
259+ - Due to cluster level optimistic concurrency control, transaction issuing ``COMMIT`` may still be aborted at that stage. There can be two transactions writing to same rows and committing in separate |Percona XtraDB Cluster| nodes, and only one of the them can successfully commit. The failing one will be aborted. For cluster level aborts, |Percona XtraDB Cluster| gives back deadlock error code: ::
260+
261 (Error: 1213 SQLSTATE: 40001 (ER_LOCK_DEADLOCK)).
262
263 - XA transactions can not be supported due to possible rollback on commit.
264
265=== modified file 'doc-pxc/source/manual/bootstrap.rst'
266--- doc-pxc/source/manual/bootstrap.rst 2013-09-05 13:37:01 +0000
267+++ doc-pxc/source/manual/bootstrap.rst 2013-11-21 11:30:55 +0000
268@@ -34,11 +34,6 @@
269
270 This way values in :file:`my.cnf` would remain unchanged. Next time node is restarted it won't require updating the configuration file. This can be useful in case cluster has been previously set up and for some reason all nodes went down and the cluster needs to be bootstrapped again.
271
272-Version Specific Information
273-============================
274-
275- * :rn:`5.5.31-23.7.5` - New bootstrap init script option ``bootstrap-pxc`` introduced.
276-
277 Other Reading
278 =============
279
280
281=== modified file 'doc-pxc/source/manual/state_snapshot_transfer.rst'
282--- doc-pxc/source/manual/state_snapshot_transfer.rst 2013-09-05 13:37:01 +0000
283+++ doc-pxc/source/manual/state_snapshot_transfer.rst 2013-11-21 11:30:55 +0000
284@@ -20,32 +20,21 @@
285
286 innobackupex --user=root --password=Passw0rd /tmp/
287
288-Script used for this method can be found in :file:`/usr/bin/wsrep_sst_xtrabackup` and it's provided with the |PXC| binary packages.
289-
290-After :rn:`5.5.31-23.7.5` this method introduced the new :file:`my.cnf` option which can be used to set |XtraBackup| streaming option: ::
291-
292- [sst]
293- streamfmt=xbstream
294-
295-Currently supported formats are tar (default, used in previous releases) and `xbstream <http://www.percona.com/doc/percona-xtrabackup/2.1/xbstream/xbstream.html>`_. Some of the benefits of choosing the xbstream over tar is that it supports more advanced features like `encrypted <http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/encrypted_backups_innobackupex.html>`_, `compact <http://www.percona.com/doc/percona-xtrabackup/2.1/xbstream/xbstream.html>`_ and `compressed <http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/streaming_backups_innobackupex.html#examples-using-xbstream>`_ backups.
296-
297-.. note::
298-
299- Currently there is a limitations when using the ``xbstream`` option that the :term:`datadir` needs to be empty before starting the SST or otherwise the process will fail and the node will not be able to join the cluster.
300+Script used for this method can be found in :file:`/usr/bin/wsrep_sst_xtrabackup` and it's provided with the |Percona XtraDB Cluster| binary packages. Detailed information on this method are provided in :ref:`xtrabackup_sst` documentation.
301
302 Using ``mysqldump``
303 ===================
304
305 This method uses the standard :program:`mysqldump` to dump all the databases from the donor node and import them to the joining node. For this method to work :variable:`wsrep_sst_auth` needs to be set up with the root credentials. This method is the slowest one and it also performs the global lock while doing the |SST| which will block writes to the donor node.
306
307-Script used for this method can be found in :file:`/usr/bin/wsrep_sst_mysqldump` and it's provided with the |PXC| binary packages.
308+Script used for this method can be found in :file:`/usr/bin/wsrep_sst_mysqldump` and it's provided with the |Percona XtraDB Cluster| binary packages.
309
310 Using ``rsync``
311 ===============
312
313 This method uses :program:`rsync` to copy files from donor to the joining node. In some cases this can be faster than using the |XtraBackup| but requires the global data lock which will block writes to the donor node. This method doesn't require username/password credentials to be set up in the variable :variable:`wsrep_sst_auth`.
314
315-Script used for this method can be found in :file:`/usr/bin/wsrep_sst_rsync` and it's provided with the |PXC| binary packages.
316+Script used for this method can be found in :file:`/usr/bin/wsrep_sst_rsync` and it's provided with the |Percona XtraDB Cluster| binary packages.
317
318 Other Reading
319 =============
320
321=== modified file 'doc-pxc/source/manual/xtrabackup_sst.rst'
322--- doc-pxc/source/manual/xtrabackup_sst.rst 2013-09-05 13:37:01 +0000
323+++ doc-pxc/source/manual/xtrabackup_sst.rst 2013-11-21 11:30:55 +0000
324@@ -4,6 +4,17 @@
325 Xtrabackup SST Configuration
326 ===============================
327
328+XtraBackup SST works in two stages:
329+
330+ * Stage I on joiner checks if it is |SST| or |IST| based on presence of :file:`xtrabackup_ist` file.
331+ * In Stage II it starts the data transfer, if it's |SST|, it empties the data directory sans few files (galera.cache, sst_in_progress, grastate.dat) and then proceed with the SST or if it's IST, proceeds as before.
332+
333+.. note::
334+
335+ To maintain compatibility with |Percona XtraDB Cluster| older than 5.5.33-23.7.6, use xtrabackup as SST method, else xtrabackup-v2 is recommended
336+
337+Latest |Percona Xtrabackup| 2.1.x is strongly recommended for Xtrabackup SST. Refer to `Incompatibilities <http://www.percona.com/doc/percona-xtradb-cluster/errata.html#incompatibilities>`_ for possible caveats.
338+
339 Following SST specific options are allowed in my.cnf under [sst]
340 -----------------------------------------------------------------
341
342@@ -18,15 +29,13 @@
343
344 * In following options, path always means full path.
345
346- * Following options are only applicable for **PXC 5.5.32** and above. For 5.5.31 PXC refer to documentation in wsrep_sst_xtrabackup.
347-
348 .. option:: streamfmt
349
350 :Values: xbstream, tar
351- :Default: tar
352+ :Default: xbstream
353 :Match: Yes
354
355-Refer to :ref:`Xbstream v/s Tar<tar_ag_xbstream>` for details and caveats of using tar v/s xbstream for SST.
356+Xbstream is highly recommended. Refer to :ref:`Xbstream v/s Tar <tar_ag_xbstream>` for details and caveats of using tar v/s xbstream for SST.
357
358 .. option:: transferfmt
359
360@@ -39,30 +48,33 @@
361 .. option:: tca
362
363 :Description: CA file for openssl based encryption with socat.
364- :Type: Full path to CA file.
365+ :Type: Full path to CRT file (.crt).
366
367 .. option:: tcert
368
369 :Description: PEM for openssl based encryption with socat.
370- :Type: Full path to PEM.
371+ :Type: Full path to PEM (.pem).
372
373 .. note::
374- For tca and tcert, refer to http://www.dest-unreach.org/socat/doc/socat-openssltunnel.html for an example.
375+ For tca and tcert, refer to http://www.dest-unreach.org/socat/doc/socat-openssltunnel.html for an example. The ``tca`` is essentially the self-signed certificate in that example, and ``tcert`` is the PEM file generated after concatenation of the key and the certificate generated earlier. The names of options were chosen so as to be compatible with socat's parameter' names as well as with MySQL's SSL authentication. For testing you can also download certificates from `launchpad <https://bazaar.launchpad.net/~percona-core/percona-xtradb-cluster/5.5/files/head:/tests/certs/>`_. **Note** that irrespective of what is shown in the example, you can use same crt and pem files on all nodes and it will work, since there is no server-client paradigm here but a cluster with homogeneous nodes.
376
377 .. option:: encrypt
378
379- :Values: 0,1,2
380+ :Values: 0,1,2,3
381 :Default: 0
382 :Match: Yes
383- :Recommended: 2
384
385 Decides whether encryption is to be done or not, if this is zero, no
386-encryption is done.
387+encryption is done. ``encrypt=2`` is recommended if your nodes are
388+over WAN and security constraints are higher, while ``encrypt=1``
389+(Xtrabackup-based symmetric encryption) is easier to setup.
390
391 * Xtrabackup based encryption with ``encrypt=1``.
392
393 * OpenSSL based encryption with ``encrypt=2``. Socat must be built with openSSL for encryption: ``socat -V | grep OPENSSL``.
394
395+ * Support for SSL encryption for just the key and crt files as implemented in `Galera <http://www.codership.com/wiki/doku.php?id=ssl_support>`_ can be enabled with ``encrypt=3`` option. Information on this option can be found :ref:`here <galera_sst_encryption>`.
396+
397 Refer to this :ref:`document <xtrabackup_sst_encryption>` when enabling with ``encrypt=1``.
398
399 .. option:: encrypt-algo
400@@ -78,13 +90,12 @@
401
402 .. option:: progress
403
404- :Values: 1,path/to/file,path/to/fifo
405+ :Values: 1,path/to/file
406
407 If equal to:
408
409 * 1 it writes to mysql stderr
410- * path/to/file writes to that file.
411- * path/to/fifo, it will be created and cleaned up at exit.This is the preferred way. You need to cat the fifo file to monitor the progress, not tail it.
412+ * path/to/file writes to that file. If this is a fifo, it needs to exist and be open on reader end before itself, otherwise wsrep_sst_xtrabackup will block indefinitely.
413
414 .. note::
415 Value of 0 is not valid.
416@@ -96,7 +107,9 @@
417
418 Used only on joiner. 1 implies rebuild indexes. Note that this is
419 independent of compaction, though compaction enables it. Rebuild of
420-indexes may be used as an optimization.
421+indexes may be used as an optimization. Note that :bug:`1192834`
422+affects this, hence use of ``compact`` and ``rebuild`` are recommended
423+after that is fixed in Percona Xtrabackup and released.
424
425 .. option:: time
426
427@@ -119,36 +132,63 @@
428 To be set on joiner only, supersedes IST if set. Currently requires
429 manual setup. Hence, not supported currently.
430
431+.. option:: use_extra
432+
433+ :Values: 0,1
434+ :Default: 0
435+
436+
437+If set to 1, SST will use the thread pool's `extra_port <http://www.percona.com/doc/percona-server/5.6/performance/threadpool.html#extra_port>`_. Make sure that thread pool is enabled and extra_port option is set in my.cnf before you turn on this option.
438+
439+.. option:: cpat
440+
441+During the SST, the :term:`datadir` is cleaned up so that state of other node can be restored cleanly. This option provides the ability to define the files that need to be deleted before the SST. It can be set like: ::
442+
443+ [sst]
444+ cpat='.*galera\.cache$\|.*sst_in_progress$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*\.xyz$'
445+
446+**NOTE:** This option can only be used when :variable:`wsrep_sst_method` is set to xtrabackup-v2.
447+
448 .. _tar_ag_xbstream:
449
450 Tar against xbstream
451 ---------------------
452
453 * Features - encryption, compression, parallel streaming, streaming incremental backups, compaction - won't work with tar. Refer to `xbstream docs <http://www.percona.com/doc/percona-xtrabackup/2.1/xbstream/xbstream.html>`_ for more.
454- * Bug :bug:`1193240` requires you to manually cleanup the directory (empty data directory) prior to SST. After that is fixed (and xtrabackup is released), SST will work without any modifications to wsrep_sst_xtrabackup.
455
456 Xtrabackup SST Dependencies
457 ----------------------------
458
459 Following are optional dependencies of PXC introduced by wsrep_sst_xtrabackup: (obvious and direct dependencies are not provided here)
460
461- * qpress for decompression. It is a dependency of Xtrabackup 2.1.4 and is available in our repos.
462+ * qpress for decompression. It is an optional dependency of |Percona XtraBackup| 2.1.4 and it is available in our software repositories.
463 * my_print_defaults to extract values from my.cnf. Provided by the server package.
464- * openbsd-netcat or socat for transfer. socat is a direct dependency of PXC and is the default.
465+ * openbsd-netcat or socat for transfer. socat is a direct dependency of |Percona XtraDB Cluster| and it is the default.
466 * xbstream/tar for streaming. tar is default.
467 * pv. Required for :option:`progress` and :option:`rlimit`. Provided by pv.
468 * mkfifo. Required for :option:`progress`. Provided by coreutils.
469 * mktemp. Required for :option:`incremental`. Provided by coreutils.
470
471-.. _tip::
472- For qpress download `from <http://www.quicklz.com/qpress-11-linux-x64.tar>`_ till it is available. You can also build it from `source <http://www.quicklz.com/qpress-11-source.zip>`_.
473+.. _galera_sst_encryption:
474+
475+Galera compatible encryption
476+----------------------------
477+
478+Support for SSL encryption for just the key and crt files as implemented in `Galera <http://www.codership.com/wiki/doku.php?id=ssl_support>`_ can be enabled with ``encrypt=3`` option. This has been implemented in :rn:`5.5.34-23.7.6` for compatibility with Galera. **NOTE**: This option does not provide certificate validation. In order to work correctly paths to the key and cert files need to be specified as well, like: ::
479+
480+ [sst]
481+ encrypt=3
482+ tkey=/etc/mysql/key.pem
483+ tcert=/etc/mysql/cert.pem
484+
485+**NOTE:** This option can only be used when :variable:`wsrep_sst_method` is set to xtrabackup-v2.
486
487 .. _xtrabackup_sst_encryption:
488
489 Xtrabackup-based encryption
490 ----------------------------
491
492-This is enabled when :option:`encrypt` is set to 1 under [sst]. However, due to lp:1190335, it will also be enabled when you specify any of the following options under [xtrabackup] in my.cnf:
493+This is enabled when :option:`encrypt` is set to 1 under [sst]. However, due to bug :bug:`1190335`, it will also be enabled when you specify any of the following options under [xtrabackup] in my.cnf:
494
495 .. _xtrabackup_encrypt_options:
496
497@@ -158,11 +198,11 @@
498
499 There is no way to disallow encryption from innobackupex if the above are in my.cnf under [xtrabackup]. For that reason, do the following:
500
501- #. If you want to use xtrabackup based encryption for SST but not otherwise, use ``encrypt=1`` under [sst] and provide xtrabackup_encrypt_options_ under [sst]. Details of those options can be found `here <http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/encrypted_backups_innobackupex.html>`_.
502-
503- #. If you want to use xtrabackup based encryption always, use ``encrypt=1`` under [sst] and have those xtrabackup_encrypt_options_ either under [sst] or [xtrabackup].
504-
505- #. If you don't want xtrabackup based encryption for SST but want it otherwise, use ``encrypt=0`` or ``encrypt=2`` and do **NOT** provide xtrabackup_encrypt_options_ under [xtrabackup]. You can still have them under [sst] though. You will need to provide those options on innobackupex commandline then.
506+ #. If you want to use xtrabackup based encryption for SST but not otherwise, use ``encrypt=1`` under [sst] and provide xtrabackup_encrypt_options under [sst]. Details of those options can be found `here <http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/encrypted_backups_innobackupex.html>`_.
507+
508+ #. If you want to use xtrabackup based encryption always, use ``encrypt=1`` under [sst] and have those xtrabackup_encrypt_options either under [sst] or [xtrabackup].
509+
510+ #. If you don't want xtrabackup based encryption for SST but want it otherwise, use ``encrypt=0`` or ``encrypt=2`` and do **NOT** provide xtrabackup_encrypt_options under [xtrabackup]. You can still have them under [sst] though. You will need to provide those options on innobackupex commandline then.
511
512 #. If you don't want to use xtrabackup based encryption at all (or only the openssl-based for SST with ``encrypt=2``), then you don't need worry about these options! (just don't provide them in my.cnf)
513
514@@ -172,4 +212,4 @@
515 The :option:`encrypt` under [sst] is different from under [xtrabackup]. The former is for disabling/changing encryption mode, latter is to provide encryption algorithm. To disambiguate, if you need to provide latter under [sst] (which you need to, for points #1 and #2 above) then it should be specified as :option:`encrypt-algo`.
516
517 .. warning::
518- An implication of the above is that if you specify xtrabackup_encrypt_options_ but ``encrypt=0`` under [sst], it will **STILL** be encrypted and SST will fail. Look at point#3 above for resolution.
519+ An implication of the above is that if you specify xtrabackup_encrypt_options but ``encrypt=0`` under [sst], it will **STILL** be encrypted and SST will fail. Look at point#3 above for resolution.
520
521=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst'
522--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst 2013-09-05 13:37:01 +0000
523+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst 1970-01-01 00:00:00 +0000
524@@ -1,19 +0,0 @@
525-.. rn:: 5.5.23
526-
527-=====================================
528- |Percona XtraDB Cluster| 5.5.23-23.5
529-=====================================
530-
531-Percona is glad to announce the release of |Percona XtraDB Cluster| on May 14, 2012. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.23-23.5/>`_ or from our `software repositories <http://www.percona.com/doc/percona-xtradb-cluster/installation.html#using-percona-software-repositories>`_.
532-
533-This is an General Availability release. We did our best to eliminate bugs and problems during alpha and beta testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
534-
535-List of changes:
536- * Fixes merged from upstream (`Codership-mysql <http://www.codership.com/content/wsrep-patch-235-mysql-5523-released>`_).
537- * Support for MyISAM, now changes to MyISAM tables are replicated to other nodes.
538- * Improvements to XtraBackup SST methods, better error handling.
539- * New SST wsrep_sst_method=skip, useful when you start all nodes from the same sources (i.e. backup).
540- * Ability to pass list of IP addresses for a new node, it will connect to the first available.
541-
542-Based on `Percona Server 5.5.23-25.3 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.23-25.3.html>`_ including all the bug fixes in it, and the latest `Galera 2.x replicator <https://code.launchpad.net/~codership/galera/2.x>`_, |Percona XtraDB Cluster| 5.5.23-25.3 is now the current stable release. All of |Percona|'s software is open-source and free.
543-
544
545=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst'
546--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst 2013-09-05 13:37:01 +0000
547+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst 1970-01-01 00:00:00 +0000
548@@ -1,16 +0,0 @@
549-.. rn:: 5.5.24
550-
551-=====================================
552- |Percona XtraDB Cluster| 5.5.24-23.6
553-=====================================
554-
555-Percona is glad to announce the release of |Percona XtraDB Cluster| on June 7, 2012. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.24-23.6/>`_ or from our `software repositories <http://www.percona.com/doc/percona-xtradb-cluster/installation.html#using-percona-software-repositories>`_.
556-
557-This is an General Availability release. We did our best to eliminate bugs and problems during alpha and beta testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
558-
559-Bugs fixed:
560-
561- * Table with no PK but still having UK, can cause crash in slave using PA. Bug fixed :bug:`1003929`.
562-
563-Based on `Percona Server 5.5.24-26.0 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.24-26.0.html>`_ including all the bug fixes in it, and the latest `Galera 2.x replicator <https://code.launchpad.net/~codership/galera/2.x>`_, |Percona XtraDB Cluster| 5.5.24-23.6 is now the current stable release. All of |Percona|'s software is open-source and free.
564-
565
566=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst'
567--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst 2013-09-05 13:37:01 +0000
568+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst 1970-01-01 00:00:00 +0000
569@@ -1,38 +0,0 @@
570-.. rn:: 5.5.27
571-
572-=====================================
573- |Percona XtraDB Cluster| 5.5.27-23.6
574-=====================================
575-
576-Percona is glad to announce the release of |Percona XtraDB Cluster| on September 7th, 2012. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.27-23.6/>`_ or from our `software repositories <http://www.percona.com/doc/percona-xtradb-cluster/installation.html#using-percona-software-repositories>`_.
577-
578-This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
579-
580-Features
581-========
582-
583- * |Percona XtraDB Cluster| supports tunable buffer size for fast index creation in |InnoDB|. This value was calculated based on the merge block size (which was hardcoded to 1 MB) and the minimum index record size. By adding the session variable `innodb_merge_sort_block_size <http://www.percona.com/doc/percona-server/5.5/management/innodb_fast_index_creation.html#innodb_merge_sort_block_size>`_ block size that is used in the merge sort can now be adjusted for better performance.
584-
585- * |Percona XtraDB Cluster| has implemented ability to have a MySQL `Utility user <http://www.percona.com/doc/percona-server/5.5/management/utility_user.html#psaas-utility-user>`_ who has system access to do administrative tasks but limited access to user schema. This feature is especially useful to those operating MySQL As A Service.
586-
587- * New `Expanded Program Option Modifiers <http://www.percona.com/doc/percona-server/5.5/management/expanded_program_option_modifiers.html#expanded-option-modifiers>`_ have been added to allow access control to system variables.
588-
589- * New table `INNODB_UNDO_LOGS <http://www.percona.com/doc/percona-server/5.5/diagnostics/misc_info_schema_tables.html#INNODB_UNDO_LOGS>`_ has been added to allow access to undo segment information. Each row represents an individual undo segment and contains information about which rollback segment the undo segment is currently owned by, which transaction is currently using the undo segment, and other size and type information for the undo segment. This information is 'live' and calculated for each query of the table.
590-
591- * |Percona XtraDB Cluster| now has improved ``clustercheck.sh`` script which makes a proxy (ie HAProxy) capable of monitoring Percona XtraDB Cluster nodes properly.
592-
593-Bugs fixed
594-==========
595-
596- * Increasing the number of slave threads doesn't require provider reloading anymore. Bug fixed :bug:`852094`.
597-
598- * No other SQL statement except INSERT...SELECT would replicate if /*!99997*/ comment was present. Bug fixed :bug:`1023911`.
599-
600- * Fixed the bug that caused DDL command hanging when RSU was enabled and server was under high rate SQL write load. Bug fixed :bug:`1026181`.
601-
602- * Cascading foreign key constraint could cause a slave crash. Bug fixed :bug:`1013978`.
603-
604- * Fixed bug when donor accepts query, which then blocks. Bug fixed :bug:`1002714`.
605-
606-Based on `Percona Server 5.5.27-28.1 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.27-28.1.html>`_ including all the bug fixes in it, and the latest `Galera 2.x replicator <https://code.launchpad.net/~codership/galera/2.x>`_, |Percona XtraDB Cluster| 5.5.27-23.6 is now the current stable release. All of |Percona|'s software is open-source and free.
607-
608
609=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst'
610--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst 2013-09-05 13:37:01 +0000
611+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst 1970-01-01 00:00:00 +0000
612@@ -1,56 +0,0 @@
613-.. rn:: 5.5.28-23.7
614-
615-======================================
616- |Percona XtraDB Cluster| 5.5.28-23.7
617-======================================
618-
619-Percona is glad to announce the release of |Percona XtraDB Cluster| on November 15th, 2012. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.28-23.7/>`_ or from our `software repositories <http://www.percona.com/doc/percona-xtradb-cluster/installation.html#using-percona-software-repositories>`_.
620-
621-This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
622-
623-Features
624-========
625-
626- * |Percona XtraDB Cluster| has ported Twitter's |MySQL| ``NUMA`` patch. This patch `implements improved NUMA support <http://www.percona.com/doc/percona-server/5.5/performance/innodb_numa_support.html#innodb-numa-support>`_ as it prevents imbalanced memory allocation across NUMA nodes.
627-
628- * Number of binlog files can be restricted when using |Percona XtraDB Cluster| with the new `max_binlog_files <http://www.percona.com/doc/percona-server/5.5/flexibility/max_binlog_files.html#max_binlog_files>`_ option.
629-
630- * New status variable :variable:`wsrep_incoming_addresses` has been introduced. It contains a comma-separated list of incoming (client) addresses in the cluster component.
631-
632- * Multiple addresses can now be specified in the ``gcomm:// URL`` when defining the address to connect to cluster. Option :variable:`wsrep_urls` is now deprecated, :variable:`wsrep_cluster_address` should be used to specify multiple addresses instead.
633-
634- * GTID can now be recovered by starting mysqld with ``--wsrep-recover`` option. This will parse GTID from log, and if the GTID is found, assign it as initial position for actual server start.
635-
636- * ``SET PASSWORD`` command replication has been implemented. The SET statement can contain other variables and several password changes, and each password change will be replicated separately as one TOI (total order isolation) call. The user does not have to be explicitly defined, current user will be detected and correct ``SET PASSWORD`` statement will be generated for TOI replication in every use case.
637-
638- * SQL statements aborted due to multi-master conflict can be automatically retried. This can be controlled with :variable:`wsrep_retry_autocommit` variable. The retrying will happen only if there is real abort for the SQL statement. If statement itself enters into commit phase and detects certification failure, there will be no retry.
639-
640- * This version of |Percona XtraDB Cluster| implements significant speedups and memory footprint reduction on ranged queries.
641-
642-Bugs fixed
643-==========
644-
645- * Some wsrep variables, like :variable:`wsrep_provider`, :variable:`wsrep_provider_options` and :variable:`wsrep_cluster_address`, could be "doubly" allocated which could cause memory leak. Bug fixed :bug:`1072839`.
646-
647- * In case variables :variable:`wsrep_node_address` and :variable:`wsrep_node_incoming_address` were not set explicitly, port number would be set to ``0``. Bug fixed :bug:`1071882`.
648-
649- * Server would hang before storage engine initialization with ``rsync`` SST and with option :variable:`wsrep_start_position` enabled. Bug fixed :bug:`1075495`.
650-
651- * SST script interface has been upgraded to use named instead of positional parameters. Bug fixed :bug:`1045026`.
652-
653- * When server was started with no wsrep_provider and regular |MySQL| replication slave was configured, could cause intermittent failure to start MySQL slave during startup. Bug fixed :bug:`1075617`.
654-
655- * If DDL is processing with RSU method and there is MDL conflict with local transaction, this conflict would remain unresolved. Bug fixed :bug:`1039514`.
656-
657- * Static SST method list has been removed. Bug fixed :bug:`1045040`.
658-
659- * DDL in multi-statement would cause a server crash. Bug fixed :bug:`1049024`.
660-
661- * Mysqld_safe doesn't restart the node automatically anymore. Bug fixed :bug:`1077632`.
662-
663- * Server would fail to start if the variable :variable:`wsrep_provider` was unset. Bug fixed :bug:`1077652`.
664-
665-Other bug fixes: bug :bug:`1049103`, bug :bug:`1045811`, bug :bug:`1057910`, bug :bug:`1052668`, bug :bug:`1073220`, bug :bug:`1076382`.
666-
667-Based on `Percona Server 5.5.28-29.1 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.28-29.1.html>`_ including all the bug fixes in it, |Percona XtraDB Cluster| 5.5.28-23.7 is now the current stable release. All of |Percona|'s software is open-source and free.
668-
669
670=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst'
671--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst 2013-09-05 13:37:01 +0000
672+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst 1970-01-01 00:00:00 +0000
673@@ -1,20 +0,0 @@
674-.. rn:: 5.5.29-23.7.2
675-
676-========================================
677- |Percona XtraDB Cluster| 5.5.29-23.7.2
678-========================================
679-
680-Percona is glad to announce the release of |Percona XtraDB Cluster| on February 12th, 2013. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.29-23.7.2/>`_ or from our `software repositories <http://www.percona.com/doc/percona-xtradb-cluster/installation.html#using-percona-software-repositories>`_.
681-
682-This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
683-
684-
685-Bugs fixed
686-==========
687-
688- ``DML`` operations on temporary tables would try to append the key for provider library, which could cause a memory leak. Bug fixed for |MyISAM| temporary tables, |InnoDB| temporary tables still have this issue, probably caused by upstream bug :mysqlbug:`67259`. Bug fixed :bug:`1112514` (*Seppo Jaakola*).
689-
690- Bug fix for bug :bug:`1078346` introduced a regression. Foreign key checks were skipped in the parent table, which would cause the foreign key constraint errors. Bug fixed :bug:`1117175` (*Seppo Jaakola*).
691-
692-Based on `Percona Server 5.5.29-29.4 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.29-29.4.html>`_ including all the bug fixes in it, |Percona XtraDB Cluster| 5.5.29-23.7.2 is now the current stable release. All of |Percona|'s software is open-source and free.
693-
694
695=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst'
696--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst 2013-09-05 13:37:01 +0000
697+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst 1970-01-01 00:00:00 +0000
698@@ -1,44 +0,0 @@
699-.. rn:: 5.5.29-23.7.1
700-
701-========================================
702- |Percona XtraDB Cluster| 5.5.29-23.7.1
703-========================================
704-
705-Percona is glad to announce the release of |Percona XtraDB Cluster| on January 30th, 2013. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.29-23.7.1/>`_ or from our `software repositories <http://www.percona.com/doc/percona-xtradb-cluster/installation.html#using-percona-software-repositories>`_.
706-
707-This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
708-
709-
710-Bugs fixed
711-==========
712-
713- In some cases when node is recovered variable :variable:`threads_running` would become huge. Bug fixed :bug:`1040108` (*Teemu Ollakka*).
714-
715- Variable :variable:`wsrep_defaults_file` would be set up to the value in the last configuration file read. Bug fixed by keeping the value found in the top configuration file. Bug fixed :bug:`1079892` (*Alex Yurchenko*).
716-
717- Variable :variable:`wsrep_node_name` was initialized before the ``glob_hostname``, which lead to empty value for :variable:`wsrep_node_name` if it wasn't set explicitly. Bug fixed :bug:`1081389` (*Alex Yurchenko*).
718-
719- Running ``FLUSH TABLES WITH READ LOCK`` when slave applier needed to abort transaction that is on the way caused the deadlock situation. Resolved by grabbing Global Read Lock before pausing wsrep provider. Bug fixed :bug:`1083162` (*Teemu Ollakka*).
720-
721- |Percona XtraDB Cluster| would crash when processing a delete for a table with foreign key constraint. Bug fixed :bug:`1078346` (*Seppo Jaakola*).
722-
723- When variable :variable:`innodb_support_xa` was set to ``0``, wsrep position wasn't stored into the InnoDB tablespace. Bug fixed :bug:`1084199` (*Teemu Ollakka*).
724-
725- Using |XtraBackup| for State Snapshot Transfer would fail due to ``mktemp`` error. Bug fixed :bug:`1080829` (*Alex Yurchenko*).
726-
727- |XtraBackup| donor would run |XtraBackup| indefinitely if the xtrabackup ``--tmpdir`` was on ``tmpfs``. Bug fixed :bug:`1086978` (*Alex Yurchenko*).
728-
729- In some cases non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for cascading delete operation. Bug fixed :bug:`1089490` (*Seppo Jaakola*).
730-
731- |Percona XtraDB Cluster| would crash when :variable:`binlog_format` was set to ``STATEMENT``. This was fixed by introducing the warning message. Bug fixed :bug:`1088400` (*Seppo Jaakola*).
732-
733- An explicitly set :variable:`wsrep_node_incoming_address` may make "``SHOW STATUS LIKE 'wsrep_incoming_addresses';``" return the address without the port number. Bug fixed :bug:`1082406` (*Alex Yurchenko*).
734-
735- |Percona XtraDB Cluster| would crash if the node's own address would be specified in the :variable:`wsrep_cluster_address` variable. Bug fixed :bug:`1099413`. (*Alexey Yurchenko*)
736-
737- When installing from yum repository, ``Percona-XtraDB-Cluster-server`` and ``Percona-XtraDB-Cluster-client`` would conflict with ``mysql`` and ``mysql-server`` packages. Bug fixed :bug:`1087506` (*Ignacio Nin*).
738-
739-Other bug fixes: bug fixed :bug:`1037165`, bug fixed :bug:`812059`.
740-
741-Based on `Percona Server 5.5.29-29.4 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.29-29.4.html>`_ including all the bug fixes in it, |Percona XtraDB Cluster| 5.5.29-23.7.1 is now the current stable release. All of |Percona|'s software is open-source and free.
742-
743
744=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst'
745--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst 2013-09-05 13:37:01 +0000
746+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst 1970-01-01 00:00:00 +0000
747@@ -1,84 +0,0 @@
748-.. rn:: 5.5.30-23.7.4
749-
750-========================================
751- |Percona XtraDB Cluster| 5.5.30-23.7.4
752-========================================
753-
754-Percona is glad to announce the release of |Percona XtraDB Cluster| on April 17th, 2013. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.30-23.7.4/>`_ or from our :doc:`software repositories </installation>`.
755-
756-This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
757-
758-New Features
759-============
760-
761- |Percona XtraDB Cluster| has implemented initial implementation of weighted quorum. Weight for node can be assigned via :variable:`pc.weight` option in the :variable:`wsrep_provider_options` variable. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using weighted sum over group members.
762-
763- |Percona XtraDB Cluster| binary will now be shipped with the ``libjemalloc`` library. For ``rpm/deb`` packages, this library will be available for download from our repositories. Benchmark showing the impact of memory allocators on |MySQL| performance can be found in this `blogpost <http://www.mysqlperformanceblog.com/2012/07/05/impact-of-memory-allocators-on-mysql-performance/>`_.
764-
765- This release of |Percona XtraDB Cluster| has fixed number of foreign key and packaging bugs.
766-
767-Bugs fixed
768-==========
769-
770- Fixed yum dependencies that were causing conflicts in ``CentOS`` 6.3 during installation. Bug fixed :bug:`1031427` (*Ignacio Nin*).
771-
772- In case the |Percona XtraDB Cluster| was built from the source rpm, wsrep revision information would be missing. Bug fixed :bug:`1128906` (*Alexey Bychko*).
773-
774- The method of generating md5 digest over tuples in a table with no primary key was not deterministic and this could cause a node failure. Bug fixed :bug:`1019473` (*Seppo Jaakola*).
775-
776- |Percona XtraDB Cluster| was built with YaSSL which could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL support rather than the bundled YaSSL library. Bug fixed :bug:`1104977` (*Raghavendra D Prabhu*).
777-
778- Clustercheck script would hang in case the |MySQL| server on a node is hung. As a consequence clustercheck script would never fail-over that server. Bug fixed :bug:`1035927` (*Raghavendra D Prabhu*).
779-
780- High values in variables :variable:`evs.send_window` and :variable:`evs.user_send_window` could trigger cluster crash under high load. Bug fixed :bug:`1080539` (*Teemu Ollakka*).
781-
782- Standard |MySQL| port would be used when port number isn't explicitly defined in the :variable:`wsrep_node_incoming_address`. Bug fixed :bug:`1082406` (*Alex Yurchenko*).
783-
784- Dropping a non-existing temporary table would be replicated when TOI was used in :variable:`wsrep_OSU_method` variable. This bug was fixed for the case when ``DROP TEMPORARY TABLE`` statement was used, but it will still replicate in case ``DROP TABLE`` statement is used on a temporary table. Bug fixed :bug:`1084702` (*Seppo Jaakola*).
785-
786- In case two nodes in a 3-node cluster had to abort due to inconsistency, one wouldn't correctly notify the surviving node which would lead to surviving node to loose the primary component and cause subsequent downtime. Bug fixed :bug:`1108165` (*Alex Yurchenko*).
787-
788- In some cases non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for cascading delete operation. Bug fixed :bug:`1089490` (*Seppo Jaakola*).
789-
790- Parallel applying would fail in case mixed ``CHAR`` and ``VARCHAR`` columns would be used in foreign key definitions. Bug fixed :bug:`1100496` (*Seppo Jaakola*).
791-
792- *Debian* packages included the old version of **innotop**. Fixed by removing **innotop** and its ``InnoDBParser`` Perl package from source and *Debian* installation. Bug fixed :bug:`1032139` (*Alexey Bychko*).
793-
794- The mysqld_safe script would fail to retrieve the galera replication position on ``Ubuntu`` 10.04, because the different shell was used. Bug fixed :bug:`1108431` (*Alex Yurchenko*).
795-
796- Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed :bug:`1130888` (*Seppo Jaakola*).
797-
798- If |MySQL| replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed :bug:`1132974` (*Seppo Jaakola*).
799-
800- Conflicting prepared statements in multi-master use case could cause node to hang. This was happening due to prepared statement execution loop, which does not honor wsrep status codes correctly. Bug fixed :bug:`1144911` (*Seppo Jaakola*).
801-
802- :ref:`state_snapshot_transfer` with |Xtrabackup| would fail if the ``tmpdir`` was specified more than once in the |MySQL| configuration file (:file:`my.cnf`). Bugs fixed :bug:`1160047` and :bug:`1086978` (*Raghavendra D Prabhu*).
803-
804- Issues with compiling Galera on the ``ARM`` architecture has been fixed. Bug fixed :bug:`1133047` (*Alex Yurchenko*).
805-
806- Upstream bugfix for bug :mysqlbug:`59354` triggered a regression that could cause transaction conflicts. Bug fixed :bug:`1158221` (*Seppo Jaakola*).
807-
808- Galera builds would fail when they were built with the new ``boost`` library. Bug fixed :bug:`1131736` (*Alex Yurchenko*).
809-
810- Folder ``lost+found`` wasn't included in the rsync SST filter, which caused the SST failure due to insufficient privileges. Fixed by excluding ``lost+found`` folder if found. Bug fixed :bug:`1154095` (*Alex Yurchenko*).
811-
812- If variable :variable:`innodb_thread_concurrency` has been defined to throttle |InnoDB| access, and work load contained DDL statements, a cluster node could remain hanging for unresolved MDL conflict. Fixed by adding a new method to cancel a thread waiting for |InnoDB| concurrency. Bug fixed :bug:`1155183` (*Seppo Jaakola*).
813-
814- Handling of the network issues in Galera has been improved. Bug fixed :bug:`1153727` (*Teemu Ollakka*).
815-
816- Fixed the wrong path in the ``/etc/xinetd.d/mysqlchk`` script. Bugs fixed :bug:`1000761` and :bug:`1132934` (*Raghavendra D Prabhu*).
817-
818- When upgrading the Percona-XtraDB-Cluster-server package, ``/usr/bin/clustercheck`` would get overwritten, and any changes (such as username and password) would be lost. Bug fixed :bug:`1158443` (*Raghavendra D Prabhu*).
819-
820- In case ``CREATE TABLE AS SELECT`` statement was running in parallel with the DDL statement on the selected table, in some cases first statement could be left hanging. Bug fixed :bug:`1164893` (*Seppo Jaakola*).
821-
822- Galera builds would fail when ``gcc`` 4.8 was used. Bug fixed :bug:`1164992` (*Alex Yurchenko*).
823-
824- ``Percona-XtraDB-Cluster-galera`` package version number didn't match the :variable:`wsrep_provider_version` one. Bug fixed :bug:`1111672` (*Alexey Bychko*).
825-
826- Only ``rpm`` debug build was available for |Percona XtraDB Cluster|, fixed by providing the ``deb`` debug build as well. Bug fixed :bug:`1096123` (*Ignacio Nin*).
827-
828-Other bug fixes: bug fixed :bug:`1162421` (*Seppo Jaakola*), bug fixed :bug:`1093054` (*Alex Yurchenko*), bug fixed :bug:`1166060` (*Teemu Ollakka*), bug fixed :bug:`1166065` (*Teemu Ollakka*).
829-
830-Based on `Percona Server 5.5.30-30.2 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.30-30.2.html>`_ including all the bug fixes in it and on `Codership wsrep API 5.5.30-23.7.4 <https://launchpad.net/codership-mysql/+milestone/5.5.30-23.7.4>`_, |Percona XtraDB Cluster| 5.5.30-23.7.4 is now the current stable release. All of |Percona|'s software is open-source and free.
831-
832
833=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst'
834--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst 2013-09-05 13:37:01 +0000
835+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst 1970-01-01 00:00:00 +0000
836@@ -1,73 +0,0 @@
837-.. rn:: 5.5.31-23.7.5
838-
839-========================================
840- |Percona XtraDB Cluster| 5.5.31-23.7.5
841-========================================
842-
843-Percona is glad to announce the release of |Percona XtraDB Cluster| on June 24th, 2013. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.31-23.7.5/>`_ or from our :doc:`software repositories </installation>`.
844-
845-This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
846-
847-New Features
848-============
849-
850- Information about the wsrep sequence number has been added to ``INFORMATION_SCHEMA`` :table:`INNODB_TRX` table.
851-
852- |Percona XtraDB Cluster| can now be :ref:`bootstrapped <bootstrap>` with the new ``bootstrap-pxc`` option in the init script.
853-
854- |Percona XtraDB Cluster| has implemented parallel copying for rsync :ref:`state_snapshot_transfer` method. Bug fixed :bug:`1167331` (*Mrten*).
855-
856- |Percona XtraDB Cluster| has implemented new *Python* version of the `clustercheck <https://github.com/Oneiroi/clustercheck>`_ script.
857-
858- |Percona XtraDB Cluster| now has better integration with |Percona XtraBackup| 2.1 by implementing new ``xbstream`` option for xtrabackup :ref:`state_snapshot_transfer` method.
859-
860-
861-Bugs fixed
862-==========
863-
864- Fixed the packaging issues that caused |Percona XtraDB Cluster| to conflict with |MySQL| libraries when performing fresh *CentOS* installation. Bug fixed :bug:`1183669`.
865-
866- The RPM installer script had the :term:`datadir` hardcoded to :file:`/var/lib/mysql` instead of ``using my_print_defaults`` to get the datadir info. bug fixed :bug:`1172621`.
867-
868- Fixed the package conflict for ``percona-xtradb-cluster-client-5.5`` package. Bug fixed :bug:`1172621`.
869-
870- Fixed the ``Percona-Server-shared-55`` and ``Percona-XtraDB-Cluster-shared`` ``RPM`` package dependences. Bug fixed :bug:`1050654`.
871-
872- ``mysql_tzinfo_to_sql`` script failed with |Percona XtraDB Cluster| since |MyISAM| DDL/DML were not consistently replicated. Fixed by enabling session variable :variable:`wsrep_replicate_myisam` in the generator file. Bug fixed :bug:`1161432`.
873-
874- Startup script on *Debian* and *Ubuntu* was failing prematurely during ``SST``. Bug fixed :bug:`1099428`.
875-
876- Due to *Debian* way of stopping/reloading/status checking, there was failure after SST since the machine-specific *Debian* maintenance password didn't work. Fixes by using signals instead of ``mysqladmin`` as it is done in *CentOS*. Bug fixed :bug:`1098360`.
877-
878- :variable:`wsrep-recover` would create ``ibdata1`` and ``ib_logfile*`` files which the SST after that would remove. Bug fixed :bug:`1191767`.
879-
880- When running :variable:`wsrep_recover` to recover galera co-ordinates, LRU recover (and its blocking counterpart) were causing issues. Bug fixed :bug:`1108035`.
881-
882- |Percona XtraDB Cluster| improved status visibility in the ``processlist`` on other nodes when provider is locked with ``FLUSH TABLES WITH READ LOCK`` on one of them. Bug fixed :bug:`1109341`.
883-
884-Crash/stalling bugs
885--------------------
886-
887- |Percona Server| `Crash-Resistant Replication <http://www.percona.com/doc/percona-server/5.5/reliability/crash_resistant_replication.html>`_ was causing conflicts with :variable:`wsrep_crash_recovery` on a node which is a slave to an async master in standard |MySQL| replication. Bugs fixed :bug:`1182441` and :bug:`1180802`.
888-
889- |Percona XtraDB Cluster| node would hang on shutdown when :variable:`thread_handling` was set to `pool-of-threads <http://www.percona.com/doc/percona-server/5.5/performance/threadpool.html#thread-pool>`_. Bug Fixed :bug:`1185523`.
890-
891- ``FLUSH TABLES WITH READ LOCK`` didn't behave as expected, it had different behavior than the upstream |MySQL| version. Bug fixed :bug:`1170821`.
892-
893- When rsync :ref:`state_snapshot_transfer` failed, the rsync daemon would remain running which caused ``pid`` errors on subsequent ``SST`` retries. Bug fixed :bug:`1169676`.
894-
895- When doing cascading Foreign Key processing |Percona XtraDB Cluster| was doing unnecessary Foreign Key checks, which are needed only for the purpose of getting Foreign Key parent reference for child table modifications. Bug fixed :bug:`1134892`.
896-
897- High priority threads (slave threads, replaying threads, total order isolation threads) were not protected from kill signal and attempt to kill high priority thread could cause server to hang. Bug fixed :bug:`1088267`.
898-
899- Galera provider may deadlock if applier thread is still executing ``apply_trx()`` while processing commit, it could cause corresponding transaction to be purged from cert index.
900-
901-Regressions
902------------
903-
904- Previous |Percona XtraDB Cluster| release introduced the regression in the RPM packaging that prevented the server from restarting following an upgrade. Bug fixed :bug:`1168032`.
905-
906-Other bug fixes: bug fixed :bug:`1187526`, bug fixed :bug:`1133266`, bug fixed :bug:`1079688`, bug fixed :bug:`1177211`, bug fixed :bug:`1166423`, bug fixed :bug:`1084573`, bug fixed :bug:`1069829`, bug fixed :bug:`1012138`, bug fixed :bug:`1170066`, bug fixed :bug:`1170706`, bug fixed :bug:`1182187`, bug fixed :bug:`1183530`, bug fixed :bug:`1183997`, bug fixed :bug:`1184034`, bug fixed :bug:`1191763`, bug fixed :bug:`1069829`.
907-
908-Based on `Percona Server 5.5.31-30.3 <http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.31-30.3.html>`_ including all the bug fixes in it and on `Codership wsrep API 5.5.31-23.7.5 <https://launchpad.net/codership-mysql/+milestone/5.5.31-23.7.5>`_, |Percona XtraDB Cluster| `5.5.31-23.7.5 <https://launchpad.net/percona-xtradb-cluster/+milestone/5.5.31-23.7.5>`_ is now the current stable release. All of |Percona|'s software is open-source and free.
909-
910
911=== added file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst'
912--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst 1970-01-01 00:00:00 +0000
913+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst 2013-11-21 11:30:55 +0000
914@@ -0,0 +1,78 @@
915+.. rn:: 5.6.14-25.1
916+
917+======================================
918+ |Percona XtraDB Cluster| 5.6.14-25.1
919+======================================
920+
921+Percona is glad to announce the first Beta release of |Percona XtraDB Cluster| 5.6 on November 21st, 2013. Binaries are available from `downloads area <http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.6.14-25.1/>`_ or from our :doc:`software repositories </installation>`.
922+
923+Based on `Percona Server 5.6.14-62.0 <http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.14-62.0.html>`_ including all the bug fixes in it, `Galera Replicator 3.1 <https://launchpad.net/galera/3.x/25.3.1>`_ and on `Codership wsrep API 5.6.14-25.1 <https://launchpad.net/codership-mysql/5.6/5.6.14-25.1>`_ is now the first **BETA** release. All of |Percona|'s software is open-source and free, all the details of the release can be found in the `5.6.14-25.1 milestone <https://launchpad.net/percona-xtradb-cluster/+milestone/5.6.14-25.1>`_ at Launchpad.
924+
925+This release contains all of the features and bug fixes in `Percona XtraDB Cluster 5.5.34-23.7.6 <http://www.percona.com/doc/percona-xtradb-cluster/release-notes/Percona-XtraDB-Cluster-5.5.34-23.7.6.html>`_, plus the following:
926+
927+New Features
928+============
929+
930+ |Percona XtraDB Cluster| is now using `Galera Replicator 3.1 <https://launchpad.net/galera/3.x/25.3.1>`_ and `Codership wsrep API 5.6.14-25.1 <https://launchpad.net/codership-mysql/5.6/5.6.14-25.1>`_.
931+
932+ |Percona XtraDB Cluster| has implemented a number of `XtraDB performance improvements <http://www.percona.com/doc/percona-server/5.6/performance/xtradb_performance_improvements_for_io-bound_highly-concurrent_workloads.html>`_ for I/O-bound high-concurrency workloads.
933+
934+ |Percona XtraDB Cluster| has implemented a number of performance improvements for `Page cleaner thread tuning <http://www.percona.com/doc/percona-server/5.6/performance/page_cleaner_tuning.html#page-cleaner-tuning>`_.
935+
936+ ``ALL_O_DIRECT`` method for `innodb_flush_method <http://www.percona.com/doc/percona-server/5.6/scalability/innodb_io.html#innodb_flush_method>`_ has been ported from 5.5 version.
937+
938+ `Statement Timeout <http://www.percona.com/doc/percona-server/5.6/management/statement_timeout.html#statement-timeout>`_ feature has been ported from the Twitter branch.
939+
940+ |Percona XtraDB Cluster| has `extended <http://www.percona.com/doc/percona-server/5.6/flexibility/extended_select_into_outfile.html#extended-select-into-outfile>`_ the ``SELECT INTO ... OUTFILE`` and ``SELECT INTO DUMPFILE`` to add the support for ``UNIX`` sockets and named pipes.
941+
942+ |Percona XtraDB Cluster| has implemented more efficient log block checksums with new `innodb_log_checksum_algorithm <http://www.percona.com/doc/percona-server/5.6/scalability/innodb_io.html#innodb_log_checksum_algorithm>`_ variable.
943+
944+ |Percona XtraDB Cluster| now supports `Per-query variable statements <http://www.percona.com/doc/percona-server/5.6/flexibility/per_query_variable_statement.html#per-query-variable-statement>`_.
945+
946+ Limited support for Query Cache has been implemented. Query cache cannot still be fully enabled during the startup. To enable query cache, ``mysqld`` should be started with ``query_cache_type=1`` and ``query_cache_size=0`` and then query_cache_size should be changed to desired value during runtime.
947+
948+ ``RPM`` packages are now made `relocatable <http://rpm5.org/docs/api/relocatable.html>`_ which means they now support installation to custom prefixes.
949+
950+Bugs fixed
951+==========
952+
953+ Some wsrep variables (:variable:`wsrep_provider`, :variable:`wsrep_provider_options`, :variable:`wsrep_cluster_address`...) could be "doubly" allocated which caused memory leaks. Bug fixed :bug:`1072839`.
954+
955+ If ``SELECT FOR UPDATE...`` query was aborted due to multi-master conflict, the client wouldn't get back the deadlock error. From client perspective the transaction would be successful. Bug fixed :bug:`1187739`.
956+
957+ Temporary tables are not replicated, but any DDL on those tables were, which would generates error messages on other nodes. Bugs fixed :bug:`1194156`, :bug:`1084702`, :bug:`1212247`.
958+
959+ When setting the :variable:`gcache.size` to a larger value than the default 128M, the mysql service command did not allow enough time for the file to be preallocated. Bug fixed :bug:`1207500`.
960+
961+ When installing first ``Percona-XtraDB-Cluster-client`` and then ``Percona-XtraDB-Cluster-server`` on two single statements or a single statement with both packages , yum would install ``percona-xtrabackup-20`` instead ``percona-xtrabackup`` package as dependency of ``Percona-XtraDB-Cluster-server``. Bug fixed :bug:`1226185`.
962+
963+ Different mutex implementation in the 5.6 could lead to server assertion error. Bug fixed :bug:`1233383`.
964+
965+ Enabling :variable:`wsrep_log_conflicts` variable could cause issues with ``lock_mutex``. Bug fixed :bug:`1234382`.
966+
967+ Server could freeze with mixed DML/DDL load because TOI brute force aborts were not properly propagated. Bug fixed :bug:`1239571`.
968+
969+ ``CREATE TABLE AS SELECT`` would fail with explicit temporary tables, when was binlogging enabled and :variable:`autocommit` was set to ``0``. Bug fixed :bug:`1240098`.
970+
971+ Transaction cleanup function did not get called for autocommit statements after rollback, it would stay in ``LOCAL_COMMIT`` even after rollback finished which caused problems when the next transaction started. Bug fixed :bug:`1240567`.
972+
973+ ``DDL`` statements like ``CREATE TEMPORARY TABLE LIKE`` would be replicated and applied in all cluster nodes. This caused temporary table definitions to pile up in slave threads. Bug fixed :bug:`1246257`.
974+
975+ ``CREATE TABLE AS SELECT`` was not replicated, if the select result set was empty. Bug fixed :bug:`1246921`.
976+
977+ Write set flags defined in wsrep API are now exposed to application side appliers too. Bug fixed :bug:`1247402`.
978+
979+ Local brute force aborts are counted accurately. Bug fixed :bug:`1247971`.
980+
981+ Certain combinations of transaction rollbacks could leave stale transactional ``MDL`` locks. Bug fixed :bug:`1247978`.
982+
983+ After turning ``UNIV_SYNC_DEBUG`` on, node that was started from clean state would crash immediately at startup. Bug fixed :bug:`1248908`.
984+
985+ Server built with ``UNIV_SYNC_DEBUG`` would assert if SQL load has ``DELETE`` statements on tables with foreign key constraints with ``ON DELETE CASCADE`` option. Bug fixed :bug:`1248921`.
986+
987+ Xtrabackup SST dependencies have been added as Optional/Recommended/Suggested dependencies. Bug fixed :bug:`1250326`.
988+
989+Other bugs fixed: bug fixed :bug:`1020457`, bug fixed :bug:`1250865`, bug fixed :bug:`1249753`, bug fixed :bug:`1248396`, bug fixed :bug:`1247980`, bug fixed :bug:`1238278`, bug fixed :bug:`1234421`, bug fixed :bug:`1228341`, bug fixed :bug:`1228333`, bug fixed :bug:`1225236`, bug fixed :bug:`1221354`, bug fixed :bug:`1217138`, bug fixed :bug:`1206648`, bug fixed :bug:`1200647`, bug fixed :bug:`1180792`, bug fixed :bug:`1163283`, bug fixed :bug:`1234229`, bugs fixed :bug:`1250805`, bug fixed :bug:`1233301`, and bug fixed :bug:`1210509`.
990+
991+We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our `bug tracking system <https://bugs.launchpad.net/percona-xtradb-cluster/+filebug>`_.
992+
993
994=== modified file 'doc-pxc/source/release-notes/release-notes_index.rst'
995--- doc-pxc/source/release-notes/release-notes_index.rst 2013-09-05 13:37:01 +0000
996+++ doc-pxc/source/release-notes/release-notes_index.rst 2013-11-21 11:30:55 +0000
997@@ -1,17 +1,9 @@
998-======================================
999-|Percona XtraDB Cluster| Release notes
1000-======================================
1001+============================================
1002+ |Percona XtraDB Cluster| 5.6 Release notes
1003+============================================
1004
1005 .. toctree::
1006 :maxdepth: 1
1007 :glob:
1008
1009- Percona-XtraDB-Cluster-5.5.31-23.7.5
1010- Percona-XtraDB-Cluster-5.5.30-23.7.4
1011- Percona-XtraDB-Cluster-5.5.29-23.7.2
1012- Percona-XtraDB-Cluster-5.5.29
1013- Percona-XtraDB-Cluster-5.5.28
1014- Percona-XtraDB-Cluster-5.5.27
1015- Percona-XtraDB-Cluster-5.5.24
1016- Percona-XtraDB-Cluster-5.5.23
1017-
1018+ Percona-XtraDB-Cluster-5.6.14-25.1
1019
1020=== added file 'doc-pxc/source/upgrading_guide_55_56.rst'
1021--- doc-pxc/source/upgrading_guide_55_56.rst 1970-01-01 00:00:00 +0000
1022+++ doc-pxc/source/upgrading_guide_55_56.rst 2013-11-21 11:30:55 +0000
1023@@ -0,0 +1,119 @@
1024+.. _upgrading_guide:
1025+
1026+==================================================================
1027+ Percona XtraDB Cluster In-Place Upgrading Guide: From 5.5 to 5.6
1028+==================================================================
1029+
1030+Upgrading cluster involves two major stages:
1031+
1032+I) Upgrade a single node
1033+II) Upgrade the whole cluster while not breaking replication
1034+
1035+Following is the upgrade process on CentOS 6.4
1036+==============================================
1037+
1038+**Step #1** Make sure all the nodes in cluster are upgraded to the latest 5.5 version and are in synced state.
1039+
1040+Stage I
1041+--------
1042+Assuming we are going to upgrade node A, (and other nodes B and C are on 5.5)
1043+
1044+**Step #2** On node A stop the mysql process and remove the old packages: ::
1045+
1046+ # service mysql stop
1047+ # yum remove 'Percona*'
1048+
1049+**Step #3** Install the new packages: ::
1050+
1051+ # yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56 percona-xtrabackup
1052+
1053+**Step #4** Fix the variables in the |MySQL| configuration file :file:`my.cnf` which are not compatible with |Percona Server| 5.6. Detailed list can be checked in `Changed in Percona Server 5.6 <http://www.percona.com/doc/percona-server/5.6/changed_in_56.html>`_ documentation. Add the following to :file:`my.cnf` for compatibility with 5.5 replication for the duration of upgrade, add 'socket.checksum=1' to the :variable:`wsrep_provider_options` variable, and set the following options: ::
1054+
1055+ wsrep_provider_options="socket.checksum=1"
1056+ log_bin_use_v1_row_events=1
1057+ gtid_mode=0
1058+ binlog_checksum=NONE
1059+ wsrep-slave-threads=1
1060+ read_only=ON
1061+
1062+**Step #5** Next, start the node with the variable :variable:`wsrep_provider` set to ``none``: ::
1063+
1064+ # mysqld --skip-grant-tables --user=mysql --wsrep-provider='none'
1065+
1066+This is to ensure that other hosts are not affected by this upgrade.
1067+
1068+**Step #6** While Step #5 is running, in the background or in another session run: ::
1069+
1070+ # mysql_upgrade
1071+
1072+**Step #7** Step #5 must complete successfully, upon which, process started in Step 5) can be stopped/killed.
1073+
1074+
1075+**Step #8** Step #5) should not fail (if it fails check for any bad variables in the configuration file), otherwise :file:`grastate.dat` can potentially get zeroed and the node will try to perform State Snapshot Transfer from a 5.5 node. ('Potentially' since with --wsrep-provider='none' it shouldn't). Also backing up :file:`grastate.dat` is recommended prior to Step #5 for the same purpose.
1076+
1077+**Step #9** If all the steps above have completed successfully node can be started with: ::
1078+
1079+ # service mysql start
1080+
1081+**Step #10** At this point, other nodes (B, C) should acknowledge that this node is up and synced!
1082+
1083+Stage II
1084+---------
1085+
1086+**Step #11** After this has been set up all 5.5 nodes can be upgraded, one-by-one, as described in the Stage I.
1087+
1088+ a) After all nodes in the cluster are upgraded to 5.6, option :variable:`read_only` should be set to ``OFF``.
1089+
1090+ b) Nodes should be restarted with compatibility options added earlier removed/updated for optimal performance (though cluster will continue run with those options).
1091+
1092+Following is the upgrade process on Ubuntu 12.04 (precise)
1093+==========================================================
1094+
1095+**Step #1** Make sure all the nodes in cluster are upgraded to the latest 5.5 version and are in synced state.
1096+
1097+Stage I
1098+--------
1099+Assuming we are going to upgrade node A, (and other nodes B and C are on 5.5)
1100+
1101+**Step #2** On node A stop the mysql process and remove the old packages: ::
1102+
1103+ # /etc/init.d/mysql stop
1104+ # apt-get remove percona-xtradb-cluster-server-5.5 percona-xtradb-cluster-galera-2.x percona-xtradb-cluster-common-5.5 percona-xtradb-cluster-client-5.5
1105+
1106+**Step #3** Fix the variables in the |MySQL| configuration file :file:`my.cnf` which are not compatible with |Percona Server| 5.6. Detailed list can be checked in `Changed in Percona Server 5.6 <http://www.percona.com/doc/percona-server/5.6/changed_in_56.html>`_ documentation. Add the following to :file:`my.cnf` for compatibility with 5.5 replication for the duration of upgrade, add 'socket.checksum=1' to the :variable:`wsrep_provider_options` variable and set :variable:`wsrep_provider` set to ``none`` ::
1107+
1108+ wsrep_provider_options="socket.checksum=1"
1109+ wsrep_provider=none
1110+ log_bin_use_v1_row_events=1
1111+ gtid_mode=0
1112+ binlog_checksum=NONE
1113+ wsrep-slave-threads=1
1114+
1115+**Step #4** Install the new packages: ::
1116+
1117+ # apt-get install percona-xtradb-cluster-server-5.6 percona-xtradb-cluster-client-5.6 percona-xtrabackup
1118+
1119+**Step #5** After node has been started you'll need to run ``mysql_upgrade``: ::
1120+
1121+ # mysql_upgrade
1122+
1123+**Step #6** Step #5) should not fail (if it fails check for any bad variables in the configuration file), otherwise :file:`grastate.dat` can potentially get zeroed and the node will try to perform State Snapshot Transfer from a 5.5 node. ('Potentially' since with --wsrep-provider='none' it shouldn't). Also backing up :file:`grastate.dat` is recommended prior to Step #5 for the same purpose.
1124+
1125+
1126+**Step #7** If all the steps above have completed successfully, set the :variable:`wsrep_provider` to the location of the Galera library, and node can be started with: ::
1127+
1128+ # service mysql start
1129+
1130+**Step #8** At this point, other nodes (B, C) should acknowledge that this node is up and synced!
1131+
1132+Stage II
1133+---------
1134+
1135+**Step #9** After this has been set up all 5.5 nodes can be upgraded, one-by-one, as described in the Stage I.
1136+
1137+ a) After all nodes in the cluster are upgraded to 5.6, option :variable:`read_only` should be set to ``OFF``.
1138+
1139+ b) Nodes should be restarted with compatibility options added earlier removed/updated for optimal performance (though cluster will continue run with those options).
1140+
1141+
1142+

Subscribers

People subscribed via source and target branches