# New Cluster: nodes 2 and 3 don't join but rather start their own clusters

**URL:** <https://forums.percona.com/t/new-cluster-nodes-2-and-3-dont-join-but-rather-start-their-own-clusters/6003>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [November 16, 2017, 6:37am UTC](https://forums.percona.com/t/new-cluster-nodes-2-and-3-dont-join-but-rather-start-their-own-clusters/6003 "2017-11-16T06:37:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cyclonebt](https://avatars.discourse-cdn.com/v4/letter/c/4da419/32.png) [@cyclonebt](https://forums.percona.com/u/cyclonebt)\
**Post date:** [November 16, 2017, 6:37am UTC](https://forums.percona.com/t/new-cluster-nodes-2-and-3-dont-join-but-rather-start-their-own-clusters/6003/1 "2017-11-16T06:37:00Z")

</div>

Followed the instructions exactly by using copy/paste, changing nothing but the IP addresses involved.

However. when I start the second node using the instructions above, it comes up not as a member of the cluster but isolated.

first host:  
±-------------------------±-------------------------------------+  
| Variable\_name | Value |  
±-------------------------±-------------------------------------+  
| wsrep\_cluster\_conf\_id | 1 |  
| wsrep\_cluster\_size | 1 |  
| wsrep\_cluster\_state\_uuid | f28ae440-cabb-11e7-976c-17bca5fe1b6b |  
| wsrep\_cluster\_status | Primary |  
±-------------------------±-------------------------------------+

±-------------------------±-------------------------------------+  
| Variable\_name | Value |  
±-------------------------±-------------------------------------+  
| wsrep\_cluster\_conf\_id | 1 |  
| wsrep\_cluster\_size | 1 |  
| wsrep\_cluster\_state\_uuid | 9df5f23e-cabc-11e7-b6e2-030d02b0e16b |  
| wsrep\_cluster\_status | Primary |  
±-------------------------±-------------------------------------+

Environment: Ubuntu 16.04, fresh install with only apt-get update && apt-get upgrade -y done prior to installing cluster. ufw firewall is disabled

config from host 1:

# Template my.cnf for PXC

# Edit to your requirements.

[mysqld]  
server-id=1  
datadir=/var/lib/mysql  
socket=/var/run/mysqld/mysqld.sock  
log-error=/var/log/mysqld.log  
pid-file=/var/run/mysqld/mysqld.pid  
log-bin log\_slave\_updates  
expire\_logs\_days=7

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_cluster\_name=pxc-cluster  
wsrep\_cluster\_address=gcomm://192.168.175.141,192.168.168.30  
wsrep\_node\_name=pxc1  
wsrep\_node\_address=192.168.175.141  
wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=sstuser:passw0rd  
pxc\_strict\_mode=ENFORCING  
binlog\_format=ROW  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2

# Template my.cnf for PXC

# Edit to your requirements.

[mysqld]  
server-id=2  
datadir=/var/lib/mysql  
socket=/var/run/mysqld/mysqld.sock  
log-error=/var/log/mysqld.log  
pid-file=/var/run/mysqld/mysqld.pid  
log-bin log\_slave\_updates  
expire\_logs\_days=7

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_cluster\_name=pxc-cluster  
wsrep\_cluster\_address=gcomm://192.168.175.141,192.168.168.30  
wsrep\_node\_name=pxc2  
wsrep\_node\_address=192.168.168.30  
wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=sstuser:passw0rd  
pxc\_strict\_mode=ENFORCING  
binlog\_format=ROW  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2

±--------------±----------+  
| user | host |  
±--------------±----------+  
| mysql.session | localhost |  
| mysql.sys | localhost |  
| root | localhost |  
| sstuser | localhost |  
±--------------±----------+  
±---------------------------------------------------------------------------------------+  
| Grants for sstuser@localhost |  
±---------------------------------------------------------------------------------------+  
| GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON _._ TO ‘sstuser’@‘localhost’ |  
±---------------------------------------------------------------------------------------+

This seems to be similar to [https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/49397-i-cannot-join-nodes-to-cluster-after-bootstrap](https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/49397-i-cannot-join-nodes-to-cluster-after-bootstrap) and [https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/49973-fresh-install-ubuntu1604-all-3-nodes-report-cluster-size-of-1](https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/49973-fresh-install-ubuntu1604-all-3-nodes-report-cluster-size-of-1) – neither of which has an answer.

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [November 17, 2017, 2:19pm UTC](https://forums.percona.com/t/new-cluster-nodes-2-and-3-dont-join-but-rather-start-their-own-clusters/6003/2 "2017-11-17T14:19:06Z")

</div>

This is interesting, from your second node it says it had found a saved state on boot:

```auto
2017-11-16T11:03:01.282066Z mysqld_safe Assigning 9df5f23e-cabc-11e7-b6e2-030d02b0e16b:0 to wsrep_start_position

```

Was the second node fresh install or was it part of the cluster before? Can you stop the second node, cleanup the data directory and start it again?