MySQL [(none)]> set global wsrep_provider='none';
Query OK, 0 rows affected (2.02 sec)
MySQL [(none)]> set global wsrep_provider='/usr/lib64/libgalera_smm.so';
Query OK, 0 rows affected (2.03 sec)
MySQL [(none)]> set global wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:4010"; -- Fails due to no cluster address, this is OK
ERROR 1210 (HY000): Incorrect arguments to SET
MySQL [(none)]>
MySQL [(none)]> set global wsrep_cluster_address='gcomm://127.0.0.1:5010,127.0.0.1:6010'; --- Fails (in log), but lets ignore that for now.
Query OK, 0 rows affected (35.02 sec)
MySQL [(none)]> set global wsrep_cluster_address='gcomm://';
Query OK, 0 rows affected (2.00 sec)
MySQL [(none)]> set global wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:4010"; ------ This fails.
ERROR 1210 (HY000): Incorrect arguments to SET
It fails with:
================
2014-04-30 10:04:30 13562 [Note] WSREP: Nobody is waiting for SST.
2014-04-30 10:04:34 13562 [Warning] WSREP: error setting param gmcast.listen_addr to value tcp://127.0.0.1:4010: can't change value for 'gmcast.listen_addr' during runtime: 1 (Operation not permitted)
at gcomm/src/gmcast.cpp:set_param():1640
2014-04-30 10:04:34 13562 [Warning] WSREP: Setting parameter 'gmcast.listen_addr' to 'tcp://127.0.0.1:4010' failed: Setting 'gmcast.listen_addr' to 'tcp://127.0.0.1:4010' failed: 1 (Operation not permitted)
at galera/src/gcs.hpp:param_set():206
2014-04-30 10:04:34 13562 [ERROR] WSREP: Set options returned 7
2014-04-30 10:04:34 13562 [Note] WSREP: refresh_provider_options: gmcast.listen_addr=tcp://127.0.0.1:4010
The problem is that, without ability to set listen_addr before it
actually listens, it ends up listening on default addr:port.
@Yan,
It works but I noticed this:
MySQL [(none)]> set global wsrep_provider= 'none';
Query OK, 0 rows affected (2.02 sec)
MySQL [(none)]> set global wsrep_provider= '/usr/lib64/ libgalera_ smm.so' ;
Query OK, 0 rows affected (2.03 sec)
MySQL [(none)]> set global wsrep_provider_ options= "gmcast. listen_ addr=tcp: //127.0. 0.1:4010" ; -- Fails due to no cluster address, this is OK address= 'gcomm: //127.0. 0.1:5010, 127.0.0. 1:6010' ; --- Fails (in log), but lets ignore that for now.
ERROR 1210 (HY000): Incorrect arguments to SET
MySQL [(none)]>
MySQL [(none)]> set global wsrep_cluster_
Query OK, 0 rows affected (35.02 sec)
MySQL [(none)]> set global wsrep_cluster_ address= 'gcomm: //';
Query OK, 0 rows affected (2.00 sec)
MySQL [(none)]> set global wsrep_provider_ options= "gmcast. listen_ addr=tcp: //127.0. 0.1:4010" ; ------ This fails.
ERROR 1210 (HY000): Incorrect arguments to SET
It fails with:
================
2014-04-30 10:04:30 13562 [Note] WSREP: Nobody is waiting for SST. 0.0.1:4010: can't change value for 'gmcast. listen_ addr' during runtime: 1 (Operation not permitted) gmcast. cpp:set_ param() :1640 listen_ addr' to 'tcp:// 127.0.0. 1:4010' failed: Setting 'gmcast. listen_ addr' to 'tcp:// 127.0.0. 1:4010' failed: 1 (Operation not permitted) src/gcs. hpp:param_ set():206 provider_ options: gmcast. listen_ addr=tcp: //127.0. 0.1:4010
2014-04-30 10:04:34 13562 [Warning] WSREP: error setting param gmcast.listen_addr to value tcp://127.
at gcomm/src/
2014-04-30 10:04:34 13562 [Warning] WSREP: Setting parameter 'gmcast.
at galera/
2014-04-30 10:04:34 13562 [ERROR] WSREP: Set options returned 7
2014-04-30 10:04:34 13562 [Note] WSREP: refresh_
The problem is that, without ability to set listen_addr before it
actually listens, it ends up listening on default addr:port.
wsrep_provider_ options - http:// paste.wnohang. net/5368df