# Percona Xtradb Cluster not accepting options on command line

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 31, 2019, 2:24am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145 "2019-07-31T02:24:36Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![ekonomi](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ekonomi](https://forums.percona.com/u/ekonomi)\
**Post date:** [July 31, 2019, 2:24am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/1 "2019-07-31T02:24:36Z")

</div>

I am using Percona Xtradb Cluster 5.7 and trying to start my cluster through a donor node via command line and I am getting this error:

[root@pxc1 mydata]# systemctl start mysql --wsrep\_sst\_donor=pxc3  
systemctl: unrecognized option ‘–wsrep\_sst\_donor=pxc3’

I am running 3 nodes cluster. I have started my first node-A with bootstrap, then started second node-B which synced with node-A and now i want my third node-C to sync with the first one node-A as well, but it seems not possible. Is to possible at all to do this on centos7?

---

<div class="post-metadata">

**Author:** ![ekonomi](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ekonomi](https://forums.percona.com/u/ekonomi)\
**Post date:** [August 2, 2019, 6:04am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/2 "2019-08-02T06:04:01Z")

</div>

Nobody has nothing to say about his issue?

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [August 2, 2019, 10:44am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/3 "2019-08-02T10:44:32Z")

</div>

Hi there, thanks for your question.

For someone to help you, and therefore to get quicker attention on the Forum, you have to provide much more information for example my.cnf from every node, any log files that are getting written, is this a new installation or an existing one that is causing trouble, what is the specific version of Percona XtraDB Cluster that you are using, is there anything “special” about your server environment etc etc

Without this information it’s hard for engineers to help. Here’s a post that tells you a little more: [URL=“[https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/50706-troubleshooting-percona-xtradb-cluster-and-how-to-report-a-bug](https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/50706-troubleshooting-percona-xtradb-cluster-and-how-to-report-a-bug)”][https://www.percona.com/forums/quest...o-report-a-bug[/URL]](https://www.percona.com/forums/quest...o-report-a-bug%5B/URL%5D)

If you need help in a specific time scale, then we do offer paid support services. With paid support you get a guaranteed response time. With the open source community forum, then there’s no guarantee of a response, but the more information you provide, the more likely it is that someone will be able to quickly see an issue and help you out.

Hope this helps.

---

<div class="post-metadata">

**Author:** ![ekonomi](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ekonomi](https://forums.percona.com/u/ekonomi)\
**Post date:** [August 5, 2019, 4:34am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/4 "2019-08-05T04:34:21Z")

</div>

Hello, thanks for your response.

Find below the requested info:

–Percona Server version:

5.7.25-28-57-log

–SO version

CentOS Linux release 7.6.1810 (Core)

–Percona my.cnf file (this is the same on the 3 nodes)

[mysql]

# CLIENT

port = 3306  
socket = /mydata/mysql.sock

[mysqld]

# GENERAL

user = mysql  
default-storage-engine = InnoDB  
socket = /mydata/mysql.sock  
pid-file = /mydata/mysql.pid  
#old\_passwords = 1

# MyISAM

key-buffer-size = 32M  
myisam-recover-options = FORCE,BACKUP

#Enable Federated Storage Engine  
federated

# SAFETY

max-allowed-packet = 128M  
max-connect-errors = 1000000

# DATA STORAGE

datadir = /mydata

# BINARY LOGGING

log-bin = /mydata/mysql-bin  
expire-logs-days = 1  
sync-binlog = 1  
server\_id = 1

# CACHES AND LIMITS

tmp-table-size = 32M  
max-heap-table-size = 32M  
query-cache-type = 0  
query-cache-size = 0  
max-connections = 500  
thread-cache-size = 50  
open-files-limit = 65535  
table-definition-cache = 4096  
table-open-cache = 4096

# INNODB

innodb-flush-method = O\_DIRECT  
innodb-log-files-in-group = 2  
innodb-log-file-size = 512M  
innodb-flush-log-at-trx-commit = 1  
innodb-file-per-table = 1  
innodb-buffer-pool-size = 1456M

# LOGGING

log-error = /var/log/mysqld.log  
log-queries-not-using-indexes = 1  
#slow-query-log = 1  
#slow-query-log-file = /var/lib/mysql/mysql-slow.log

# ## XTRADB PARAMETERS ##

wsrep\_provider=/usr/lib64/galera3/libgalera\_smm.so

wsrep\_cluster\_name=pxc-cluster-dev  
wsrep\_cluster\_address=gcomm://10.10.10.2,10.10.10.3,10.10.10.4

wsrep\_node\_name=pxc1  
wsrep\_node\_address=10.10.10.2

wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=“xxxxxxxxxxx”  
wsrep\_replicate\_myisam = 1  
wsrep\_slave\_threads=2

#gcache.size  
wsrep\_provider\_options=“gcache.size=768M;gcache.recover = yes”

binlog\_format=ROW  
innodb\_autoinc\_lock\_mode=2

[mysqldump]  
max-allowed-packet = 128M

---

<div class="post-metadata">

**Author:** ![ekonomi](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ekonomi](https://forums.percona.com/u/ekonomi)\
**Post date:** [August 7, 2019, 1:49am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/5 "2019-08-07T01:49:51Z")

</div>

Somebody has a clue how to start a node of a cluster through a donor with --wsrep\_sst\_donor option?

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [August 7, 2019, 2:05am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/6 "2019-08-07T02:05:06Z")

</div>

I am sorry, ekonomi, but you cannot expect instant responses from a non-paid forum.

If you need fast responses from the Percona team then I am afraid that you will have to pay for support. The Forum should not be mistaken for “free support”.

FWIW I have asked the team to look at your question when they have some time but the forum is not their priority. It may be that a community member will help you quicker, or if you need instant help please consider our support options. [URL][https://www.percona.com/services/support/percona-support-levels[/URL]](https://www.percona.com/services/support/percona-support-levels%5B/URL%5D)

You should also try searching our site for help, for example this may well apply to you (bottom answer): [URL][https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/53007-cannot-run-donor-command-on-cli[/URL]](https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/53007-cannot-run-donor-command-on-cli%5B/URL%5D)

---

<div class="post-metadata">

**Author:** ![steven\_Lin](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@steven\_Lin](https://forums.percona.com/u/steven_Lin)\
**Post date:** [August 7, 2019, 6:28am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/7 "2019-08-07T06:28:08Z")

</div>

It’s funny that you gave a mysqld option “–wsrep\_sst\_donor” to the linux command “systemctl”.  
you can try startup mysqld manually and try again.

[URL][https://mariadb.com/kb/en/library/starting-and-stopping-mariadb-getting-systemctl-start-mysql-wsrep\_new\_clust/[/URL]](https://mariadb.com/kb/en/library/starting-and-stopping-mariadb-getting-systemctl-start-mysql-wsrep_new_clust/%5B/URL%5D)

---

<div class="post-metadata">

**Author:** ![alok.pathak](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alok.pathak/32/1017_2.png) [@alok.pathak](https://forums.percona.com/u/alok.pathak)\
**Post date:** [August 7, 2019, 6:55am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/8 "2019-08-07T06:55:41Z")

</div>

Hi [ekonomi](https://www.percona.com/forums/member/42204-ekonomi),

Instead of passing wsrep\_sst\_donor on the command line, you should set the same in the my.cnf of joiner node.

[pxc1] vim /etc/my.cnf or the config file in use.

[mysqld]  
…  
wsrep\_sst\_donor=pxc3

Save my.cnf and start MySQL service, It should use pxc3 as a donor for SST. You can confirm the same from error logs of pxc1 while SST is running.

[pxc1] systemctl start mysql

Once pxc1 has joined the cluster, you can comment the line “wsrep\_sst\_donor…” if you want.

---

<div class="post-metadata">

**Author:** ![ekonomi](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ekonomi](https://forums.percona.com/u/ekonomi)\
**Post date:** [August 7, 2019, 7:46am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/9 "2019-08-07T07:46:11Z")

</div>

Thank you lorraine.pocklington, I appreciate your kindness and help!

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [August 7, 2019, 7:54am UTC](https://forums.percona.com/t/percona-xtradb-cluster-not-accepting-options-on-command-line/7145/10 "2019-08-07T07:54:02Z")

</div>

🙂 you’re welcome.

Feel free to ask any time… but also try to be a little bit patient 😉
