# problem with sync

**URL:** <https://forums.percona.com/t/problem-with-sync/2542>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 4, 2013, 4:42am UTC](https://forums.percona.com/t/problem-with-sync/2542 "2013-03-04T04:42:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![matrix\_ua](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@matrix\_ua](https://forums.percona.com/u/matrix_ua)\
**Post date:** [March 4, 2013, 4:42am UTC](https://forums.percona.com/t/problem-with-sync/2542/1 "2013-03-04T04:42:39Z")

</div>

Trying to set up a cluster of three nodes and there is no synchronization.  
Conf node1:

[mysqld]  
server\_id=1  
binlog\_format=ROW  
log\_bin=mysql-bin  
wsrep\_cluster\_address=gcomm://  
wsrep\_provider=/usr/lib/libgalera\_smm.so  
datadir=/var/lib/mysql

wsrep\_slave\_threads=2  
wsrep\_cluster\_name=pxctest  
wsrep\_sst\_method=xtrabackup  
wsrep\_node\_name=Galera\_cluster

log\_slave\_updates

innodb\_locks\_unsafe\_for\_binlog=1  
innodb\_autoinc\_lock\_mode=2  
innodb\_buffer\_pool\_size=400M  
innodb\_log\_file\_size=64M

Conf node2:

[mysqld]  
server\_id=2  
binlog\_format=ROW  
log\_bin=mysql-bin  
wsrep\_cluster\_address=gcomm://192.168.0.102 // ← this ip node1  
wsrep\_provider=/usr/lib/libgalera\_smm.so  
datadir=/var/lib/mysql

wsrep\_slave\_threads=2  
wsrep\_cluster\_name=pxctest  
wsrep\_sst\_method=xtrabackup  
wsrep\_node\_name=Galera\_cluster2

log\_slave\_updates

innodb\_locks\_unsafe\_for\_binlog=1  
innodb\_autoinc\_lock\_mode=2  
innodb\_buffer\_pool\_size=400M  
innodb\_log\_file\_size=64M

root@ubuntu:/etc/mysql# ls -oa /usr/lib/libgalera\_smm.so  
-rw-r–r-- 1 root 2252744 Jan 30 09:31 /usr/lib/libgalera\_smm.so

First start mysql on node1, then node2.

mysql\> show global status like ‘wsrep%’;  
±-------------------------±---------------------+  
| Variable\_name | Value |  
±-------------------------±---------------------+  
| wsrep\_cluster\_conf\_id | 18446744073709551615 |  
| wsrep\_cluster\_size | 0 |  
| wsrep\_cluster\_state\_uuid | |  
| wsrep\_cluster\_status | Disconnected |  
| wsrep\_connected | OFF |  
| wsrep\_local\_index | 18446744073709551615 |  
| wsrep\_provider\_name | |  
| wsrep\_provider\_vendor | |  
| wsrep\_provider\_version | |  
| wsrep\_ready | ON |  
±-------------------------±---------------------+  
10 rows in set (0.00 sec)

Other things I’ve checked:

Firewall: none running  
Conflicting ports: none  
SELinux: disabled

What am I doing wrong? Grateful for the help in advance

---

<div class="post-metadata">

**Author:** ![matrix\_ua](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@matrix\_ua](https://forums.percona.com/u/matrix_ua)\
**Post date:** [March 5, 2013, 9:22am UTC](https://forums.percona.com/t/problem-with-sync/2542/2 "2013-03-05T09:22:41Z")

</div>

PS Found in the logs of mysql row:  
WSREP: wsrep\_load(): loading provider library ‘none’

although libgalera\_smm.so is in place and is registered in the config

---

<div class="post-metadata">

**Author:** ![martin.arrieta](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/martin.arrieta/32/16888_2.png) [@martin.arrieta](https://forums.percona.com/u/martin.arrieta)\
**Post date:** [March 29, 2013, 10:54pm UTC](https://forums.percona.com/t/problem-with-sync/2542/3 "2013-03-29T22:54:20Z")

</div>

Are you still having this issue? could you please send un the full error log?

The “mysql\> show global status like ‘wsrep%’;” was from the node1? if not, could you please send us the output of that command from the node1?

Regards,

Martin