Merge lp:~hrvojem/percona-xtradb-cluster/bug1264394-5.6 into lp:percona-xtradb-cluster

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Hrvoje Matijakovic
Approved revision: no longer in the source branch.
Merged at revision: 709
Proposed branch: lp:~hrvojem/percona-xtradb-cluster/bug1264394-5.6
Merge into: lp:percona-xtradb-cluster
Diff against target: 398 lines (+121/-89)
5 files modified
doc-pxc/source/howtos/3nodesec2.rst (+44/-52)
doc-pxc/source/howtos/singlebox.rst (+15/-20)
doc-pxc/source/index.rst (+0/-4)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst (+13/-3)
doc-pxc/source/upgrading_guide_55_56.rst (+49/-10)
To merge this branch: bzr merge lp:~hrvojem/percona-xtradb-cluster/bug1264394-5.6
Reviewer Review Type Date Requested Status
Raghavendra D Prabhu (community) Approve
Review via email: mp+203957@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc-pxc/source/howtos/3nodesec2.rst'
--- doc-pxc/source/howtos/3nodesec2.rst 2013-12-18 13:09:52 +0000
+++ doc-pxc/source/howtos/3nodesec2.rst 2014-01-30 13:24:56 +0000
@@ -6,7 +6,7 @@
6Assume you are running *m1.xlarge* instances with OS *Red Hat Enterprise Linux 6.1 64-bit*.6Assume you are running *m1.xlarge* instances with OS *Red Hat Enterprise Linux 6.1 64-bit*.
7Make sure to remove existing PXC-5.5 and PS-5.5/5.6 packages before proceeding.7Make sure to remove existing PXC-5.5 and PS-5.5/5.6 packages before proceeding.
88
9Install XtraDB Cluster from RPM:9Install |Percona XtraDB Cluster| from RPM:
1010
111. Install Percona's regular and testing repositories: ::111. Install Percona's regular and testing repositories: ::
1212
@@ -32,13 +32,10 @@
32 iptables -A INPUT -i eth0 -p tcp -m tcp --source 192.168.0.1/24 --dport 4567 -j ACCEPT32 iptables -A INPUT -i eth0 -p tcp -m tcp --source 192.168.0.1/24 --dport 4567 -j ACCEPT
3333
3434
355. Create /etc/my.cnf files.355. Create :file:`/etc/my.cnf` files.
3636
37 On the first node (assume IP 10.93.46.58): ::37 On the first node (assume IP 10.93.46.58): ::
3838
39 [mysqld_safe]
40 wsrep_urls=gcomm://10.93.46.58:4567,gcomm://10.93.46.59:4567,gcomm://10.93.46.60:4567,gcomm://
41
42 [mysqld]39 [mysqld]
43 datadir=/mnt/data40 datadir=/mnt/data
44 user=mysql41 user=mysql
@@ -46,6 +43,7 @@
46 binlog_format=ROW43 binlog_format=ROW
4744
48 wsrep_provider=/usr/lib64/libgalera_smm.so45 wsrep_provider=/usr/lib64/libgalera_smm.so
46 wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60
4947
50 wsrep_slave_threads=248 wsrep_slave_threads=2
51 wsrep_cluster_name=trimethylxanthine49 wsrep_cluster_name=trimethylxanthine
@@ -57,9 +55,6 @@
5755
58 On the second node (assume IP 10.93.46.59): ::56 On the second node (assume IP 10.93.46.59): ::
5957
60 [mysqld_safe]
61 wsrep_urls=gcomm://10.93.46.58:4567,gcomm://10.93.46.59:4567,gcomm://10.93.46.60:4567,gcomm://
62
63 [mysqld]58 [mysqld]
64 datadir=/mnt/data59 datadir=/mnt/data
65 user=mysql60 user=mysql
@@ -67,6 +62,7 @@
67 binlog_format=ROW62 binlog_format=ROW
6863
69 wsrep_provider=/usr/lib64/libgalera_smm.so64 wsrep_provider=/usr/lib64/libgalera_smm.so
65 wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60
7066
71 wsrep_slave_threads=267 wsrep_slave_threads=2
72 wsrep_cluster_name=trimethylxanthine68 wsrep_cluster_name=trimethylxanthine
@@ -76,67 +72,63 @@
76 innodb_locks_unsafe_for_binlog=172 innodb_locks_unsafe_for_binlog=1
77 innodb_autoinc_lock_mode=273 innodb_autoinc_lock_mode=2
7874
79On the third (and following nodes) config is similar, with the following change: ::75On the third (and following nodes) configuration is similar, with the following change: ::
8076
81 wsrep_node_name=node377 wsrep_node_name=node3
8278
83In this example variable :variable:`wsrep_urls` is being used instead of :variable:`wsrep_cluster_address`. With this configuration, node will first try to reach a cluster on `10.93.46.58:4567` if there is no cluster node, then it will try on `10.93.46.59:4567` and then `10.93.46.60:4567`. If no nodes are up, it will start a new cluster. Variable :variable:`wsrep_urls` goes into the [mysql_safe] section so it's important that the mysql server instance is started with the `/bin/mysql_safe` and not `bin/mysqld`.79In this example variable :variable:`wsrep_urls` is being used instead of :variable:`wsrep_cluster_address`. With this configuration, node will first try to reach a cluster on `10.93.46.58:4567` if there is no cluster node, then it will try on `10.93.46.59:4567` and then `10.93.46.60:4567`. If no nodes are up, it will start a new cluster. Variable :variable:`wsrep_urls` goes into the [mysql_safe] section so it's important that the mysql server instance is started with the `/bin/mysql_safe` and not `bin/mysqld`.
8480
856. Start mysqld_safe816. Start the |Percona XtraDB Cluster|
8682
87On the first node: ::83On the first node: ::
8884
89 mysqld_safe85 [root@node1 ~]# /etc/init.d/mysql bootstrap-pxc
9086
91You should be able to see in console (or in error-log file): ::87You should be able to see in console (or in error-log file): ::
9288
93 111216 0:16:42 [Note] /usr/sbin/mysqld: ready for connections.89 2014-01-30 11:52:35 23280 [Note] /usr/sbin/mysqld: ready for connections.
94 Version: '5.5.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release alpha22.1, Revision 3673 wsrep_22.3.r367390 Version: '5.6.15-56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release 25.3, Revision 706, wsrep_25.3.r4034
95 111216 0:16:42 [Note] WSREP: Assign initial position for certification: 0, protocol version: 191
96 111216 0:16:42 [Note] WSREP: Synchronized with group, ready for connections
9792
98On the second (and following nodes): ::93On the second (and following nodes): ::
9994
100 mysqld_safe95 [root@node2 ~]# /etc/init.d/mysql start
10196
102You should be able to see in console (or in error-log file): ::97You should be able to see in console (or in error-log file): ::
10398
104 111216 0:21:39 [Note] WSREP: Flow-control interval: [12, 23]99 2014-01-30 09:52:42 26104 [Note] WSREP: Flow-control interval: [28, 28]
105 111216 0:21:39 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0)100 2014-01-30 09:52:42 26104 [Note] WSREP: Restored state OPEN -> JOINED (2)
106 111216 0:21:39 [Note] WSREP: New cluster view: global state: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 1101 2014-01-30 09:52:42 26104 [Note] WSREP: Member 2 (percona1) synced with group.
107 111216 0:21:39 [Warning] WSREP: Gap in state sequence. Need state transfer.102 2014-01-30 09:52:42 26104 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2)
108 111216 0:21:41 [Note] WSREP: Running: 'wsrep_sst_rsync 'joiner' '10.93.46.60' '' '/mnt/data/' '/etc/my.cnf' '1694' 2>sst.err'103 2014-01-30 09:52:42 26104 [Note] WSREP: New cluster view: global state: 4827a206-876b-11e3-911c-3e6a77d54953:2, view# 7: Primary, number of nodes: 3, my index: 2, protocol version 2
109 111216 0:21:41 [Note] WSREP: Prepared SST request: rsync|10.93.46.60:4444/rsync_sst104 2014-01-30 09:52:42 26104 [Note] WSREP: SST complete, seqno: 2
110 111216 0:21:41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.105 2014-01-30 09:52:42 26104 [Note] Plugin 'FEDERATED' is disabled.
111 111216 0:21:41 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1106 2014-01-30 09:52:42 26104 [Note] InnoDB: The InnoDB memory heap is disabled
112 111216 0:21:41 [Note] WSREP: prepared IST receiver, listening in: tcp://10.93.46.60:4568107 2014-01-30 09:52:42 26104 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
113 111216 0:21:41 [Note] WSREP: Node 1 (node2) requested state transfer from '*any*'. Selected 0 (node1)(SYNCED) as donor.108 2014-01-30 09:52:42 26104 [Note] InnoDB: Compressed tables use zlib 1.2.3
114 111216 0:21:41 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)109 2014-01-30 09:52:42 26104 [Note] InnoDB: Using Linux native AIO
115 111216 0:21:41 [Note] WSREP: Requesting state transfer: success, donor: 0110 2014-01-30 09:52:42 26104 [Note] InnoDB: Not using CPU crc32 instructions
116 111216 0:21:42 [Note] WSREP: 0 (node1): State transfer to 1 (node2) complete.111 2014-01-30 09:52:42 26104 [Note] InnoDB: Initializing buffer pool, size = 128.0M
117 111216 0:21:42 [Note] WSREP: Member 0 (node1) synced with group.112 2014-01-30 09:52:42 26104 [Note] InnoDB: Completed initialization of buffer pool
118 111216 0:21:42 [Note] WSREP: SST complete, seqno: 0113 2014-01-30 09:52:43 26104 [Note] InnoDB: Highest supported file format is Barracuda.
119 111216 0:21:42 [Note] Plugin 'FEDERATED' is disabled.114 2014-01-30 09:52:43 26104 [Note] InnoDB: 128 rollback segment(s) are active.
120 111216 0:21:42 InnoDB: The InnoDB memory heap is disabled115 2014-01-30 09:52:43 26104 [Note] InnoDB: Waiting for purge to start
121 111216 0:21:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins116 2014-01-30 09:52:43 26104 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.15-rel62.0 started; log sequence number 1626341
122 111216 0:21:42 InnoDB: Compressed tables use zlib 1.2.3117 2014-01-30 09:52:43 26104 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
123 111216 0:21:42 InnoDB: Using Linux native AIO118 2014-01-30 09:52:43 26104 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
124 111216 0:21:42 InnoDB: Initializing buffer pool, size = 128.0M119 2014-01-30 09:52:43 26104 [Note] Server hostname (bind-address): '*'; port: 3306
125 111216 0:21:42 InnoDB: Completed initialization of buffer pool120 2014-01-30 09:52:43 26104 [Note] IPv6 is available.
126 111216 0:21:42 InnoDB: highest supported file format is Barracuda.121 2014-01-30 09:52:43 26104 [Note] - '::' resolves to '::';
127 111216 0:21:42 InnoDB: Waiting for the background threads to start122 2014-01-30 09:52:43 26104 [Note] Server socket created on IP: '::'.
128 111216 0:21:43 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1597945123 2014-01-30 09:52:43 26104 [Note] Event Scheduler: Loaded 0 events
129 111216 0:21:43 [Note] Event Scheduler: Loaded 0 events124 2014-01-30 09:52:43 26104 [Note] /usr/sbin/mysqld: ready for connections.
130 111216 0:21:43 [Note] WSREP: Signalling provider to continue.125 Version: '5.6.15-56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release 25.3, Revision 706, wsrep_25.3.r4034
131 111216 0:21:43 [Note] WSREP: Received SST: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0126 2014-01-30 09:52:43 26104 [Note] WSREP: inited wsrep sidno 1
132 111216 0:21:43 [Note] WSREP: SST finished: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0127 2014-01-30 09:52:43 26104 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
133 111216 0:21:43 [Note] /usr/sbin/mysqld: ready for connections.128 2014-01-30 09:52:43 26104 [Note] WSREP: REPL Protocols: 5 (3, 1)
134 Version: '5.5.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release alpha22.1, Revision 3673 wsrep_22.3.r3673129 2014-01-30 09:52:43 26104 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3
135 111216 0:21:43 [Note] WSREP: 1 (node2): State transfer from 0 (node1) complete.130 2014-01-30 09:52:43 26104 [Note] WSREP: Service thread queue flushed.
136 111216 0:21:43 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0)131 2014-01-30 09:52:43 26104 [Note] WSREP: Synchronized with group, ready for connections
137 111216 0:21:43 [Note] WSREP: Member 1 (node2) synced with group.
138 111216 0:21:43 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
139 111216 0:21:43 [Note] WSREP: Synchronized with group, ready for connections
140132
141When all nodes are in SYNCED stage your cluster is ready!133When all nodes are in SYNCED stage your cluster is ready!
142134
143135
=== modified file 'doc-pxc/source/howtos/singlebox.rst'
--- doc-pxc/source/howtos/singlebox.rst 2013-09-05 13:37:01 +0000
+++ doc-pxc/source/howtos/singlebox.rst 2014-01-30 13:24:56 +0000
@@ -1,7 +1,10 @@
1.. _singe_box:
2
3==========================================
1How to setup 3 node cluster on single box4How to setup 3 node cluster on single box
2==========================================5==========================================
36
4This example shows how to setup 3-node cluster on the single physical box. Assume you installed |Percona XtraDB Cluster| from binary .tar.gz into directory :: 7This example shows how to setup 3-node cluster on the single physical box. Assume you installed |Percona XtraDB Cluster| from binary ``.tar.gz`` into directory ::
58
6/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_649/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64
710
@@ -21,9 +24,9 @@
2124
22In this example local IP address is 192.168.2.2125In this example local IP address is 192.168.2.21
2326
24Then we should be able to start initial node as (from directory /usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64): ::27Then we should be able to start initial node as (from directory :file:`/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64`): ::
2528
26 bin/mysqld_safe --defaults-file=/etc/my.4000.cnf29 bin/mysqld_safe --defaults-file=/etc/my.4000.cnf --wsrep-new-cluster
2730
28Following output will let out know that node was started successfully: ::31Following output will let out know that node was started successfully: ::
2932
@@ -61,24 +64,20 @@
61 64
62 mysql -h127.0.0.1 -P5000 -e "CREATE DATABASE hello_peter"65 mysql -h127.0.0.1 -P5000 -e "CREATE DATABASE hello_peter"
6366
64In this example variable :variable:`wsrep_urls` is being used instead of :variable:`wsrep_cluster_address`. With this configuration, node will first try to reach a cluster on port 4030, if there is no cluster node, then it will try on port 5030 and then 6030. If no nodes are up, it will start a new cluster. Variable :variable:`wsrep_urls` goes into the [mysql_safe] section so it's important that the mysql server instance is started with the `/bin/mysql_safe` and not `bin/mysqld`.
65
66Configuration files (/etc/my.4000.cnf): ::67Configuration files (/etc/my.4000.cnf): ::
6768
68 /etc/my.4000.cnf69 /etc/my.4000.cnf
6970
70 [mysqld_safe]
71 wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://
72
73 [mysqld]71 [mysqld]
74 port = 400072 port = 4000
75 socket=/tmp/mysql.4000.sock73 socket=/tmp/mysql.4000.sock
76 datadir=/data/bench/d174 datadir=/data/bench/d1
77 basedir=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_6475 basedir=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64
78 user=mysql76 user=mysql
79 log_error=error.log77 log_error=error.log
80 binlog_format=ROW78 binlog_format=ROW
81 wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so79 wsrep_cluster_address='gcomm://192.168.2.21:5030,192.168.2.21:6030'
80 wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64/lib/libgalera_smm.so
82 wsrep_sst_receive_address=192.168.2.21:402081 wsrep_sst_receive_address=192.168.2.21:4020
83 wsrep_node_incoming_address=192.168.2.21 82 wsrep_node_incoming_address=192.168.2.21
84 wsrep_slave_threads=283 wsrep_slave_threads=2
@@ -94,18 +93,16 @@
9493
95 /etc/my.5000.cnf94 /etc/my.5000.cnf
9695
97 [mysqld_safe]
98 wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://
99
100 [mysqld]96 [mysqld]
101 port = 500097 port = 5000
102 socket=/tmp/mysql.5000.sock98 socket=/tmp/mysql.5000.sock
103 datadir=/data/bench/d299 datadir=/data/bench/d2
104 basedir=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64100 basedir=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64
105 user=mysql101 user=mysql
106 log_error=error.log102 log_error=error.log
107 binlog_format=ROW103 binlog_format=ROW
108 wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so104 wsrep_cluster_address='gcomm://192.168.2.21:4030,192.168.2.21:6030'
105 wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64/lib/libgalera_smm.so
109 wsrep_sst_receive_address=192.168.2.21:5020106 wsrep_sst_receive_address=192.168.2.21:5020
110 wsrep_node_incoming_address=192.168.2.21 107 wsrep_node_incoming_address=192.168.2.21
111 wsrep_slave_threads=2108 wsrep_slave_threads=2
@@ -120,18 +117,16 @@
120117
121 /etc/my.6000.cnf118 /etc/my.6000.cnf
122119
123 [mysqld_safe]
124 wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://
125
126 [mysqld]120 [mysqld]
127 port = 6000121 port = 6000
128 socket=/tmp/mysql.6000.sock122 socket=/tmp/mysql.6000.sock
129 datadir=/data/bench/d3123 datadir=/data/bench/d3
130 basedir=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64124 basedir=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64
131 user=mysql125 user=mysql
132 log_error=error.log126 log_error=error.log
133 binlog_format=ROW127 binlog_format=ROW
134 wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so128 wsrep_cluster_address='gcomm://192.168.2.21:4030,192.168.2.21:5030'
129 wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64/lib/libgalera_smm.so
135 wsrep_sst_receive_address=192.168.2.21:6020130 wsrep_sst_receive_address=192.168.2.21:6020
136 wsrep_node_incoming_address=192.168.2.21 131 wsrep_node_incoming_address=192.168.2.21
137 wsrep_slave_threads=2132 wsrep_slave_threads=2
138133
=== modified file 'doc-pxc/source/index.rst'
--- doc-pxc/source/index.rst 2014-01-29 15:10:12 +0000
+++ doc-pxc/source/index.rst 2014-01-30 13:24:56 +0000
@@ -7,10 +7,6 @@
7 Percona XtraDB Cluster 5.6 Documentation7 Percona XtraDB Cluster 5.6 Documentation
8==========================================8==========================================
99
10.. note::
11
12 Please note: |Percona XtraDB Cluster| 5.6 is RELEASE CANDIDATE quality software. It should *NOT* be used in production environments. Refer to :ref:`upgrading_guide` for upgrade guide.
13
14|Percona XtraDB Cluster| is High Availability and Scalability solution for MySQL Users.10|Percona XtraDB Cluster| is High Availability and Scalability solution for MySQL Users.
1511
16|Percona XtraDB Cluster| provides:12|Percona XtraDB Cluster| provides:
1713
=== modified file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst'
--- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst 2014-01-29 15:47:41 +0000
+++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst 2014-01-30 13:24:56 +0000
@@ -22,7 +22,9 @@
2222
23 Node would get stuck and required restart if ``DDL`` was performed after ``FLUSH TABLES WITH READ LOCK``. Bug fixed :bug:`1265656`.23 Node would get stuck and required restart if ``DDL`` was performed after ``FLUSH TABLES WITH READ LOCK``. Bug fixed :bug:`1265656`.
2424
25 Default value for :variable:`binlog_format` is now ``ROW`` and for :variable:`innodb_autoinc_lock_mode` is ``2``. This is done so that |Percona XtraDB Cluster| is not started with wrong defaults leading to non-deterministic outcomes like crash. Bug fixed :bug:`1243228`.25 Galera provider pause has been fixed to avoid potential deadlock with replicating threads.
26
27 Default value for :variable:`binlog_format` is now ``ROW``. This is done so that |Percona XtraDB Cluster| is not started with wrong defaults leading to non-deterministic outcomes like crash. Bug fixed :bug:`1243228`.
2628
27 During the installation of ``percona-xtradb-cluster-garbd-3.x`` package, *Debian* tries to start it, but as the configuration is not set, it would fail to start and leave the installation in ``iF`` state. Bug fixed :bug:`1262171`.29 During the installation of ``percona-xtradb-cluster-garbd-3.x`` package, *Debian* tries to start it, but as the configuration is not set, it would fail to start and leave the installation in ``iF`` state. Bug fixed :bug:`1262171`.
2830
@@ -39,8 +41,16 @@
39 Binary log directory is now being cleanup as part of the :ref:`XtraBackup SST <xtrabackup_sst>`. Bug fixed :bug:`1273368`.41 Binary log directory is now being cleanup as part of the :ref:`XtraBackup SST <xtrabackup_sst>`. Bug fixed :bug:`1273368`.
4042
41 First connection would hang after changing the :variable:`wsrep_cluster_address` variable. Bug fixed :bug:`1022250`.43 First connection would hang after changing the :variable:`wsrep_cluster_address` variable. Bug fixed :bug:`1022250`.
4244
43 Fixed multiple build bugs: :bug:`1262716`, :bug:`1269063`, :bug:`1269351`, :bug:`1272723`, :bug:`1272732`.45 When :variable:`gmcast.listen_addr` was set manually it did not allow nodes own address in gcomm address list. Bug fixed :bug:`1099478`.
46
47 GCache file allocation could fail if file size was a multiple of page size. Bug fixed :bug:`1259952`.
48
49 Group remerge after partitioning event has been fixed. Bug fixed :bug:`1232747`.
50
51 Fixed the OpenSSL linking exceptions. Bug fixed :bug:`1259063`.
52
53 Fixed multiple build bugs: :bug:`1262716`, :bug:`1269063`, :bug:`1269351`, :bug:`1272723`, :bug:`1272732`, and :bug:`1261996`.
4454
45Other bugs fixed: :bug:`1273101`, :bug:`1272961`, :bug:`1271264`, and :bug:`1253055`.55Other bugs fixed: :bug:`1273101`, :bug:`1272961`, :bug:`1271264`, and :bug:`1253055`.
4656
4757
=== modified file 'doc-pxc/source/upgrading_guide_55_56.rst'
--- doc-pxc/source/upgrading_guide_55_56.rst 2014-01-29 23:50:44 +0000
+++ doc-pxc/source/upgrading_guide_55_56.rst 2014-01-30 13:24:56 +0000
@@ -56,7 +56,7 @@
56 # Required under certain conditions56 # Required under certain conditions
57 read_only=ON57 read_only=ON
5858
59**Step #5.1** "read_only=ON" is required only when the tables you have contain timestamp/datetime/time data types as those data types are incompatible across replication from higher version to lower. This is currently a limitation of mysql itself. Also, refer to `Replication compatibility guide https://dev.mysql.com/doc/refman/5.6/en/replication-compatibility.html>`_. Any DDLs during migration are not recommended for the same reason.59**Step #5.1** "read_only=ON" is required only when the tables you have contain timestamp/datetime/time data types as those data types are incompatible across replication from higher version to lower. This is currently a limitation of mysql itself. Also, refer to `Replication compatibility guide <https://dev.mysql.com/doc/refman/5.6/en/replication-compatibility.html>`_. Any DDLs during migration are not recommended for the same reason.
6060
61**Step #5.2** To ensure 5.6 read-only nodes are not written to during migration, clustercheck (usually used with xinetd and HAProxy) distributed with PXC has been modified to return 503 when the node is read-only so that HAProxy doesn't send writes to it. Refer to clustercheck script for more details. Instead, you can also opt for read-write splitting at load-balancer/proxy level or at application level.61**Step #5.2** To ensure 5.6 read-only nodes are not written to during migration, clustercheck (usually used with xinetd and HAProxy) distributed with PXC has been modified to return 503 when the node is read-only so that HAProxy doesn't send writes to it. Refer to clustercheck script for more details. Instead, you can also opt for read-write splitting at load-balancer/proxy level or at application level.
6262
@@ -134,16 +134,33 @@
134134
135**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`` ::135**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`` ::
136136
137 # Required for compatibility with galera-2
138 # Append socket.checksum=1 to other options if others are in wsrep_provider_options. Eg.: "gmcast.listen_addr=tcp://127.0.0.1:15010; socket.checksum=1"
137 wsrep_provider_options="socket.checksum=1"139 wsrep_provider_options="socket.checksum=1"
138 wsrep_provider=none140 # Required for replication compatibility
139 log_bin_use_v1_row_events=1141 log_bin_use_v1_row_events=1
140 gtid_mode=0142 gtid_mode=0
141 binlog_checksum=NONE143 binlog_checksum=NONE
142 wsrep-slave-threads=1144 # Required under certain conditions
145 read_only=ON
146
147**Step #3.1** "read_only=ON" is required only when the tables you have contain timestamp/datetime/time data types as those data types are incompatible across
148replication from higher version to lower. This is currently a limitation of mysql itself. Also, refer to `Replication compatibility guide <https://dev.mysql.c
149om/doc/refman/5.6/en/replication-compatibility.html>`_. Any DDLs during migration are not recommended for the same reason.
150
151**Step #3.2** To ensure 5.6 read-only nodes are not written to during migration, clustercheck (usually used with xinetd and HAProxy) distributed with PXC has
152been modified to return 503 when the node is read-only so that HAProxy doesn't send writes to it. Refer to clustercheck script for more details. Instead, you
153can also opt for read-write splitting at load-balancer/proxy level or at application level.
154
155.. note::
156 On the last 5.5 node to upgrade to 5.6, the compatibility options of Step #3 are not required since all other nodes will already be upgrade and their configuration options are compatible with a 5.6 node without them.
143157
144**Step #4** Install the new packages: ::158**Step #4** Install the new packages: ::
145159
146 # apt-get install percona-xtradb-cluster-server-5.6 percona-xtradb-cluster-client-5.6 percona-xtrabackup percona-xtradb-cluster-galera-3.x160 # apt-get install percona-xtradb-cluster-56
161
162.. note::
163 For more details on installation, refer to :ref:`installation` guide. You may also want to install percona-xtradb-cluster-full-56 which installs other ancillary packages like '-shared-56', '-test-56', debuginfos and so on.
147164
148**Step #5** After node has been started you'll need to run ``mysql_upgrade``: ::165**Step #5** After node has been started you'll need to run ``mysql_upgrade``: ::
149166
@@ -163,9 +180,31 @@
163180
164**Step #9** After this has been set up all 5.5 nodes can be upgraded, one-by-one, as described in the Stage I. 181**Step #9** After this has been set up all 5.5 nodes can be upgraded, one-by-one, as described in the Stage I.
165182
166 a) After all nodes in the cluster are upgraded to 5.6, option :variable:`read_only` should be set to ``OFF``. 183 a) If :variable:`read_only` was turned on in Step #3.1, then after all nodes in the cluster are upgraded to 5.6 or equivalently, after the last 5.5 has been take down for upgrade, option :variable:`read_only` can be set to ``OFF`` (since this is a dynamic variable, it can done without restart).
167184
168 b) Nodes should be restarted with compatibility options added earlier removed/updated for optimal performance (though cluster will continue run with those options).185 b) If read-write splitting was done in applications and/or in load-balancer then in previous step, instead of ``read_only``, writes need to be directed to 5.6 nodes.
169186
170187Stage III [Optional]
171 188--------------------
189
190**Step #10** This step is required to turn off the options added in #Step 3. Note, that this step is not required immediately after upgrade and can be done at a latter stage. The aim here is to turn off the compatibility options for performance reasons (only socket.checksum=1 fits this). This requires restart of each node. Hence, following can be removed/commented-out::
191
192 # Remove socket.checksum=1 from other options if others are in wsrep_provider_options. Eg.: "gmcast.listen_addr=tcp://127.0.0.1:15010"
193 # Removing this makes socket.checksum=2 which uses hardware accelerated CRC32 checksumming.
194 wsrep_provider_options="socket.checksum=1"
195
196 # Required for replication compatibility, being removed here.
197 # You can keep some of these if you wish.
198 log_bin_use_v1_row_events=1
199
200 # You will need this if you need to add async-slaves
201 gtid_mode=0
202
203 # Galera already has full writeset checksumming, so
204 # this is required only if async-slaves are there or
205 # binlogging is turned on.
206 binlog_checksum=NONE
207
208 # Remove it from cnf even though it was turned off at runtime in Step #11.
209 read_only=ON
210

Subscribers

People subscribed via source and target branches