# Cluster Setup

**URL:** <https://forums.percona.com/t/cluster-setup/2865>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [August 7, 2013, 2:51am UTC](https://forums.percona.com/t/cluster-setup/2865 "2013-08-07T02:51:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mssatheesh87](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mssatheesh87/32/944_2.png) [@mssatheesh87](https://forums.percona.com/u/mssatheesh87)\
**Post date:** [August 7, 2013, 2:51am UTC](https://forums.percona.com/t/cluster-setup/2865/1 "2013-08-07T02:51:55Z")

</div>

Hi Team,

I have test the setup of percona cluster for our environment

i have 3 servers

i have setup percona in all machines

My configuration was

[mysqld]

datadir=/var/lib/mysql  
user=mysql

skip-name-resolve

## Galera

wsrep\_provider = /usr/lib64/libgalera\_smm.so  
wsrep\_cluster\_address = gcomm://10.136.2.216,10.137.60.145,10.151.87.70  
wsrep\_slave\_threads = 2  
wsrep\_cluster\_name = mysqldb  
wsrep\_sst\_method = rsync  
wsrep\_node\_name = mysqlcheck1  
binlog\_format = ROW  
innodb\_locks\_unsafe\_for\_binlog = 1  
innodb\_autoinc\_lock\_mode = 2  
wsrep\_node\_address = 10.136.2.216  
wsrep\_sst\_receive\_address = 10.136.2.216

## I am getting the following error:

130807 04:01:37 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
130807 04:01:37 mysqld\_safe Skipping wsrep-recover for empty datadir: /var/lib/mysql  
130807 04:01:37 mysqld\_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep\_start\_position  
130807 4:01:37 [Note] WSREP: wsrep\_start\_position var submitted: ‘00000000-0000-0000-0000-000000000000:-1’  
130807 4:01:37 [Note] WSREP: Read nil XID from storage engines, skipping position init  
130807 4:01:37 [Note] WSREP: wsrep\_load(): loading provider library ‘/usr/lib64/libgalera\_smm.so’  
130807 4:01:37 [Note] WSREP: wsrep\_load(): Galera 2.6(r152) by Codership Oy \<info@codership.com\> loaded succesfully.  
130807 4:01:37 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat  
130807 4:01:37 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1  
130807 4:01:37 [Note] WSREP: Reusing existing ‘/var/lib/mysql//galera.cache’.  
130807 4:01:37 [Note] WSREP: Passing config to GCS: base\_host = 10.136.2.216; base\_port = 4567; cert.log\_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep\_pages\_size = 0; gcache.mem\_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page\_size = 128M; gcache.size = 128M; gcs.fc\_debug = 0; gcs.fc\_factor = 1; gcs.fc\_limit = 16; gcs.fc\_master\_slave = NO; gcs.max\_packet\_size = 64500; gcs.max\_throttle = 0.25; gcs.recv\_q\_hard\_limit = 9223372036854775807; gcs.recv\_q\_soft\_limit = 0.25; gcs.sync\_donor = NO; replicator.causal\_read\_timeout = PT30S; replicator.commit\_order = 3  
130807 4:01:37 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1  
130807 4:01:37 [Note] WSREP: wsrep\_sst\_grab()  
130807 4:01:37 [Note] WSREP: Start replication  
130807 4:01:37 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1  
130807 4:01:37 [Note] WSREP: protonet asio version 0  
130807 4:01:37 [Note] WSREP: backend: asio  
130807 4:01:37 [Note] WSREP: GMCast version 0  
130807 4:01:37 [Note] WSREP: (959c823d-ff37-11e2-ba67-8bbc8eaa1898, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567  
130807 4:01:37 [Note] WSREP: (959c823d-ff37-11e2-ba67-8bbc8eaa1898, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1  
130807 4:01:37 [Note] WSREP: EVS version 0  
130807 4:01:37 [Note] WSREP: PC version 0  
130807 4:01:37 [Note] WSREP: gcomm: connecting to group ‘mysqldb’, peer ‘10.136.2.216:,10.137.60.145:,10.151.87.70:’  
130807 4:01:37 [Warning] WSREP: (959c823d-ff37-11e2-ba67-8bbc8eaa1898, ‘tcp://0.0.0.0:4567’) address ‘tcp://10.136.2.216:4567’ points to own listening address, blacklisting  
130807 4:01:40 [Warning] WSREP: no nodes coming from prim view, prim not possible  
130807 4:01:40 [Note] WSREP: view(view\_id(NON\_PRIM,959c823d-ff37-11e2-ba67-8bbc8eaa1898,1) memb {  
959c823d-ff37-11e2-ba67-8bbc8eaa1898,  
} joined {  
} left {  
} partitioned {  
})  
130807 4:01:40 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50551S), skipping check  
130807 4:02:10 [Note] WSREP: view((empty))  
130807 4:02:10 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)  
at gcomm/src/pc.cpp:connect():139  
130807 4:02:10 [ERROR] WSREP: gcs/src/gcs\_core.c:gcs\_core\_open():195: Failed to open backend connection: -110 (Connection timed out)  
130807 4:02:10 [ERROR] WSREP: gcs/src/gcs.c:gcs\_open():1289: Failed to open channel ‘mysqldb’ at ‘gcomm://10.136.2.216,10.137.60.145,10.151.87.70’: -110 (Connection timed out)  
130807 4:02:10 [ERROR] WSREP: gcs connect failed: Connection timed out  
130807 4:02:10 [ERROR] WSREP: wsrep::connect() failed: 6  
130807 4:02:10 [ERROR] Aborting

130807 4:02:10 [Note] WSREP: Service disconnected.  
130807 4:02:11 [Note] WSREP: Some threads may fail to exit.  
130807 4:02:11 [Note] /usr/sbin/mysqld: Shutdown complete

130807 04:02:11 mysqld\_safe mysqld from pid file /var/lib/mysql/mysqlcheck1.pid ended

Kindly help me out
