GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Cluster Setup

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cluster Setup

    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
    Last edited by mssatheesh87; 08-07-2013, 05:49 AM. Reason: Fixed
Working...
X