Merge lp:~hrvojem/percona-xtradb-cluster/bug1264394-5.6 into lp:percona-xtradb-cluster
- bug1264394-5.6
- Merge into 5.6
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 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Raghavendra D Prabhu (community) | Approve | ||
Review via email: mp+203957@code.launchpad.net |
Commit message
Description of the change
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
1 | === modified file 'doc-pxc/source/howtos/3nodesec2.rst' | |||
2 | --- doc-pxc/source/howtos/3nodesec2.rst 2013-12-18 13:09:52 +0000 | |||
3 | +++ doc-pxc/source/howtos/3nodesec2.rst 2014-01-30 13:24:56 +0000 | |||
4 | @@ -6,7 +6,7 @@ | |||
5 | 6 | Assume you are running *m1.xlarge* instances with OS *Red Hat Enterprise Linux 6.1 64-bit*. | 6 | Assume you are running *m1.xlarge* instances with OS *Red Hat Enterprise Linux 6.1 64-bit*. |
6 | 7 | Make sure to remove existing PXC-5.5 and PS-5.5/5.6 packages before proceeding. | 7 | Make sure to remove existing PXC-5.5 and PS-5.5/5.6 packages before proceeding. |
7 | 8 | 8 | ||
9 | 9 | Install XtraDB Cluster from RPM: | 9 | Install |Percona XtraDB Cluster| from RPM: |
10 | 10 | 10 | ||
11 | 11 | 1. Install Percona's regular and testing repositories: :: | 11 | 1. Install Percona's regular and testing repositories: :: |
12 | 12 | 12 | ||
13 | @@ -32,13 +32,10 @@ | |||
14 | 32 | iptables -A INPUT -i eth0 -p tcp -m tcp --source 192.168.0.1/24 --dport 4567 -j ACCEPT | 32 | iptables -A INPUT -i eth0 -p tcp -m tcp --source 192.168.0.1/24 --dport 4567 -j ACCEPT |
15 | 33 | 33 | ||
16 | 34 | 34 | ||
18 | 35 | 5. Create /etc/my.cnf files. | 35 | 5. Create :file:`/etc/my.cnf` files. |
19 | 36 | 36 | ||
20 | 37 | On the first node (assume IP 10.93.46.58): :: | 37 | On the first node (assume IP 10.93.46.58): :: |
21 | 38 | 38 | ||
22 | 39 | [mysqld_safe] | ||
23 | 40 | wsrep_urls=gcomm://10.93.46.58:4567,gcomm://10.93.46.59:4567,gcomm://10.93.46.60:4567,gcomm:// | ||
24 | 41 | |||
25 | 42 | [mysqld] | 39 | [mysqld] |
26 | 43 | datadir=/mnt/data | 40 | datadir=/mnt/data |
27 | 44 | user=mysql | 41 | user=mysql |
28 | @@ -46,6 +43,7 @@ | |||
29 | 46 | binlog_format=ROW | 43 | binlog_format=ROW |
30 | 47 | 44 | ||
31 | 48 | wsrep_provider=/usr/lib64/libgalera_smm.so | 45 | wsrep_provider=/usr/lib64/libgalera_smm.so |
32 | 46 | wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60 | ||
33 | 49 | 47 | ||
34 | 50 | wsrep_slave_threads=2 | 48 | wsrep_slave_threads=2 |
35 | 51 | wsrep_cluster_name=trimethylxanthine | 49 | wsrep_cluster_name=trimethylxanthine |
36 | @@ -57,9 +55,6 @@ | |||
37 | 57 | 55 | ||
38 | 58 | On the second node (assume IP 10.93.46.59): :: | 56 | On the second node (assume IP 10.93.46.59): :: |
39 | 59 | 57 | ||
40 | 60 | [mysqld_safe] | ||
41 | 61 | wsrep_urls=gcomm://10.93.46.58:4567,gcomm://10.93.46.59:4567,gcomm://10.93.46.60:4567,gcomm:// | ||
42 | 62 | |||
43 | 63 | [mysqld] | 58 | [mysqld] |
44 | 64 | datadir=/mnt/data | 59 | datadir=/mnt/data |
45 | 65 | user=mysql | 60 | user=mysql |
46 | @@ -67,6 +62,7 @@ | |||
47 | 67 | binlog_format=ROW | 62 | binlog_format=ROW |
48 | 68 | 63 | ||
49 | 69 | wsrep_provider=/usr/lib64/libgalera_smm.so | 64 | wsrep_provider=/usr/lib64/libgalera_smm.so |
50 | 65 | wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60 | ||
51 | 70 | 66 | ||
52 | 71 | wsrep_slave_threads=2 | 67 | wsrep_slave_threads=2 |
53 | 72 | wsrep_cluster_name=trimethylxanthine | 68 | wsrep_cluster_name=trimethylxanthine |
54 | @@ -76,67 +72,63 @@ | |||
55 | 76 | innodb_locks_unsafe_for_binlog=1 | 72 | innodb_locks_unsafe_for_binlog=1 |
56 | 77 | innodb_autoinc_lock_mode=2 | 73 | innodb_autoinc_lock_mode=2 |
57 | 78 | 74 | ||
59 | 79 | On the third (and following nodes) config is similar, with the following change: :: | 75 | On the third (and following nodes) configuration is similar, with the following change: :: |
60 | 80 | 76 | ||
61 | 81 | wsrep_node_name=node3 | 77 | wsrep_node_name=node3 |
62 | 82 | 78 | ||
63 | 83 | In 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`. | 79 | In 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`. |
64 | 84 | 80 | ||
66 | 85 | 6. Start mysqld_safe | 81 | 6. Start the |Percona XtraDB Cluster| |
67 | 86 | 82 | ||
68 | 87 | On the first node: :: | 83 | On the first node: :: |
69 | 88 | 84 | ||
71 | 89 | mysqld_safe | 85 | [root@node1 ~]# /etc/init.d/mysql bootstrap-pxc |
72 | 90 | 86 | ||
73 | 91 | You should be able to see in console (or in error-log file): :: | 87 | You should be able to see in console (or in error-log file): :: |
74 | 92 | 88 | ||
79 | 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. |
80 | 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.r3673 | 90 | 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 |
81 | 95 | 111216 0:16:42 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1 | 91 | |
78 | 96 | 111216 0:16:42 [Note] WSREP: Synchronized with group, ready for connections | ||
82 | 97 | 92 | ||
83 | 98 | On the second (and following nodes): :: | 93 | On the second (and following nodes): :: |
84 | 99 | 94 | ||
86 | 100 | mysqld_safe | 95 | [root@node2 ~]# /etc/init.d/mysql start |
87 | 101 | 96 | ||
88 | 102 | You should be able to see in console (or in error-log file): :: | 97 | You should be able to see in console (or in error-log file): :: |
89 | 103 | 98 | ||
126 | 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] |
127 | 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) |
128 | 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 1 | 101 | 2014-01-30 09:52:42 26104 [Note] WSREP: Member 2 (percona1) synced with group. |
129 | 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) |
130 | 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 |
131 | 109 | 111216 0:21:41 [Note] WSREP: Prepared SST request: rsync|10.93.46.60:4444/rsync_sst | 104 | 2014-01-30 09:52:42 26104 [Note] WSREP: SST complete, seqno: 2 |
132 | 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. |
133 | 111 | 111216 0:21:41 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1 | 106 | 2014-01-30 09:52:42 26104 [Note] InnoDB: The InnoDB memory heap is disabled |
134 | 112 | 111216 0:21:41 [Note] WSREP: prepared IST receiver, listening in: tcp://10.93.46.60:4568 | 107 | 2014-01-30 09:52:42 26104 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins |
135 | 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 |
136 | 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 |
137 | 115 | 111216 0:21:41 [Note] WSREP: Requesting state transfer: success, donor: 0 | 110 | 2014-01-30 09:52:42 26104 [Note] InnoDB: Not using CPU crc32 instructions |
138 | 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 |
139 | 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 |
140 | 118 | 111216 0:21:42 [Note] WSREP: SST complete, seqno: 0 | 113 | 2014-01-30 09:52:43 26104 [Note] InnoDB: Highest supported file format is Barracuda. |
141 | 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. |
142 | 120 | 111216 0:21:42 InnoDB: The InnoDB memory heap is disabled | 115 | 2014-01-30 09:52:43 26104 [Note] InnoDB: Waiting for purge to start |
143 | 121 | 111216 0:21:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins | 116 | 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 |
144 | 122 | 111216 0:21:42 InnoDB: Compressed tables use zlib 1.2.3 | 117 | 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. |
145 | 123 | 111216 0:21:42 InnoDB: Using Linux native AIO | 118 | 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. |
146 | 124 | 111216 0:21:42 InnoDB: Initializing buffer pool, size = 128.0M | 119 | 2014-01-30 09:52:43 26104 [Note] Server hostname (bind-address): '*'; port: 3306 |
147 | 125 | 111216 0:21:42 InnoDB: Completed initialization of buffer pool | 120 | 2014-01-30 09:52:43 26104 [Note] IPv6 is available. |
148 | 126 | 111216 0:21:42 InnoDB: highest supported file format is Barracuda. | 121 | 2014-01-30 09:52:43 26104 [Note] - '::' resolves to '::'; |
149 | 127 | 111216 0:21:42 InnoDB: Waiting for the background threads to start | 122 | 2014-01-30 09:52:43 26104 [Note] Server socket created on IP: '::'. |
150 | 128 | 111216 0:21:43 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1597945 | 123 | 2014-01-30 09:52:43 26104 [Note] Event Scheduler: Loaded 0 events |
151 | 129 | 111216 0:21:43 [Note] Event Scheduler: Loaded 0 events | 124 | 2014-01-30 09:52:43 26104 [Note] /usr/sbin/mysqld: ready for connections. |
152 | 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 |
153 | 131 | 111216 0:21:43 [Note] WSREP: Received SST: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0 | 126 | 2014-01-30 09:52:43 26104 [Note] WSREP: inited wsrep sidno 1 |
154 | 132 | 111216 0:21:43 [Note] WSREP: SST finished: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0 | 127 | 2014-01-30 09:52:43 26104 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
155 | 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) |
156 | 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.r3673 | 129 | 2014-01-30 09:52:43 26104 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3 |
157 | 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. |
158 | 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 |
123 | 137 | 111216 0:21:43 [Note] WSREP: Member 1 (node2) synced with group. | ||
124 | 138 | 111216 0:21:43 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) | ||
125 | 139 | 111216 0:21:43 [Note] WSREP: Synchronized with group, ready for connections | ||
159 | 140 | 132 | ||
160 | 141 | When all nodes are in SYNCED stage your cluster is ready! | 133 | When all nodes are in SYNCED stage your cluster is ready! |
161 | 142 | 134 | ||
162 | 143 | 135 | ||
163 | === modified file 'doc-pxc/source/howtos/singlebox.rst' | |||
164 | --- doc-pxc/source/howtos/singlebox.rst 2013-09-05 13:37:01 +0000 | |||
165 | +++ doc-pxc/source/howtos/singlebox.rst 2014-01-30 13:24:56 +0000 | |||
166 | @@ -1,7 +1,10 @@ | |||
167 | 1 | .. _singe_box: | ||
168 | 2 | |||
169 | 3 | ========================================== | ||
170 | 1 | How to setup 3 node cluster on single box | 4 | How to setup 3 node cluster on single box |
171 | 2 | ========================================== | 5 | ========================================== |
172 | 3 | 6 | ||
174 | 4 | This 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 :: | 7 | This 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 :: |
175 | 5 | 8 | ||
176 | 6 | /usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64 | 9 | /usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64 |
177 | 7 | 10 | ||
178 | @@ -21,9 +24,9 @@ | |||
179 | 21 | 24 | ||
180 | 22 | In this example local IP address is 192.168.2.21 | 25 | In this example local IP address is 192.168.2.21 |
181 | 23 | 26 | ||
183 | 24 | Then 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): :: | 27 | Then 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`): :: |
184 | 25 | 28 | ||
186 | 26 | bin/mysqld_safe --defaults-file=/etc/my.4000.cnf | 29 | bin/mysqld_safe --defaults-file=/etc/my.4000.cnf --wsrep-new-cluster |
187 | 27 | 30 | ||
188 | 28 | Following output will let out know that node was started successfully: :: | 31 | Following output will let out know that node was started successfully: :: |
189 | 29 | 32 | ||
190 | @@ -61,24 +64,20 @@ | |||
191 | 61 | 64 | ||
192 | 62 | mysql -h127.0.0.1 -P5000 -e "CREATE DATABASE hello_peter" | 65 | mysql -h127.0.0.1 -P5000 -e "CREATE DATABASE hello_peter" |
193 | 63 | 66 | ||
194 | 64 | In 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`. | ||
195 | 65 | |||
196 | 66 | Configuration files (/etc/my.4000.cnf): :: | 67 | Configuration files (/etc/my.4000.cnf): :: |
197 | 67 | 68 | ||
198 | 68 | /etc/my.4000.cnf | 69 | /etc/my.4000.cnf |
199 | 69 | 70 | ||
200 | 70 | [mysqld_safe] | ||
201 | 71 | wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm:// | ||
202 | 72 | |||
203 | 73 | [mysqld] | 71 | [mysqld] |
204 | 74 | port = 4000 | 72 | port = 4000 |
205 | 75 | socket=/tmp/mysql.4000.sock | 73 | socket=/tmp/mysql.4000.sock |
206 | 76 | datadir=/data/bench/d1 | 74 | datadir=/data/bench/d1 |
208 | 77 | basedir=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64 | 75 | basedir=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64 |
209 | 78 | user=mysql | 76 | user=mysql |
210 | 79 | log_error=error.log | 77 | log_error=error.log |
211 | 80 | binlog_format=ROW | 78 | binlog_format=ROW |
213 | 81 | wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so | 79 | wsrep_cluster_address='gcomm://192.168.2.21:5030,192.168.2.21:6030' |
214 | 80 | wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64/lib/libgalera_smm.so | ||
215 | 82 | wsrep_sst_receive_address=192.168.2.21:4020 | 81 | wsrep_sst_receive_address=192.168.2.21:4020 |
216 | 83 | wsrep_node_incoming_address=192.168.2.21 | 82 | wsrep_node_incoming_address=192.168.2.21 |
217 | 84 | wsrep_slave_threads=2 | 83 | wsrep_slave_threads=2 |
218 | @@ -94,18 +93,16 @@ | |||
219 | 94 | 93 | ||
220 | 95 | /etc/my.5000.cnf | 94 | /etc/my.5000.cnf |
221 | 96 | 95 | ||
222 | 97 | [mysqld_safe] | ||
223 | 98 | wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm:// | ||
224 | 99 | |||
225 | 100 | [mysqld] | 96 | [mysqld] |
226 | 101 | port = 5000 | 97 | port = 5000 |
227 | 102 | socket=/tmp/mysql.5000.sock | 98 | socket=/tmp/mysql.5000.sock |
228 | 103 | datadir=/data/bench/d2 | 99 | datadir=/data/bench/d2 |
230 | 104 | basedir=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64 | 100 | basedir=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64 |
231 | 105 | user=mysql | 101 | user=mysql |
232 | 106 | log_error=error.log | 102 | log_error=error.log |
233 | 107 | binlog_format=ROW | 103 | binlog_format=ROW |
235 | 108 | wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so | 104 | wsrep_cluster_address='gcomm://192.168.2.21:4030,192.168.2.21:6030' |
236 | 105 | wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64/lib/libgalera_smm.so | ||
237 | 109 | wsrep_sst_receive_address=192.168.2.21:5020 | 106 | wsrep_sst_receive_address=192.168.2.21:5020 |
238 | 110 | wsrep_node_incoming_address=192.168.2.21 | 107 | wsrep_node_incoming_address=192.168.2.21 |
239 | 111 | wsrep_slave_threads=2 | 108 | wsrep_slave_threads=2 |
240 | @@ -120,18 +117,16 @@ | |||
241 | 120 | 117 | ||
242 | 121 | /etc/my.6000.cnf | 118 | /etc/my.6000.cnf |
243 | 122 | 119 | ||
244 | 123 | [mysqld_safe] | ||
245 | 124 | wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm:// | ||
246 | 125 | |||
247 | 126 | [mysqld] | 120 | [mysqld] |
248 | 127 | port = 6000 | 121 | port = 6000 |
249 | 128 | socket=/tmp/mysql.6000.sock | 122 | socket=/tmp/mysql.6000.sock |
250 | 129 | datadir=/data/bench/d3 | 123 | datadir=/data/bench/d3 |
252 | 130 | basedir=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64 | 124 | basedir=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64 |
253 | 131 | user=mysql | 125 | user=mysql |
254 | 132 | log_error=error.log | 126 | log_error=error.log |
255 | 133 | binlog_format=ROW | 127 | binlog_format=ROW |
257 | 134 | wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so | 128 | wsrep_cluster_address='gcomm://192.168.2.21:4030,192.168.2.21:5030' |
258 | 129 | wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.6.15-25.3.706.Linux.x86_64/lib/libgalera_smm.so | ||
259 | 135 | wsrep_sst_receive_address=192.168.2.21:6020 | 130 | wsrep_sst_receive_address=192.168.2.21:6020 |
260 | 136 | wsrep_node_incoming_address=192.168.2.21 | 131 | wsrep_node_incoming_address=192.168.2.21 |
261 | 137 | wsrep_slave_threads=2 | 132 | wsrep_slave_threads=2 |
262 | 138 | 133 | ||
263 | === modified file 'doc-pxc/source/index.rst' | |||
264 | --- doc-pxc/source/index.rst 2014-01-29 15:10:12 +0000 | |||
265 | +++ doc-pxc/source/index.rst 2014-01-30 13:24:56 +0000 | |||
266 | @@ -7,10 +7,6 @@ | |||
267 | 7 | Percona XtraDB Cluster 5.6 Documentation | 7 | Percona XtraDB Cluster 5.6 Documentation |
268 | 8 | ========================================== | 8 | ========================================== |
269 | 9 | 9 | ||
270 | 10 | .. note:: | ||
271 | 11 | |||
272 | 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. | ||
273 | 13 | |||
274 | 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. |
275 | 15 | 11 | ||
276 | 16 | |Percona XtraDB Cluster| provides: | 12 | |Percona XtraDB Cluster| provides: |
277 | 17 | 13 | ||
278 | === modified file 'doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst' | |||
279 | --- doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst 2014-01-29 15:47:41 +0000 | |||
280 | +++ doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.6.15-25.3.rst 2014-01-30 13:24:56 +0000 | |||
281 | @@ -22,7 +22,9 @@ | |||
282 | 22 | 22 | ||
283 | 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`. |
284 | 24 | 24 | ||
286 | 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. |
287 | 26 | |||
288 | 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`. | ||
289 | 26 | 28 | ||
290 | 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`. |
291 | 28 | 30 | ||
292 | @@ -39,8 +41,16 @@ | |||
293 | 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`. |
294 | 40 | 42 | ||
295 | 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`. |
298 | 42 | 44 | ||
299 | 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`. |
300 | 46 | |||
301 | 47 | GCache file allocation could fail if file size was a multiple of page size. Bug fixed :bug:`1259952`. | ||
302 | 48 | |||
303 | 49 | Group remerge after partitioning event has been fixed. Bug fixed :bug:`1232747`. | ||
304 | 50 | |||
305 | 51 | Fixed the OpenSSL linking exceptions. Bug fixed :bug:`1259063`. | ||
306 | 52 | |||
307 | 53 | Fixed multiple build bugs: :bug:`1262716`, :bug:`1269063`, :bug:`1269351`, :bug:`1272723`, :bug:`1272732`, and :bug:`1261996`. | ||
308 | 44 | 54 | ||
309 | 45 | Other bugs fixed: :bug:`1273101`, :bug:`1272961`, :bug:`1271264`, and :bug:`1253055`. | 55 | Other bugs fixed: :bug:`1273101`, :bug:`1272961`, :bug:`1271264`, and :bug:`1253055`. |
310 | 46 | 56 | ||
311 | 47 | 57 | ||
312 | === modified file 'doc-pxc/source/upgrading_guide_55_56.rst' | |||
313 | --- doc-pxc/source/upgrading_guide_55_56.rst 2014-01-29 23:50:44 +0000 | |||
314 | +++ doc-pxc/source/upgrading_guide_55_56.rst 2014-01-30 13:24:56 +0000 | |||
315 | @@ -56,7 +56,7 @@ | |||
316 | 56 | # Required under certain conditions | 56 | # Required under certain conditions |
317 | 57 | read_only=ON | 57 | read_only=ON |
318 | 58 | 58 | ||
320 | 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. |
321 | 60 | 60 | ||
322 | 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. |
323 | 62 | 62 | ||
324 | @@ -134,16 +134,33 @@ | |||
325 | 134 | 134 | ||
326 | 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`` :: |
327 | 136 | 136 | ||
328 | 137 | # Required for compatibility with galera-2 | ||
329 | 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" | ||
330 | 137 | wsrep_provider_options="socket.checksum=1" | 139 | wsrep_provider_options="socket.checksum=1" |
332 | 138 | wsrep_provider=none | 140 | # Required for replication compatibility |
333 | 139 | log_bin_use_v1_row_events=1 | 141 | log_bin_use_v1_row_events=1 |
334 | 140 | gtid_mode=0 | 142 | gtid_mode=0 |
335 | 141 | binlog_checksum=NONE | 143 | binlog_checksum=NONE |
337 | 142 | wsrep-slave-threads=1 | 144 | # Required under certain conditions |
338 | 145 | read_only=ON | ||
339 | 146 | |||
340 | 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 | ||
341 | 148 | replication from higher version to lower. This is currently a limitation of mysql itself. Also, refer to `Replication compatibility guide <https://dev.mysql.c | ||
342 | 149 | om/doc/refman/5.6/en/replication-compatibility.html>`_. Any DDLs during migration are not recommended for the same reason. | ||
343 | 150 | |||
344 | 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 | ||
345 | 152 | 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 | ||
346 | 153 | can also opt for read-write splitting at load-balancer/proxy level or at application level. | ||
347 | 154 | |||
348 | 155 | .. note:: | ||
349 | 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. | ||
350 | 143 | 157 | ||
351 | 144 | **Step #4** Install the new packages: :: | 158 | **Step #4** Install the new packages: :: |
352 | 145 | 159 | ||
354 | 146 | # apt-get install percona-xtradb-cluster-server-5.6 percona-xtradb-cluster-client-5.6 percona-xtrabackup percona-xtradb-cluster-galera-3.x | 160 | # apt-get install percona-xtradb-cluster-56 |
355 | 161 | |||
356 | 162 | .. note:: | ||
357 | 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. | ||
358 | 147 | 164 | ||
359 | 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``: :: |
360 | 149 | 166 | ||
361 | @@ -163,9 +180,31 @@ | |||
362 | 163 | 180 | ||
363 | 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. |
364 | 165 | 182 | ||
371 | 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). |
372 | 167 | 184 | ||
373 | 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. |
374 | 169 | 186 | ||
375 | 170 | 187 | Stage III [Optional] | |
376 | 171 | 188 | -------------------- | |
377 | 189 | |||
378 | 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:: | ||
379 | 191 | |||
380 | 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" | ||
381 | 193 | # Removing this makes socket.checksum=2 which uses hardware accelerated CRC32 checksumming. | ||
382 | 194 | wsrep_provider_options="socket.checksum=1" | ||
383 | 195 | |||
384 | 196 | # Required for replication compatibility, being removed here. | ||
385 | 197 | # You can keep some of these if you wish. | ||
386 | 198 | log_bin_use_v1_row_events=1 | ||
387 | 199 | |||
388 | 200 | # You will need this if you need to add async-slaves | ||
389 | 201 | gtid_mode=0 | ||
390 | 202 | |||
391 | 203 | # Galera already has full writeset checksumming, so | ||
392 | 204 | # this is required only if async-slaves are there or | ||
393 | 205 | # binlogging is turned on. | ||
394 | 206 | binlog_checksum=NONE | ||
395 | 207 | |||
396 | 208 | # Remove it from cnf even though it was turned off at runtime in Step #11. | ||
397 | 209 | read_only=ON | ||
398 | 210 |