Bootstrapping behavior with pc.wait_prim=false ?

I have a quick question with pc.wait_prim=false behavior.

According to:
https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1413258

There’s a bug that was verified that you can’t use pc.wait_prim=false as it just hangs.

If I’m using this option, mysql should fire up where I can connect to it to be able to 'SET GLOBAL wsrep_provider_options=“pc.bootstrap=1”; ’ if I’m using the latest code, correct?

I ask, because with what’s currently in the Percona repo’s doesn’t allow it for 5.6, though it does at least allow you to kill the daemon to make it shut down gracefully, at least for RHEL6.5.7…

Any help appreciated…
-b

Steps I used to test:

sudo yum install http://pkgs.repoforge.org/socat/socat-1.7.2.4-1.el6.rf.x86_64.rpm
sudo yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
sudo yum install Percona-XtraDB-Cluster-56.x86_64

Config file - bare minimums to get this to start (dns is valid and resolves for my env):

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

innodb_autoinc_lock_mode=2

#==============================

Galera

#==============================

Automatically adjust auto_increment_increment and auto_increment_offset system variables when cluster membership changes.

wsrep_auto_increment_control = on

This variable is used to control if Foreign Key checking is done for applier threads.

wsrep_slave_FK_checks

Enable debug log output

wsrep_debug = off

An option to explicitly specify the network address of the node if autoguessing for some reason does not produce

desirable results (multiple network interfaces, NAT, etc.) If not explicitly overridden by

wsrep_sst_receive_address, the part will be used to listen for SST (the port is still SST method-

dependent). And the whole [:port] string will be passed to wsrep provider to be used as a base address

in its communications.

wsrep_node_address

A name (given in wsrep_node_name) of the server that should be used as a source for state transfer.

If not specified, Galera will choose the most appropriate one.

wsrep_sst_donor

A string of provider options passed directly to provider.

See http://www.codership.com/wiki/doku.php?id=galera_parameters_0.8

wsrep_provider_options = gmcast.listen_addr=tcp://0.0.0.0:13306;evs.keepalive_period=PT3S;evs.inactive_check_period=PT10S;evs.suspect_timeout=PT30S;evs.inactive_timeout=PT1M;evs.install_timeout=PT1M;ist.recv_addr=tcp://springsing.test:13307

This variable can be used to reject queries for that node.

wsrep_reject_queries = NONE

This variable is used to control if Unique Key checking is done for applier threads.

wsrep_slave_UK_checks

Logical node name - for convenience. (Defaults to hostname)

wsrep_node_name

Maximum allowed writeset size. Currently it limits supported size of transaction and LOAD DATA statement.

wsrep_max_ws_size = 1073741824

A string with authentication information for state snapshot transfer. It depends on the state transfer method.

For mysqldump state transfer it should be : where user has root privileges on this server.

For rsync method it is ignored.

wsrep_sst_auth = sstauth:sstauth

When enabled this option will use new, transparent handling of preordered replication events (like replication from traditional master).

wsrep_preordered = off

Logical cluster name. If a node tries to connect to a cluster with a different name, connection fails

wsrep_cluster_name = tester

A path to wsrep provider to load. If not specified, all calls to wsrep provider will be bypassed.

wsrep_provider = /usr/lib64/libgalera_smm.so

This variable exists for the sole purpose of notifying joining node about state transfer completion.

See http://www.codership.com/wiki/doku.php?id=scriptable_state_snapshot_transfer

wsrep_start_position

If an autocommit query fails due to cluster-wide conflict we can retry it without returning error to client.

This sets how many times to retry.

wsrep_retry_autocommit = 1

This variable is used to send the DBUG option to the wsrep provider.

wsrep_dbug_option = off

This variable controls how many replication events will be grouped together. This implementation is still experimental.

wsrep_mysql_replication_bundle = 0

The address at which this node expects to receive state transfer. Depends on state transfer method. E.g. for

mysqldump state transfer it is the address and the port on which this server listens.

wsrep_sst_receive_address = springsing.test:13308

In some cases master may apply event faster than a slave, which can cause master and slave being out-of-sync for a brief moment.

When this variable is set to ON slave will wait till that event is applied before doing any other queries.

wsrep_causal_reads = off

Address to connect to cluster. Provider specific. Galera takes addresses in URL format:

://[?option1=value1[&option2=value2]]

e.g. gcomm://192.168.0.1:4567?gmcast.listen_addr=0.0.0.0:5678

wsrep_cluster_address = gcomm://springsing.test:13306,toldcontrolled.test:13306?pc.wait_prim=false

Maximum number of rows allowed in the writeset. Currently it limits supported size of transaction and LOAD DATA statement.

wsrep_max_ws_rows = 131072

How many threads to use for applying slave writsets.

wsrep_slave_threads = 4

Generate primary keys for rows without ones for the purpose of certification. This is required fori

parallel applying. We don’t recommend using tables without primary keys.

wsrep_certify_nonPK = on

A command to run when cluster membership or state of this node changes.

wsrep_notify_cmd

This variable is used to control whether sole cluster conflicts should be logged. When enabled details of conflicting InnoDB lock will be logged.

wsrep_log_conflicts = off

Online schema upgrade method (MySQL >= 5.5.17).

See http://www.codership.com/wiki/doku.php?id=rolling_schema_upgrade

wsrep_OSU_method = TOI

Use wsrep replication. When turned off, no changes made in this session will be replicated.

wsrep_on = on

When this variable is enabled SST donor node will not accept incoming queries, instead it will reject queries with UNKNOWN COMMAND error code.

This can be used to signal load-balancer that the node isn’t available.

wsrep_sst_donor_rejects_queries = off

Address at which server expects client connections. Intended for integration with load balancers.

Not used for now.

wsrep_node_incoming_address

A method to use for state snapshot transfer. wsrep_sst_<wsrep_sst_method> command will be called with

arguments from http://www.codership.com/wiki/doku.php?id=scriptable_state_snapshot_transfer

wsrep_sst_method = xtrabackup-v2

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid