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
=== modified file 'doc-pxc/source/conf.py'
--- doc-pxc/source/conf.py 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/conf.py 2013-11-21 11:30:55 +0000
@@ -53,9 +53,9 @@
53# built documents.53# built documents.
54#54#
55# The short X.Y version.55# The short X.Y version.
56version = '5.5.31'56version = '5.6.14'
57# The full version, including alpha/beta/rc tags.57# The full version, including alpha/beta/rc tags.
58release = '5.5.31-23.7.5'58release = '5.6.14-25.1'
5959
60# The language for content autogenerated by Sphinx. Refer to documentation60# The language for content autogenerated by Sphinx. Refer to documentation
61# for a list of supported languages.61# for a list of supported languages.
@@ -171,7 +171,7 @@
171html_title = 'Percona XtraDB Cluster Documentation'171html_title = 'Percona XtraDB Cluster Documentation'
172172
173# A shorter title for the navigation bar. Default is the same as html_title.173# A shorter title for the navigation bar. Default is the same as html_title.
174html_short_title = 'XtraDB Cluster Docs'174html_short_title = 'Percona XtraDB Cluster 5.6 Documentation'
175175
176# The name of an image file (relative to this directory) to place at the top176# The name of an image file (relative to this directory) to place at the top
177# of the sidebar.177# of the sidebar.
@@ -244,7 +244,7 @@
244# Grouping the document tree into LaTeX files. List of tuples244# Grouping the document tree into LaTeX files. List of tuples
245# (source start file, target name, title, author, documentclass [howto/manual]).245# (source start file, target name, title, author, documentclass [howto/manual]).
246latex_documents = [246latex_documents = [
247 ('index', 'PerconaXtraDBCluster.tex', u'Percona XtraDB Cluster Documentation',247 ('index', 'PerconaXtraDBCluster-5.6.tex', u'Percona XtraDB Cluster Documentation',
248 u'Percona Ireland Ltd. 2012-2013', 'manual'),248 u'Percona Ireland Ltd. 2012-2013', 'manual'),
249]249]
250250
251251
=== added file 'doc-pxc/source/errata.rst'
--- doc-pxc/source/errata.rst 1970-01-01 00:00:00 +0000
+++ doc-pxc/source/errata.rst 2013-11-21 11:30:55 +0000
@@ -0,0 +1,23 @@
1.. _errata:
2
3===============================
4 Percona XtraDB Cluster Errata
5===============================
6
7Known Issues
8-------------
9
10Following are issues which may impact you while running PXC:
11 - wsrep_causal_reads being ON can introduce temporary stalls due to MDL lock conflicts.
12 - Create Table As Select (CTAS) can cause deadlocks and server hang when used with explicit TEMPORARY tables.
13 - 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.
14 - 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.
15 - 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.
16
17Also 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).
18
19Incompatibilities
20-------------------
21
22Following are incompatibilities between PXC 5.5.33 (and higher) and older versions:
23 - 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.
024
=== modified file 'doc-pxc/source/howtos/cenots_howto.rst'
--- doc-pxc/source/howtos/cenots_howto.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/howtos/cenots_howto.rst 2013-11-21 11:30:55 +0000
@@ -37,7 +37,7 @@
3737
38Following command will install |Percona XtraDB Cluster| packages: :: 38Following command will install |Percona XtraDB Cluster| packages: ::
3939
40 $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client40 $ yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56
4141
42When these two commands have been executed successfully on all three nodes |Percona XtraDB Cluster| is installed.42When these two commands have been executed successfully on all three nodes |Percona XtraDB Cluster| is installed.
4343
4444
=== modified file 'doc-pxc/source/index.rst'
--- doc-pxc/source/index.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/index.rst 2013-11-21 11:30:55 +0000
@@ -3,29 +3,33 @@
3 You can adapt this file completely to your liking, but it should at least3 You can adapt this file completely to your liking, but it should at least
4 contain the root `toctree` directive.4 contain the root `toctree` directive.
55
6==================================================6==========================================
7Welcome to Percona XtraDB Cluster's documentation!7 Percona XtraDB Cluster 5.6 Documentation
8==================================================8==========================================
99
10Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users.10.. warning::
1111
12Percona XtraDB Cluster provides:12 Please note: |Percona XtraDB Cluster| 5.6 is BETA quality software. It should *NOT* be used in production environments.
13
14|Percona XtraDB Cluster| is High Availability and Scalability solution for MySQL Users.
15
16|Percona XtraDB Cluster| provides:
13 17
14 * Synchronous replication. Transaction either commited on all nodes or none.18 * Synchronous replication. Transaction either committed on all nodes or none.
1519
16 * Multi-master replication. You can write to any node.20 * Multi-master replication. You can write to any node.
1721
18 * Parallel applying events on slave. Real “parallel replication”.22 * Parallel applying events on slave. Real "parallel replication".
1923
20 * Automatic node provisioning.24 * Automatic node provisioning.
2125
22 * Data consistency. No more unsynchronized slaves.26 * Data consistency. No more unsynchronized slaves.
2327
24Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning:28|Percona XtraDB Cluster| is fully compatible with |MySQL| or |Percona Server| in the following meaning:
2529
26 * Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server30 * Data compatibility. |Percona XtraDB Cluster| works with databases created in |MySQL| / |Percona Server|.
2731
28 * Application compatibility. There is no or minimal application changes required to start work with Percona XtraDB Cluster32 * Application compatibility. There is no or minimal application changes required to start work with |Percona XtraDB Cluster|.
2933
3034
31Introduction35Introduction
@@ -37,6 +41,7 @@
3741
38 intro42 intro
39 limitation43 limitation
44 errata
4045
41Installation46Installation
42============47============
@@ -47,6 +52,7 @@
4752
48 installation53 installation
49 installation/compiling_xtradb_cluster54 installation/compiling_xtradb_cluster
55 upgrading_guide_55_56
5056
51Features57Features
52========58========
5359
=== modified file 'doc-pxc/source/installation.rst'
--- doc-pxc/source/installation.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/installation.rst 2013-11-21 11:30:55 +0000
@@ -33,7 +33,7 @@
3333
34Once the repository is set up, use the following commands: ::34Once the repository is set up, use the following commands: ::
3535
36 $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client36 $ yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56
3737
38More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`centos_howto` tutorial.38More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`centos_howto` tutorial.
3939
@@ -42,7 +42,7 @@
4242
43Once the repository is set up, use the following commands: ::43Once the repository is set up, use the following commands: ::
4444
45 $ sudo apt-get install percona-xtradb-cluster-server-5.5 percona-xtradb-cluster-client-5.545 $ sudo apt-get install percona-xtradb-cluster-server-5.6 percona-xtradb-cluster-client-5.6
4646
47More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`ubuntu_howto` tutorial.47More detailed example of the |Percona XtraDB Cluster| installation and configuration can be seen in :ref:`ubuntu_howto` tutorial.
4848
4949
=== modified file 'doc-pxc/source/installation/apt_repo.rst'
--- doc-pxc/source/installation/apt_repo.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/installation/apt_repo.rst 2013-11-21 11:30:55 +0000
@@ -39,6 +39,7 @@
39 * 12.04LTS precise39 * 12.04LTS precise
40 * 12.10 quantal40 * 12.10 quantal
41 * 13.04 raring41 * 13.04 raring
42 * 13.10 saucy
4243
4344
44Install XtraDB Cluster45Install XtraDB Cluster
@@ -46,8 +47,7 @@
4647
47Following command will install Cluster packages: :: 48Following command will install Cluster packages: ::
4849
49 $ sudo apt-get install percona-xtradb-cluster-client-5.5 \50 $ sudo apt-get install percona-xtradb-cluster-client-5.6 percona-xtradb-cluster-server-5.6
50 percona-xtradb-cluster-server-5.5 percona-xtrabackup
5151
52Percona `apt` Experimental repository52Percona `apt` Experimental repository
53=====================================53=====================================
5454
=== modified file 'doc-pxc/source/installation/compiling_xtradb_cluster.rst'
--- doc-pxc/source/installation/compiling_xtradb_cluster.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/installation/compiling_xtradb_cluster.rst 2013-11-21 11:30:55 +0000
@@ -4,7 +4,7 @@
44
5The 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: ::5The 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: ::
66
7 bzr branch lp:percona-xtradb-cluster7 bzr branch lp:percona-xtradb-cluster/5.6
88
9You should then have a directory named after the release you branched, such as ``percona-xtradb-cluster``.9You should then have a directory named after the release you branched, such as ``percona-xtradb-cluster``.
1010
1111
=== modified file 'doc-pxc/source/installation/yum_repo.rst'
--- doc-pxc/source/installation/yum_repo.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/installation/yum_repo.rst 2013-11-21 11:30:55 +0000
@@ -30,7 +30,11 @@
3030
31Following command will install Cluster packages: ::31Following command will install Cluster packages: ::
3232
33 $ yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client xtrabackup33 $ yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56 percona-xtrabackup
34
35.. warning::
36
37 In order to sucessfully install |Percona XtraDB Cluster| ``socat`` package will need to be installed first.
3438
35Percona `yum` Experimental repository39Percona `yum` Experimental repository
36=====================================40=====================================
3741
=== modified file 'doc-pxc/source/intro.rst'
--- doc-pxc/source/intro.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/intro.rst 2013-11-21 11:30:55 +0000
@@ -49,14 +49,14 @@
49Components49Components
50==========50==========
5151
52*Percona XtraDB Cluster* is based on `Percona Server with XtraDB <http://www.percona.com/software/percona-server/>`_52|Percona XtraDB Cluster| is based on `Percona Server with XtraDB <http://www.percona.com/software/percona-server/>`_
53and includes `Write Set Replication patches <https://launchpad.net/codership-mysql>`_.53and includes `Write Set Replication patches <https://launchpad.net/codership-mysql>`_.
54It uses the `Galera library <https://launchpad.net/galera>`_, version 2.x, 54It uses the `Galera library <https://launchpad.net/galera>`_, version 3.x,
55a generic Synchronous Multi-Master replication plugin for transactional applications. 55a generic Synchronous Multi-Master replication plugin for transactional applications.
5656
57Galera library is developed by `Codership Oy <http://www.codership.com/>`_.57Galera library is developed by `Codership Oy <http://www.codership.com/>`_.
5858
59Galera 2.x supports such new features as:59Galera 3.x supports such new features as:
60 * Incremental State Transfer (|IST|), especially useful for WAN deployments,60 * Incremental State Transfer (|IST|), especially useful for WAN deployments,
61 * RSU, Rolling Schema Update. Schema change does not block operations against table.61 * RSU, Rolling Schema Update. Schema change does not block operations against table.
6262
6363
=== modified file 'doc-pxc/source/limitation.rst'
--- doc-pxc/source/limitation.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/limitation.rst 2013-11-21 11:30:55 +0000
@@ -9,14 +9,16 @@
9 - 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.9 - 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.
1010
11 - Unsupported queries:11 - Unsupported queries:
12 * LOCK/UNLOCK TABLES cannot be supported in multi-master setups.12
13 * ``LOCK/UNLOCK TABLES`` cannot be supported in multi-master setups.
13 * lock functions (GET_LOCK(), RELEASE_LOCK()... )14 * lock functions (GET_LOCK(), RELEASE_LOCK()... )
1415
15 - 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.16 - 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.
1617
17 - 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.18 - 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.
1819
19 - 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: 20 - 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: ::
21
20 (Error: 1213 SQLSTATE: 40001 (ER_LOCK_DEADLOCK)).22 (Error: 1213 SQLSTATE: 40001 (ER_LOCK_DEADLOCK)).
2123
22 - XA transactions can not be supported due to possible rollback on commit.24 - XA transactions can not be supported due to possible rollback on commit.
2325
=== modified file 'doc-pxc/source/manual/bootstrap.rst'
--- doc-pxc/source/manual/bootstrap.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/manual/bootstrap.rst 2013-11-21 11:30:55 +0000
@@ -34,11 +34,6 @@
3434
35This 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. 35This 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.
3636
37Version Specific Information
38============================
39
40 * :rn:`5.5.31-23.7.5` - New bootstrap init script option ``bootstrap-pxc`` introduced.
41
42Other Reading37Other Reading
43=============38=============
4439
4540
=== modified file 'doc-pxc/source/manual/state_snapshot_transfer.rst'
--- doc-pxc/source/manual/state_snapshot_transfer.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/manual/state_snapshot_transfer.rst 2013-11-21 11:30:55 +0000
@@ -20,32 +20,21 @@
2020
21 innobackupex --user=root --password=Passw0rd /tmp/21 innobackupex --user=root --password=Passw0rd /tmp/
22 22
23Script used for this method can be found in :file:`/usr/bin/wsrep_sst_xtrabackup` and it's provided with the |PXC| binary packages.23Script 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.
24
25After :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: ::
26
27 [sst]
28 streamfmt=xbstream
29
30Currently 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.
31
32.. note::
33
34 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.
3524
36Using ``mysqldump``25Using ``mysqldump``
37===================26===================
3827
39This 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.28This 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.
4029
41Script used for this method can be found in :file:`/usr/bin/wsrep_sst_mysqldump` and it's provided with the |PXC| binary packages.30Script 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.
4231
43Using ``rsync``32Using ``rsync``
44===============33===============
4534
46This 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`.35This 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`.
4736
48Script used for this method can be found in :file:`/usr/bin/wsrep_sst_rsync` and it's provided with the |PXC| binary packages.37Script 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.
4938
50Other Reading39Other Reading
51=============40=============
5241
=== modified file 'doc-pxc/source/manual/xtrabackup_sst.rst'
--- doc-pxc/source/manual/xtrabackup_sst.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/manual/xtrabackup_sst.rst 2013-11-21 11:30:55 +0000
@@ -4,6 +4,17 @@
4 Xtrabackup SST Configuration4 Xtrabackup SST Configuration
5===============================5===============================
66
7XtraBackup SST works in two stages:
8
9 * Stage I on joiner checks if it is |SST| or |IST| based on presence of :file:`xtrabackup_ist` file.
10 * 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.
11
12.. note::
13
14 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
15
16Latest |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.
17
7Following SST specific options are allowed in my.cnf under [sst] 18Following SST specific options are allowed in my.cnf under [sst]
8-----------------------------------------------------------------19-----------------------------------------------------------------
9 20
@@ -18,15 +29,13 @@
18 29
19 * In following options, path always means full path.30 * In following options, path always means full path.
2031
21 * Following options are only applicable for **PXC 5.5.32** and above. For 5.5.31 PXC refer to documentation in wsrep_sst_xtrabackup.
22
23.. option:: streamfmt32.. option:: streamfmt
2433
25 :Values: xbstream, tar 34 :Values: xbstream, tar
26 :Default: tar 35 :Default: xbstream
27 :Match: Yes36 :Match: Yes
2837
29Refer to :ref:`Xbstream v/s Tar<tar_ag_xbstream>` for details and caveats of using tar v/s xbstream for SST.38Xbstream 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.
30 39
31.. option:: transferfmt40.. option:: transferfmt
3241
@@ -39,30 +48,33 @@
39.. option:: tca 48.. option:: tca
4049
41 :Description: CA file for openssl based encryption with socat. 50 :Description: CA file for openssl based encryption with socat.
42 :Type: Full path to CA file.51 :Type: Full path to CRT file (.crt).
43 52
44.. option:: tcert53.. option:: tcert
45 54
46 :Description: PEM for openssl based encryption with socat. 55 :Description: PEM for openssl based encryption with socat.
47 :Type: Full path to PEM.56 :Type: Full path to PEM (.pem).
4857
49.. note::58.. note::
50 For tca and tcert, refer to http://www.dest-unreach.org/socat/doc/socat-openssltunnel.html for an example. 59 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.
51 60
52.. option:: encrypt61.. option:: encrypt
5362
54 :Values: 0,1,2 63 :Values: 0,1,2,3
55 :Default: 064 :Default: 0
56 :Match: Yes65 :Match: Yes
57 :Recommended: 2
5866
59Decides whether encryption is to be done or not, if this is zero, no 67Decides whether encryption is to be done or not, if this is zero, no
60encryption is done. 68encryption is done. ``encrypt=2`` is recommended if your nodes are
69over WAN and security constraints are higher, while ``encrypt=1``
70(Xtrabackup-based symmetric encryption) is easier to setup.
6171
62 * Xtrabackup based encryption with ``encrypt=1``.72 * Xtrabackup based encryption with ``encrypt=1``.
6373
64 * OpenSSL based encryption with ``encrypt=2``. Socat must be built with openSSL for encryption: ``socat -V | grep OPENSSL``.74 * OpenSSL based encryption with ``encrypt=2``. Socat must be built with openSSL for encryption: ``socat -V | grep OPENSSL``.
6575
76 * 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>`.
77
66Refer to this :ref:`document <xtrabackup_sst_encryption>` when enabling with ``encrypt=1``.78Refer to this :ref:`document <xtrabackup_sst_encryption>` when enabling with ``encrypt=1``.
6779
68.. option:: encrypt-algo80.. option:: encrypt-algo
@@ -78,13 +90,12 @@
7890
79.. option:: progress91.. option:: progress
8092
81 :Values: 1,path/to/file,path/to/fifo93 :Values: 1,path/to/file
8294
83If equal to:95If equal to:
8496
85 * 1 it writes to mysql stderr 97 * 1 it writes to mysql stderr
86 * path/to/file writes to that file. 98 * 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.
87 * 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.
8899
89.. note::100.. note::
90 Value of 0 is not valid.101 Value of 0 is not valid.
@@ -96,7 +107,9 @@
96 107
97Used only on joiner. 1 implies rebuild indexes. Note that this is 108Used only on joiner. 1 implies rebuild indexes. Note that this is
98independent of compaction, though compaction enables it. Rebuild of 109independent of compaction, though compaction enables it. Rebuild of
99indexes may be used as an optimization. 110indexes may be used as an optimization. Note that :bug:`1192834`
111affects this, hence use of ``compact`` and ``rebuild`` are recommended
112after that is fixed in Percona Xtrabackup and released.
100 113
101.. option:: time114.. option:: time
102115
@@ -119,36 +132,63 @@
119To be set on joiner only, supersedes IST if set. Currently requires132To be set on joiner only, supersedes IST if set. Currently requires
120manual setup. Hence, not supported currently.133manual setup. Hence, not supported currently.
121134
135.. option:: use_extra
136
137 :Values: 0,1
138 :Default: 0
139
140
141If 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.
142
143.. option:: cpat
144
145During 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: ::
146
147 [sst]
148 cpat='.*galera\.cache$\|.*sst_in_progress$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*\.xyz$'
149
150**NOTE:** This option can only be used when :variable:`wsrep_sst_method` is set to xtrabackup-v2.
151
122.. _tar_ag_xbstream:152.. _tar_ag_xbstream:
123153
124Tar against xbstream154Tar against xbstream
125---------------------155---------------------
126156
127 * 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. 157 * 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.
128 * 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.
129158
130Xtrabackup SST Dependencies159Xtrabackup SST Dependencies
131----------------------------160----------------------------
132161
133Following are optional dependencies of PXC introduced by wsrep_sst_xtrabackup: (obvious and direct dependencies are not provided here)162Following are optional dependencies of PXC introduced by wsrep_sst_xtrabackup: (obvious and direct dependencies are not provided here)
134163
135 * qpress for decompression. It is a dependency of Xtrabackup 2.1.4 and is available in our repos.164 * qpress for decompression. It is an optional dependency of |Percona XtraBackup| 2.1.4 and it is available in our software repositories.
136 * my_print_defaults to extract values from my.cnf. Provided by the server package.165 * my_print_defaults to extract values from my.cnf. Provided by the server package.
137 * openbsd-netcat or socat for transfer. socat is a direct dependency of PXC and is the default.166 * openbsd-netcat or socat for transfer. socat is a direct dependency of |Percona XtraDB Cluster| and it is the default.
138 * xbstream/tar for streaming. tar is default.167 * xbstream/tar for streaming. tar is default.
139 * pv. Required for :option:`progress` and :option:`rlimit`. Provided by pv.168 * pv. Required for :option:`progress` and :option:`rlimit`. Provided by pv.
140 * mkfifo. Required for :option:`progress`. Provided by coreutils.169 * mkfifo. Required for :option:`progress`. Provided by coreutils.
141 * mktemp. Required for :option:`incremental`. Provided by coreutils.170 * mktemp. Required for :option:`incremental`. Provided by coreutils.
142171
143.. _tip::172.. _galera_sst_encryption:
144 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>`_.173
174Galera compatible encryption
175----------------------------
176
177Support 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: ::
178
179 [sst]
180 encrypt=3
181 tkey=/etc/mysql/key.pem
182 tcert=/etc/mysql/cert.pem
183
184**NOTE:** This option can only be used when :variable:`wsrep_sst_method` is set to xtrabackup-v2.
145185
146.. _xtrabackup_sst_encryption:186.. _xtrabackup_sst_encryption:
147187
148Xtrabackup-based encryption188Xtrabackup-based encryption
149----------------------------189----------------------------
150190
151This 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:191This 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:
152192
153.. _xtrabackup_encrypt_options:193.. _xtrabackup_encrypt_options:
154194
@@ -158,11 +198,11 @@
158198
159There is no way to disallow encryption from innobackupex if the above are in my.cnf under [xtrabackup]. For that reason, do the following:199There is no way to disallow encryption from innobackupex if the above are in my.cnf under [xtrabackup]. For that reason, do the following:
160200
161 #. 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>`_.201 #. 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>`_.
162202
163 #. 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].203 #. 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].
164204
165 #. 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.205 #. 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.
166206
167 #. 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)207 #. 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)
168208
@@ -172,4 +212,4 @@
172 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`.212 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`.
173213
174.. warning:: 214.. warning::
175 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.215 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.
176216
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.23.rst 1970-01-01 00:00:00 +0000
@@ -1,19 +0,0 @@
1.. rn:: 5.5.23
2
3=====================================
4 |Percona XtraDB Cluster| 5.5.23-23.5
5=====================================
6
7Percona 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>`_.
8
9This 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>`_.
10
11List of changes:
12 * Fixes merged from upstream (`Codership-mysql <http://www.codership.com/content/wsrep-patch-235-mysql-5523-released>`_).
13 * Support for MyISAM, now changes to MyISAM tables are replicated to other nodes.
14 * Improvements to XtraBackup SST methods, better error handling.
15 * New SST wsrep_sst_method=skip, useful when you start all nodes from the same sources (i.e. backup).
16 * Ability to pass list of IP addresses for a new node, it will connect to the first available.
17
18Based 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.
19
200
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.24.rst 1970-01-01 00:00:00 +0000
@@ -1,16 +0,0 @@
1.. rn:: 5.5.24
2
3=====================================
4 |Percona XtraDB Cluster| 5.5.24-23.6
5=====================================
6
7Percona 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>`_.
8
9This 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>`_.
10
11Bugs fixed:
12
13 * Table with no PK but still having UK, can cause crash in slave using PA. Bug fixed :bug:`1003929`.
14
15Based 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.
16
170
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.27.rst 1970-01-01 00:00:00 +0000
@@ -1,38 +0,0 @@
1.. rn:: 5.5.27
2
3=====================================
4 |Percona XtraDB Cluster| 5.5.27-23.6
5=====================================
6
7Percona 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>`_.
8
9This 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>`_.
10
11Features
12========
13
14 * |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.
15
16 * |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.
17
18 * 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.
19
20 * 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.
21
22 * |Percona XtraDB Cluster| now has improved ``clustercheck.sh`` script which makes a proxy (ie HAProxy) capable of monitoring Percona XtraDB Cluster nodes properly.
23
24Bugs fixed
25==========
26
27 * Increasing the number of slave threads doesn't require provider reloading anymore. Bug fixed :bug:`852094`.
28
29 * No other SQL statement except INSERT...SELECT would replicate if /*!99997*/ comment was present. Bug fixed :bug:`1023911`.
30
31 * 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`.
32
33 * Cascading foreign key constraint could cause a slave crash. Bug fixed :bug:`1013978`.
34
35 * Fixed bug when donor accepts query, which then blocks. Bug fixed :bug:`1002714`.
36
37Based 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.
38
390
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.28.rst 1970-01-01 00:00:00 +0000
@@ -1,56 +0,0 @@
1.. rn:: 5.5.28-23.7
2
3======================================
4 |Percona XtraDB Cluster| 5.5.28-23.7
5======================================
6
7Percona 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>`_.
8
9This 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>`_.
10
11Features
12========
13
14 * |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.
15
16 * 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.
17
18 * New status variable :variable:`wsrep_incoming_addresses` has been introduced. It contains a comma-separated list of incoming (client) addresses in the cluster component.
19
20 * 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.
21
22 * 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.
23
24 * ``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.
25
26 * 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.
27
28 * This version of |Percona XtraDB Cluster| implements significant speedups and memory footprint reduction on ranged queries.
29
30Bugs fixed
31==========
32
33 * 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`.
34
35 * 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`.
36
37 * Server would hang before storage engine initialization with ``rsync`` SST and with option :variable:`wsrep_start_position` enabled. Bug fixed :bug:`1075495`.
38
39 * SST script interface has been upgraded to use named instead of positional parameters. Bug fixed :bug:`1045026`.
40
41 * 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`.
42
43 * If DDL is processing with RSU method and there is MDL conflict with local transaction, this conflict would remain unresolved. Bug fixed :bug:`1039514`.
44
45 * Static SST method list has been removed. Bug fixed :bug:`1045040`.
46
47 * DDL in multi-statement would cause a server crash. Bug fixed :bug:`1049024`.
48
49 * Mysqld_safe doesn't restart the node automatically anymore. Bug fixed :bug:`1077632`.
50
51 * Server would fail to start if the variable :variable:`wsrep_provider` was unset. Bug fixed :bug:`1077652`.
52
53Other bug fixes: bug :bug:`1049103`, bug :bug:`1045811`, bug :bug:`1057910`, bug :bug:`1052668`, bug :bug:`1073220`, bug :bug:`1076382`.
54
55Based 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.
56
570
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29-23.7.2.rst 1970-01-01 00:00:00 +0000
@@ -1,20 +0,0 @@
1.. rn:: 5.5.29-23.7.2
2
3========================================
4 |Percona XtraDB Cluster| 5.5.29-23.7.2
5========================================
6
7Percona 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>`_.
8
9This 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>`_.
10
11
12Bugs fixed
13==========
14
15 ``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*).
16
17 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*).
18
19Based 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.
20
210
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.29.rst 1970-01-01 00:00:00 +0000
@@ -1,44 +0,0 @@
1.. rn:: 5.5.29-23.7.1
2
3========================================
4 |Percona XtraDB Cluster| 5.5.29-23.7.1
5========================================
6
7Percona 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>`_.
8
9This 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>`_.
10
11
12Bugs fixed
13==========
14
15 In some cases when node is recovered variable :variable:`threads_running` would become huge. Bug fixed :bug:`1040108` (*Teemu Ollakka*).
16
17 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*).
18
19 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*).
20
21 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*).
22
23 |Percona XtraDB Cluster| would crash when processing a delete for a table with foreign key constraint. Bug fixed :bug:`1078346` (*Seppo Jaakola*).
24
25 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*).
26
27 Using |XtraBackup| for State Snapshot Transfer would fail due to ``mktemp`` error. Bug fixed :bug:`1080829` (*Alex Yurchenko*).
28
29 |XtraBackup| donor would run |XtraBackup| indefinitely if the xtrabackup ``--tmpdir`` was on ``tmpfs``. Bug fixed :bug:`1086978` (*Alex Yurchenko*).
30
31 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*).
32
33 |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*).
34
35 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*).
36
37 |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*)
38
39 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*).
40
41Other bug fixes: bug fixed :bug:`1037165`, bug fixed :bug:`812059`.
42
43Based 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.
44
450
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.30-23.7.4.rst 1970-01-01 00:00:00 +0000
@@ -1,84 +0,0 @@
1.. rn:: 5.5.30-23.7.4
2
3========================================
4 |Percona XtraDB Cluster| 5.5.30-23.7.4
5========================================
6
7Percona 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>`.
8
9This 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>`_.
10
11New Features
12============
13
14 |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.
15
16 |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/>`_.
17
18 This release of |Percona XtraDB Cluster| has fixed number of foreign key and packaging bugs.
19
20Bugs fixed
21==========
22
23 Fixed yum dependencies that were causing conflicts in ``CentOS`` 6.3 during installation. Bug fixed :bug:`1031427` (*Ignacio Nin*).
24
25 In case the |Percona XtraDB Cluster| was built from the source rpm, wsrep revision information would be missing. Bug fixed :bug:`1128906` (*Alexey Bychko*).
26
27 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*).
28
29 |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*).
30
31 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*).
32
33 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*).
34
35 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*).
36
37 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*).
38
39 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*).
40
41 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*).
42
43 Parallel applying would fail in case mixed ``CHAR`` and ``VARCHAR`` columns would be used in foreign key definitions. Bug fixed :bug:`1100496` (*Seppo Jaakola*).
44
45 *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*).
46
47 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*).
48
49 Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed :bug:`1130888` (*Seppo Jaakola*).
50
51 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*).
52
53 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*).
54
55 :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*).
56
57 Issues with compiling Galera on the ``ARM`` architecture has been fixed. Bug fixed :bug:`1133047` (*Alex Yurchenko*).
58
59 Upstream bugfix for bug :mysqlbug:`59354` triggered a regression that could cause transaction conflicts. Bug fixed :bug:`1158221` (*Seppo Jaakola*).
60
61 Galera builds would fail when they were built with the new ``boost`` library. Bug fixed :bug:`1131736` (*Alex Yurchenko*).
62
63 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*).
64
65 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*).
66
67 Handling of the network issues in Galera has been improved. Bug fixed :bug:`1153727` (*Teemu Ollakka*).
68
69 Fixed the wrong path in the ``/etc/xinetd.d/mysqlchk`` script. Bugs fixed :bug:`1000761` and :bug:`1132934` (*Raghavendra D Prabhu*).
70
71 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*).
72
73 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*).
74
75 Galera builds would fail when ``gcc`` 4.8 was used. Bug fixed :bug:`1164992` (*Alex Yurchenko*).
76
77 ``Percona-XtraDB-Cluster-galera`` package version number didn't match the :variable:`wsrep_provider_version` one. Bug fixed :bug:`1111672` (*Alexey Bychko*).
78
79 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*).
80
81Other 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*).
82
83Based 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.
84
850
=== removed file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.31-23.7.5.rst 1970-01-01 00:00:00 +0000
@@ -1,73 +0,0 @@
1.. rn:: 5.5.31-23.7.5
2
3========================================
4 |Percona XtraDB Cluster| 5.5.31-23.7.5
5========================================
6
7Percona 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>`.
8
9This 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>`_.
10
11New Features
12============
13
14 Information about the wsrep sequence number has been added to ``INFORMATION_SCHEMA`` :table:`INNODB_TRX` table.
15
16 |Percona XtraDB Cluster| can now be :ref:`bootstrapped <bootstrap>` with the new ``bootstrap-pxc`` option in the init script.
17
18 |Percona XtraDB Cluster| has implemented parallel copying for rsync :ref:`state_snapshot_transfer` method. Bug fixed :bug:`1167331` (*Mrten*).
19
20 |Percona XtraDB Cluster| has implemented new *Python* version of the `clustercheck <https://github.com/Oneiroi/clustercheck>`_ script.
21
22 |Percona XtraDB Cluster| now has better integration with |Percona XtraBackup| 2.1 by implementing new ``xbstream`` option for xtrabackup :ref:`state_snapshot_transfer` method.
23
24
25Bugs fixed
26==========
27
28 Fixed the packaging issues that caused |Percona XtraDB Cluster| to conflict with |MySQL| libraries when performing fresh *CentOS* installation. Bug fixed :bug:`1183669`.
29
30 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`.
31
32 Fixed the package conflict for ``percona-xtradb-cluster-client-5.5`` package. Bug fixed :bug:`1172621`.
33
34 Fixed the ``Percona-Server-shared-55`` and ``Percona-XtraDB-Cluster-shared`` ``RPM`` package dependences. Bug fixed :bug:`1050654`.
35
36 ``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`.
37
38 Startup script on *Debian* and *Ubuntu* was failing prematurely during ``SST``. Bug fixed :bug:`1099428`.
39
40 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`.
41
42 :variable:`wsrep-recover` would create ``ibdata1`` and ``ib_logfile*`` files which the SST after that would remove. Bug fixed :bug:`1191767`.
43
44 When running :variable:`wsrep_recover` to recover galera co-ordinates, LRU recover (and its blocking counterpart) were causing issues. Bug fixed :bug:`1108035`.
45
46 |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`.
47
48Crash/stalling bugs
49-------------------
50
51 |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`.
52
53 |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`.
54
55 ``FLUSH TABLES WITH READ LOCK`` didn't behave as expected, it had different behavior than the upstream |MySQL| version. Bug fixed :bug:`1170821`.
56
57 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`.
58
59 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`.
60
61 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`.
62
63 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.
64
65Regressions
66-----------
67
68 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`.
69
70Other 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`.
71
72Based 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.
73
740
=== added file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst 1970-01-01 00:00:00 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.14-25.1.rst 2013-11-21 11:30:55 +0000
@@ -0,0 +1,78 @@
1.. rn:: 5.6.14-25.1
2
3======================================
4 |Percona XtraDB Cluster| 5.6.14-25.1
5======================================
6
7Percona 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>`.
8
9Based 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.
10
11This 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:
12
13New Features
14============
15
16 |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>`_.
17
18 |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.
19
20 |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>`_.
21
22 ``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.
23
24 `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.
25
26 |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.
27
28 |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.
29
30 |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>`_.
31
32 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.
33
34 ``RPM`` packages are now made `relocatable <http://rpm5.org/docs/api/relocatable.html>`_ which means they now support installation to custom prefixes.
35
36Bugs fixed
37==========
38
39 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`.
40
41 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`.
42
43 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`.
44
45 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`.
46
47 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`.
48
49 Different mutex implementation in the 5.6 could lead to server assertion error. Bug fixed :bug:`1233383`.
50
51 Enabling :variable:`wsrep_log_conflicts` variable could cause issues with ``lock_mutex``. Bug fixed :bug:`1234382`.
52
53 Server could freeze with mixed DML/DDL load because TOI brute force aborts were not properly propagated. Bug fixed :bug:`1239571`.
54
55 ``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`.
56
57 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`.
58
59 ``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`.
60
61 ``CREATE TABLE AS SELECT`` was not replicated, if the select result set was empty. Bug fixed :bug:`1246921`.
62
63 Write set flags defined in wsrep API are now exposed to application side appliers too. Bug fixed :bug:`1247402`.
64
65 Local brute force aborts are counted accurately. Bug fixed :bug:`1247971`.
66
67 Certain combinations of transaction rollbacks could leave stale transactional ``MDL`` locks. Bug fixed :bug:`1247978`.
68
69 After turning ``UNIV_SYNC_DEBUG`` on, node that was started from clean state would crash immediately at startup. Bug fixed :bug:`1248908`.
70
71 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`.
72
73 Xtrabackup SST dependencies have been added as Optional/Recommended/Suggested dependencies. Bug fixed :bug:`1250326`.
74
75Other 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`.
76
77We 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>`_.
78
079
=== modified file 'doc-pxc/source/release-notes/release-notes_index.rst'
--- doc-pxc/source/release-notes/release-notes_index.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/release-notes/release-notes_index.rst 2013-11-21 11:30:55 +0000
@@ -1,17 +1,9 @@
1======================================1============================================
2|Percona XtraDB Cluster| Release notes2 |Percona XtraDB Cluster| 5.6 Release notes
3======================================3============================================
44
5.. toctree::5.. toctree::
6 :maxdepth: 16 :maxdepth: 1
7 :glob:7 :glob:
88
9 Percona-XtraDB-Cluster-5.5.31-23.7.59 Percona-XtraDB-Cluster-5.6.14-25.1
10 Percona-XtraDB-Cluster-5.5.30-23.7.4
11 Percona-XtraDB-Cluster-5.5.29-23.7.2
12 Percona-XtraDB-Cluster-5.5.29
13 Percona-XtraDB-Cluster-5.5.28
14 Percona-XtraDB-Cluster-5.5.27
15 Percona-XtraDB-Cluster-5.5.24
16 Percona-XtraDB-Cluster-5.5.23
17
1810
=== added file 'doc-pxc/source/upgrading_guide_55_56.rst'
--- doc-pxc/source/upgrading_guide_55_56.rst 1970-01-01 00:00:00 +0000
+++ doc-pxc/source/upgrading_guide_55_56.rst 2013-11-21 11:30:55 +0000
@@ -0,0 +1,119 @@
1.. _upgrading_guide:
2
3==================================================================
4 Percona XtraDB Cluster In-Place Upgrading Guide: From 5.5 to 5.6
5==================================================================
6
7Upgrading cluster involves two major stages:
8
9I) Upgrade a single node
10II) Upgrade the whole cluster while not breaking replication
11
12Following is the upgrade process on CentOS 6.4
13==============================================
14
15**Step #1** Make sure all the nodes in cluster are upgraded to the latest 5.5 version and are in synced state.
16
17Stage I
18--------
19Assuming we are going to upgrade node A, (and other nodes B and C are on 5.5)
20
21**Step #2** On node A stop the mysql process and remove the old packages: ::
22
23 # service mysql stop
24 # yum remove 'Percona*'
25
26**Step #3** Install the new packages: ::
27
28 # yum install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56 percona-xtrabackup
29
30**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: ::
31
32 wsrep_provider_options="socket.checksum=1"
33 log_bin_use_v1_row_events=1
34 gtid_mode=0
35 binlog_checksum=NONE
36 wsrep-slave-threads=1
37 read_only=ON
38
39**Step #5** Next, start the node with the variable :variable:`wsrep_provider` set to ``none``: ::
40
41 # mysqld --skip-grant-tables --user=mysql --wsrep-provider='none'
42
43This is to ensure that other hosts are not affected by this upgrade.
44
45**Step #6** While Step #5 is running, in the background or in another session run: ::
46
47 # mysql_upgrade
48
49**Step #7** Step #5 must complete successfully, upon which, process started in Step 5) can be stopped/killed.
50
51
52**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.
53
54**Step #9** If all the steps above have completed successfully node can be started with: ::
55
56 # service mysql start
57
58**Step #10** At this point, other nodes (B, C) should acknowledge that this node is up and synced!
59
60Stage II
61---------
62
63**Step #11** After this has been set up all 5.5 nodes can be upgraded, one-by-one, as described in the Stage I.
64
65 a) After all nodes in the cluster are upgraded to 5.6, option :variable:`read_only` should be set to ``OFF``.
66
67 b) Nodes should be restarted with compatibility options added earlier removed/updated for optimal performance (though cluster will continue run with those options).
68
69Following is the upgrade process on Ubuntu 12.04 (precise)
70==========================================================
71
72**Step #1** Make sure all the nodes in cluster are upgraded to the latest 5.5 version and are in synced state.
73
74Stage I
75--------
76Assuming we are going to upgrade node A, (and other nodes B and C are on 5.5)
77
78**Step #2** On node A stop the mysql process and remove the old packages: ::
79
80 # /etc/init.d/mysql stop
81 # 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
82
83**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`` ::
84
85 wsrep_provider_options="socket.checksum=1"
86 wsrep_provider=none
87 log_bin_use_v1_row_events=1
88 gtid_mode=0
89 binlog_checksum=NONE
90 wsrep-slave-threads=1
91
92**Step #4** Install the new packages: ::
93
94 # apt-get install percona-xtradb-cluster-server-5.6 percona-xtradb-cluster-client-5.6 percona-xtrabackup
95
96**Step #5** After node has been started you'll need to run ``mysql_upgrade``: ::
97
98 # mysql_upgrade
99
100**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.
101
102
103**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: ::
104
105 # service mysql start
106
107**Step #8** At this point, other nodes (B, C) should acknowledge that this node is up and synced!
108
109Stage II
110---------
111
112**Step #9** After this has been set up all 5.5 nodes can be upgraded, one-by-one, as described in the Stage I.
113
114 a) After all nodes in the cluster are upgraded to 5.6, option :variable:`read_only` should be set to ``OFF``.
115
116 b) Nodes should be restarted with compatibility options added earlier removed/updated for optimal performance (though cluster will continue run with those options).
117
118
119

Subscribers

People subscribed via source and target branches