# Installing Percona XtraDB Cluster on Ubuntu 16.04

**URL:** <https://forums.percona.com/t/installing-percona-xtradb-cluster-on-ubuntu-16-04/5921>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 9, 2017, 11:17pm UTC](https://forums.percona.com/t/installing-percona-xtradb-cluster-on-ubuntu-16-04/5921 "2017-10-09T23:17:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dirk23](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@Dirk23](https://forums.percona.com/u/Dirk23)\
**Post date:** [October 9, 2017, 11:17pm UTC](https://forums.percona.com/t/installing-percona-xtradb-cluster-on-ubuntu-16-04/5921/1 "2017-10-09T23:17:14Z")

</div>

Hi,

since some says now i try to start a Percona XtraDB Cluster on Ubuntu 16.04. I started with these instructions: [url][https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html[/url]](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html%5B/url%5D) but it seems they are partially outdated. Adding wsrep variables to /etc/mysql/my.cnf does not really work, i added these variables to /etc/mysql/percona-xtradb-cluster.conf.d/mysqld.cnf, maybe that is not correct?. So i ran through this instructions step by step and changed variables to my meet my environment. I could bootstrap the first node successfully, but when i start a second node, the wsrep\_cluster\_size wont rise to “2” and when i create a new database it is not synced to the 2nd node.

Can somebody please give me a hint, what i did wrong?

My Configs are

1. Node:  
wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_cluster\_name=DB-Cluster  
wsrep\_cluster\_address=gcomm://192.168.0.61,192.168.0.62,192.168.0.63  
wsrep\_node\_name=DB-1  
wsrep\_node\_address=192.168.0.61  
wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=sstuser:S0meSecurePa$$w0rd!  
pxc\_strict\_mode=ENFORCING  
binlog\_format=ROW  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2

2. Node:  
wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_cluster\_name=DB-Cluster  
wsrep\_cluster\_address=gcomm://192.168.0.61,192.168.0.62,192.168.0.63  
wsrep\_node\_name=DB-2  
wsrep\_node\_address=192.168.0.62  
wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=sstuser:S0meSecurePa$$w0rd!  
pxc\_strict\_mode=ENFORCING  
binlog\_format=ROW  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2

3. Node:  
wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_cluster\_name=DB-Cluster  
wsrep\_cluster\_address=gcomm://192.168.0.61,192.168.0.62,192.168.0.63  
wsrep\_node\_name=DB-3  
wsrep\_node\_address=192.168.0.63  
wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=sstuser:S0meSecurePa$$w0rd!  
pxc\_strict\_mode=ENFORCING  
binlog\_format=ROW  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2

Thanks!

Dirk

---

<div class="post-metadata">

**Author:** ![krunalbauskar](https://avatars.discourse-cdn.com/v4/letter/k/439d5e/32.png) [@krunalbauskar](https://forums.percona.com/u/krunalbauskar)\
**Post date:** [October 11, 2017, 11:56pm UTC](https://forums.percona.com/t/installing-percona-xtradb-cluster-on-ubuntu-16-04/5921/2 "2017-10-11T23:56:11Z")

</div>

Can you share the error/mysqld.log for node-2.  
How big is your DB. Wondeing if SST is taking time.

---

<div class="post-metadata">

**Author:** ![Dirk23](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@Dirk23](https://forums.percona.com/u/Dirk23)\
**Post date:** [February 28, 2018, 8:13am UTC](https://forums.percona.com/t/installing-percona-xtradb-cluster-on-ubuntu-16-04/5921/3 "2018-02-28T08:13:06Z")

</div>

The problem was simple: i edited .cnf file in /etc/mysql/ but there is a predefined wsrep.cnf file for these wsrep variables in /etc/mysql/percona-xtradb-cluster.conf.d/ wich overrides everything i added to any other .cnf File. No wonder why the cluster wont come up, because of this config File! Now i have a working cluster.

Sorry for the delay here.

---

<div class="post-metadata">

**Author:** ![krunalbauskar](https://avatars.discourse-cdn.com/v4/letter/k/439d5e/32.png) [@krunalbauskar](https://forums.percona.com/u/krunalbauskar)\
**Post date:** [March 1, 2018, 9:58pm UTC](https://forums.percona.com/t/installing-percona-xtradb-cluster-on-ubuntu-16-04/5921/4 "2018-03-01T21:58:18Z")

</div>

No probs. Good to hear you have working cluster. Enjoy PXC.
