GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Problem in setting up XtraDB Cluster

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

  • Problem in setting up XtraDB Cluster

    130407 23:39:17 [Note] WSREP: wsrep_load(): Galera 2.3(r143) by Codership Oy loaded succesfully.
    sh: /sbin/ifconfig: Permission denied
    130407 23:39:17 [ERROR] WSREP: Failed to read output of: '/sbin/ifconfig | grep -E '^[[:space:]]+inet addr:' | grep -m1 -v 'inet addr:127' | sed 's/:/ /' | awk '{ print $3 }''
    130407 23:39:17 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
    130407 23:39:17 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
    130407 23:39:17 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
    130407 23:39:17 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'.
    130407 23:39:17 [Note] WSREP: Passing config to GCS: 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
    130407 23:39:17 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
    130407 23:39:17 [Note] WSREP: Start replication
    130407 23:39:17 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
    130407 23:39:17 [Note] WSREP: protonet asio version 0
    130407 23:39:17 [Note] WSREP: backend: asio
    130407 23:39:17 [Note] WSREP: GMCast version 0
    130407 23:39:17 [Note] WSREP: (3798a74e-9fc3-11e2-0800-61d933c11383, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
    130407 23:39:17 [Note] WSREP: (3798a74e-9fc3-11e2-0800-61d933c11383, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
    130407 23:39:17 [Note] WSREP: EVS version 0
    130407 23:39:17 [Note] WSREP: PC version 0
    130407 23:39:17 [Note] WSREP: gcomm: connecting to group 'cluster', peer '0.0.0.0:'
    130407 23:39:17 [ERROR] WSREP: Permission denied
    130407 23:39:17 [ERROR] WSREP: failed to open gcomm backend connection: 13: error while trying to listen 'tcp://0.0.0.0:4567?socket.non_blocking=1', asio error 'Permission denied': 13 (Permission denied)
    at gcomm/src/asio_tcp.cpp:listen():808
    130407 23:39:17 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -13 (Permission denied)
    130407 23:39:17 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1290: Failed to open channel 'cluster' at 'gcomm://0.0.0.0': -13 (Permission denied)
    130407 23:39:17 [ERROR] WSREP: gcs connect failed: Permission denied
    130407 23:39:17 [ERROR] WSREP: wsrep::connect() failed: 6
    130407 23:39:17 [ERROR] Aborting

    Mycnf related section is as follow:
    # galera related options
    wsrep_provider=/usr/lib64/libgalera_smm.so
    wsrep_cluster_name="cluster"
    wsrep_cluster_address="gcomm://0.0.0.0"
    wsrep_sst_auth=root:rootpwd
    wsrep_certify_nonPK=1
    wsrep_convert_LOCK_to_trx=0
    wsrep_auto_increment_control=1
    wsrep_drupal_282555_workaround=0
    wsrep_causal_reads=0
    wsrep_sst_method= XtraBackup

  • #2
    Hello,

    To create the cluster, you have to use wsrep_cluster_address="gcomm://" instead gcomm://0.0.0.0 ..

    And if you want to connect to an exiting cluster, you have to use the ip address there (0.0.0.0 is not the bind address)

    Martin

    @martinarrietac

    Comment


    • #3
      Thanks.
      I manage to start the cluster

      Comment

      Working...
      X