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