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

[Hrvoje Matijakovic]

[Raghavendra D Prabhu (raghavendra-prabhu)]

All fine except:

 wsrep_cluster_address=gcomm://192.168.2.21

parts in singlebox.rst

it should be like:

wsrep_cluster_address='gcomm://127.0.0.1:15010,127.0.0.1:16010'
wsrep_provider_options = "gmcast.listen_addr=tcp://127.0.0.1:14010"

(ie. cluster address of each should contain listen_addr of other nodes).

[Raghavendra D Prabhu (raghavendra-prabhu)]

Needs fixing as per previous comment.

review: Needs Fixing

=== modified file 'doc-pxc/source/howtos/3nodesec2.rst'
--- doc-pxc/source/howtos/3nodesec2.rst	2013-12-30 17:01:54 +0000
+++ doc-pxc/source/howtos/3nodesec2.rst	2014-02-06 09:58:46 +0000
@@ -35,8 +35,6 @@
 
  On the first node (assume IP 10.93.46.58): ::
 
-  [mysqld_safe]
-  wsrep_urls=gcomm://10.93.46.58:4567,gcomm://10.93.46.59:4567,gcomm://10.93.46.60:4567,gcomm://  
 
   [mysqld]
   datadir=/mnt/data
@@ -45,24 +43,22 @@
   binlog_format=ROW
 
   wsrep_provider=/usr/lib64/libgalera_smm.so
+  wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60
 
   wsrep_slave_threads=2
   wsrep_cluster_name=trimethylxanthine
   wsrep_sst_method=rsync
   wsrep_node_name=node1
 
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
 
  On the second node (assume IP 10.93.46.59): ::
 
-  [mysqld_safe]
-  wsrep_urls=gcomm://10.93.46.58:4567,gcomm://10.93.46.59:4567,gcomm://10.93.46.60:4567,gcomm://
-
   [mysqld]
   datadir=/mnt/data
   user=mysql
 
+  wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60
   binlog_format=ROW
 
   wsrep_provider=/usr/lib64/libgalera_smm.so
@@ -72,70 +68,74 @@
   wsrep_sst_method=rsync
   wsrep_node_name=node2
 
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
 
-On the third (and following nodes) config is similar, with the following change: ::
+On the third (and following nodes) configuration is similar, with the following change: ::
 
   wsrep_node_name=node3
 
-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`.
-
-6. Start mysqld_safe
+6. Start the |Percona XtraDB Cluster|
 
 On the first node: ::
 
-   mysqld_safe
+   [root@node1 ~]# /etc/init.d/mysql bootstrap-pxc
 
 You should be able to see in console (or in error-log file): ::
 
-  111216  0:16:42 [Note] /usr/sbin/mysqld: ready for connections.
-  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
-  111216  0:16:42 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1
-  111216  0:16:42 [Note] WSREP: Synchronized with group, ready for connections
+  140113 12:23:43 [Note] /usr/sbin/mysqld: ready for connections.
+  Version: '5.5.34-55'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona XtraDB Cluster (GPL), wsrep_25.9.r3928
 
 On the second (and following nodes): ::
 
-   mysqld_safe
+   [root@node2 ~]# /etc/init.d/mysql start
 
 You should be able to see in console (or in error-log file): ::
 
-  111216  0:21:39 [Note] WSREP: Flow-control interval: [12, 23]
-  111216  0:21:39 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0)
-  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
-  111216  0:21:39 [Warning] WSREP: Gap in state sequence. Need state transfer.
-  111216  0:21:41 [Note] WSREP: Running: 'wsrep_sst_rsync 'joiner' '10.93.46.60' '' '/mnt/data/' '/etc/my.cnf' '1694' 2>sst.err'
-  111216  0:21:41 [Note] WSREP: Prepared SST request: rsync|10.93.46.60:4444/rsync_sst
-  111216  0:21:41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
-  111216  0:21:41 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1
-  111216  0:21:41 [Note] WSREP: prepared IST receiver, listening in: tcp://10.93.46.60:4568
-  111216  0:21:41 [Note] WSREP: Node 1 (node2) requested state transfer from '*any*'. Selected 0 (node1)(SYNCED) as donor.
-  111216  0:21:41 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
-  111216  0:21:41 [Note] WSREP: Requesting state transfer: success, donor: 0
-  111216  0:21:42 [Note] WSREP: 0 (node1): State transfer to 1 (node2) complete.
-  111216  0:21:42 [Note] WSREP: Member 0 (node1) synced with group.
-  111216  0:21:42 [Note] WSREP: SST complete, seqno: 0
-  111216  0:21:42 [Note] Plugin 'FEDERATED' is disabled.
-  111216  0:21:42 InnoDB: The InnoDB memory heap is disabled
-  111216  0:21:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
-  111216  0:21:42 InnoDB: Compressed tables use zlib 1.2.3
-  111216  0:21:42 InnoDB: Using Linux native AIO
-  111216  0:21:42 InnoDB: Initializing buffer pool, size = 128.0M
-  111216  0:21:42 InnoDB: Completed initialization of buffer pool
-  111216  0:21:42 InnoDB: highest supported file format is Barracuda.
-  111216  0:21:42  InnoDB: Waiting for the background threads to start
-  111216  0:21:43 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1597945
-  111216  0:21:43 [Note] Event Scheduler: Loaded 0 events
-  111216  0:21:43 [Note] WSREP: Signalling provider to continue.
-  111216  0:21:43 [Note] WSREP: Received SST: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0
-  111216  0:21:43 [Note] WSREP: SST finished: f912d2eb-27a2-11e1-0800-f34c520a3d4b:0
-  111216  0:21:43 [Note] /usr/sbin/mysqld: ready for connections.
-  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
-  111216  0:21:43 [Note] WSREP: 1 (node2): State transfer from 0 (node1) complete.
-  111216  0:21:43 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0)
-  111216  0:21:43 [Note] WSREP: Member 1 (node2) synced with group.
-  111216  0:21:43 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
-  111216  0:21:43 [Note] WSREP: Synchronized with group, ready for connections
+  140113 17:29:34 [Note] WSREP: New cluster view: global state: fb031d6e-7c4c-11e3-bf3a-ae73fcffc079:0, view# 8: Primary, number of nodes: 2, my index: 1, protocol version 2
+  140113 17:29:34 [Warning] WSREP: Gap in state sequence. Need state transfer.
+  140113 17:29:36 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.93.46.59' --auth '' --datadir '/mnt/data/' --defaults-file '/etc/my.cnf' --parent '29627''
+  cat: /var/lib/mysql//rsync_sst.pid: No such file or directory
+  140113 17:29:36 [Note] WSREP: Prepared SST request: rsync|10.93.46.59:4444/rsync_sst
+  140113 17:29:36 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
+  140113 17:29:36 [Note] WSREP: Assign initial position for certification: 0, protocol version: 2
+  140113 17:29:36 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (fb031d6e-7c4c-11e3-bf3a-ae73fcffc079): 1 (Operation not permitted)
+  at galera/src/replicator_str.cpp:prepare_for_IST():445. IST will be unavailable.
+  140113 17:29:36 [Note] WSREP: Node 1 (node1) requested state transfer from '*any*'. Selected 0 (node1)(SYNCED) as donor.
+  140113 17:29:36 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
+  140113 17:29:36 [Note] WSREP: Requesting state transfer: success, donor: 0
+  140113 17:29:39 [Note] WSREP: 0 (node1): State transfer to 1 (node1) complete.
+  140113 17:29:39 [Note] WSREP: Member 0 (node1) synced with group.
+  WSREP_SST: [INFO] Joiner cleanup. (20140113 17:29:39.792)
+  WSREP_SST: [INFO] Joiner cleanup done. (20140113 17:29:40.302)
+  140113 17:29:40 [Note] WSREP: SST complete, seqno: 0
+  140113 17:29:40 [Note] Plugin 'FEDERATED' is disabled.
+  140113 17:29:40 InnoDB: The InnoDB memory heap is disabled
+  140113 17:29:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
+  140113 17:29:40 InnoDB: Compressed tables use zlib 1.2.3
+  140113 17:29:40 InnoDB: Using Linux native AIO
+  140113 17:29:40 InnoDB: Initializing buffer pool, size = 128.0M
+  140113 17:29:40 InnoDB: Completed initialization of buffer pool
+  140113 17:29:40 InnoDB: highest supported file format is Barracuda.
+  InnoDB: Log scan progressed past the checkpoint lsn 1598437
+  140113 17:29:40  InnoDB: Database was not shut down normally!
+  InnoDB: Starting crash recovery.
+  InnoDB: Reading tablespace information from the .ibd files...
+  InnoDB: Restoring possible half-written data pages from the doublewrite
+  InnoDB: buffer...
+  InnoDB: Doing recovery: scanned up to log sequence number 1598607
+  140113 17:29:40  InnoDB: Waiting for the background threads to start
+  140113 17:29:41 Percona XtraDB (http://www.percona.com) 5.5.34-rel32.0 started; log sequence number 1598607
+  140113 17:29:41 [Note] Event Scheduler: Loaded 0 events
+  140113 17:29:41 [Note] WSREP: Signalling provider to continue.
+  140113 17:29:41 [Note] WSREP: SST received: fb031d6e-7c4c-11e3-bf3a-ae73fcffc079:0
+  140113 17:29:41 [Note] /usr/sbin/mysqld: ready for connections.
+  Version: '5.5.34-55'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona XtraDB Cluster (GPL), wsrep_25.9.r3928
+  140113 17:29:41 [Note] WSREP: 1 (node1): State transfer from 0 (node1) complete.
+  140113 17:29:41 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0)
+  140113 17:29:41 [Note] WSREP: Member 1 (node1) synced with group.
+  140113 17:29:41 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
+  140113 17:29:41 [Note] WSREP: Synchronized with group, ready for connections
+  140113 17:29:41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
 
 When all nodes are in SYNCED stage your cluster is ready!
 
 
=== modified file 'doc-pxc/source/howtos/cenots_howto.rst'
--- doc-pxc/source/howtos/cenots_howto.rst	2013-12-30 17:01:54 +0000
+++ doc-pxc/source/howtos/cenots_howto.rst	2014-02-06 09:58:46 +0000
@@ -65,9 +65,6 @@
   # MyISAM storage engine has only experimental support
   default_storage_engine=InnoDB
 
-  # This is a recommended tuning variable for performance
-  innodb_locks_unsafe_for_binlog=1
-
   # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
   innodb_autoinc_lock_mode=2
 
@@ -152,9 +149,6 @@
   # MyISAM storage engine has only experimental support
   default_storage_engine=InnoDB
 
-  # This is a recommended tuning variable for performance
-  innodb_locks_unsafe_for_binlog=1
-
   # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
   innodb_autoinc_lock_mode=2
 
@@ -216,9 +210,6 @@
   # MyISAM storage engine has only experimental support
   default_storage_engine=InnoDB
 
-  # This is a recommended tuning variable for performance
-  innodb_locks_unsafe_for_binlog=1
-
   # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
   innodb_autoinc_lock_mode=2
 
 
=== removed file 'doc-pxc/source/howtos/kewpietests.rst'
--- doc-pxc/source/howtos/kewpietests.rst	2012-06-27 10:05:05 +0000
+++ doc-pxc/source/howtos/kewpietests.rst	1970-01-01 00:00:00 +0000
@@ -1,35 +0,0 @@
-===========================
-How to Execute Kewpie Tests
-===========================
-
-To use kewpie for testing it's recommended to use `this MP <https://code.launchpad.net/~patrick-crews/percona-xtradb-cluster/qp-integrate/+merge/93648>`_. As it removes dbqp and integrates kewpie (and cuts size down to 25MB from 400+).
-To execute tests: 
-
-.. code-block:: bash
-
-   cd kewpie ; ./kewpie.py [--force ] [--libeatmydata] [--wsrep-provider-path=...]
-                  
-The defaults are to run the cluster_basic and cluster_randgen suites against a 3 node cluster. Cluster_basic is used for small atomic tests like ADD/DROP single/multiple columns on a table and ensuring the change is replicated. cluster_randgen is used for high stress transactional loads.  There are single and multi-threaded variants.  The load is a mix of INSERT/UPDATE/DELETE/SELECT statements.  This includes both regular transactions, single queries, ROLLBACK's and SAVEPOINTs, and a mix of good and bad SQL statements.
-               
-To view all options, one may look at "./kewpie.py --help".  Basic documentation is also available as sphinx docs in kewpie/docs folder. Here are the some of the most used options:
-
-.. option:: --force 
-
-   Run all tests despite failures (default is to stop test execution on first failure)
-
-.. option:: --libeatmydata 
-
-   Use libeatmydata if installed. This can greatly speed up testing in many cases.  Can be used in conjunction with:
-
-.. option:: --libeatmydata-path to specify where the library is located.
-
-.. option:: --wsrep-provider-path  
-   
-   By default, we expect / look for it in /usr/lib/galera/libgalera_smm.so (where it ends up via 'make install'...at least on Ubuntu).  If one has an alternate library/location, specify it with this option.
-
-Any additional suites may be run this way: 
-
-.. code-block:: bash
-
-   ./kewpie.py [options] --suite=any/suitedir/from/kewpie/percona_tests
-   ./kewpie.py --suite=crashme
 
=== modified file 'doc-pxc/source/howtos/singlebox.rst'
--- doc-pxc/source/howtos/singlebox.rst	2012-07-30 09:26:20 +0000
+++ doc-pxc/source/howtos/singlebox.rst	2014-02-06 09:58:46 +0000
@@ -1,3 +1,6 @@
+.. _single_box:
+
+==========================================
 How to setup 3 node cluster on single box
 ==========================================
 
@@ -23,7 +26,7 @@
 
 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): ::
 
-        bin/mysqld_safe --defaults-file=/etc/my.4000.cnf
+        bin/mysqld_safe --defaults-file=/etc/my.4000.cnf --wsrep-new-cluster
 
 Following output will let out know that node was started successfully: ::
 
@@ -61,15 +64,10 @@
         
         mysql -h127.0.0.1 -P5000 -e "CREATE DATABASE hello_peter"
 
-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`.
-
 Configuration files (/etc/my.4000.cnf): ::
 
   /etc/my.4000.cnf
 
-  [mysqld_safe]
-  wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://
-
   [mysqld]
   port = 4000
   socket=/tmp/mysql.4000.sock
@@ -78,6 +76,7 @@
   user=mysql
   log_error=error.log
   binlog_format=ROW
+  wsrep_cluster_address='gcomm://192.168.2.21:5030,192.168.2.21:6030'
   wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so
   wsrep_sst_receive_address=192.168.2.21:4020
   wsrep_node_incoming_address=192.168.2.21 
@@ -86,7 +85,6 @@
   wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.2.21:4030;"
   wsrep_sst_method=rsync
   wsrep_node_name=node4000
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
 
 
@@ -94,9 +92,6 @@
 
   /etc/my.5000.cnf
 
-  [mysqld_safe]
-  wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://
-
   [mysqld]
   port = 5000
   socket=/tmp/mysql.5000.sock
@@ -105,6 +100,7 @@
   user=mysql
   log_error=error.log
   binlog_format=ROW
+  wsrep_cluster_address='gcomm://192.168.2.21:4030,192.168.2.21:6030'
   wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so
   wsrep_sst_receive_address=192.168.2.21:5020
   wsrep_node_incoming_address=192.168.2.21 
@@ -113,16 +109,12 @@
   wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.2.21:5030;"
   wsrep_sst_method=rsync
   wsrep_node_name=node5000
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
 
 Configuration files (/etc/my.6000.cnf): ::
 
   /etc/my.6000.cnf
 
-  [mysqld_safe]
-  wsrep_urls=gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://
-
   [mysqld]
   port = 6000
   socket=/tmp/mysql.6000.sock
@@ -131,6 +123,7 @@
   user=mysql
   log_error=error.log
   binlog_format=ROW
+  wsrep_cluster_address='gcomm://192.168.2.21:4030,192.168.2.21:5030'
   wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24-23.6.342.Linux.x86_64/lib/libgalera_smm.so
   wsrep_sst_receive_address=192.168.2.21:6020
   wsrep_node_incoming_address=192.168.2.21 
@@ -139,5 +132,4 @@
   wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.2.21:6030;"
   wsrep_sst_method=rsync
   wsrep_node_name=node6000
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
 
=== modified file 'doc-pxc/source/howtos/ubuntu_howto.rst'
--- doc-pxc/source/howtos/ubuntu_howto.rst	2013-12-30 17:01:54 +0000
+++ doc-pxc/source/howtos/ubuntu_howto.rst	2014-02-06 09:58:46 +0000
@@ -68,9 +68,6 @@
   # MyISAM storage engine has only experimental support
   default_storage_engine=InnoDB
 
-  # This is a recommended tuning variable for performance
-  innodb_locks_unsafe_for_binlog=1
-
   # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
   innodb_autoinc_lock_mode=2
 
@@ -149,9 +146,6 @@
   # MyISAM storage engine has only experimental support
   default_storage_engine=InnoDB
 
-  # This is a recommended tuning variable for performance
-  innodb_locks_unsafe_for_binlog=1
-
   # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
   innodb_autoinc_lock_mode=2
 
@@ -213,9 +207,6 @@
   # MyISAM storage engine has only experimental support
   default_storage_engine=InnoDB
 
-  # This is a recommended tuning variable for performance
-  innodb_locks_unsafe_for_binlog=1
-
   # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
   innodb_autoinc_lock_mode=2
 
 
=== modified file 'doc-pxc/source/howtos/virt_sandbox.rst'
--- doc-pxc/source/howtos/virt_sandbox.rst	2012-06-27 10:05:05 +0000
+++ doc-pxc/source/howtos/virt_sandbox.rst	2014-02-06 09:58:46 +0000
@@ -34,7 +34,6 @@
 
   log_slave_updates
 
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
   innodb_buffer_pool_size=400M
   innodb_log_file_size=64M
 
=== modified file 'doc-pxc/source/installation.rst'
--- doc-pxc/source/installation.rst	2013-12-30 17:01:54 +0000
+++ doc-pxc/source/installation.rst	2014-02-06 09:58:46 +0000
@@ -64,7 +64,6 @@
   
   binlog_format=ROW - In order for Galera to work correctly binlog format should be ROW
   default_storage_engine=InnoDB - MyISAM storage engine has only experimental support
-  innodb_locks_unsafe_for_binlog=1 - This is a recommended tuning variable for performance
   innodb_autoinc_lock_mode=2 - This changes how InnoDB autoincrement locks are managed
 
 Additional parameters to specify: ::
@@ -81,7 +80,6 @@
   wsrep_sst_method=rsync
   binlog_format=ROW
   default_storage_engine=InnoDB
-  innodb_locks_unsafe_for_binlog=1
   innodb_autoinc_lock_mode=2
 
 Detailed list of variables can be found in :ref:`wsrep_system_index` and :ref:`wsrep_status_index`.
 
=== removed file 'doc-pxc/source/percona-theme/built'