Announcement

Announcement Module
Collapse
No announcement yet.

Error when joining a new node on cluster

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

  • Error when joining a new node on cluster

    Hi,

    I have a cluster with 3 nodes, I'm setting up a 4th node to join the cluster, however need to have the same donor as the nodes number 3 only. Below is my my.cnf configuration and error that returns me to the log of the node 4.

    MY.CNF - Node 4

    [mysqld]

    datadir=/var/lib/mysql
    user=mysql
    tmpdir=/tmp
    server-id = 4

    # Path to Galera library
    wsrep_provider=/usr/lib64/libgalera_smm.so

    # Cluster connection URL contains the IPs of node#1, node#2, node#3 and node#4
    wsrep_cluster_address=gcomm://MYSQL01,MYSQL02,MYSQL03,MYSQL04

    # In order for Galera to work correctly binlog format should be ROW
    binlog_format=ROW

    # MyISAM storage engine has only experimental support
    default_storage_engine=InnoDB

    # This is a recommended tuning variable for performance
    innodb_locks_unsafe_for_binlog=1

    # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
    innodb_autoinc_lock_mode=2

    wsrep_sst_donor=MYSQL03

    # Node #4 address
    wsrep_node_address=MYSQL04

    # SST method
    wsrep_sst_method=xtrabackup

    # Cluster name
    wsrep_cluster_name=RHCLUSTER

    # Authentication for SST method
    wsrep_sst_auth="sstuserass"

    ERROR node 4

    130724 11:46:30 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.51292S), skipping check
    130724 11:47:00 [Note] WSREP: view((empty))
    130724 11:47:00 [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
    130724 11:47:00 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -110 (Connection timed out)
    130724 11:47:00 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1289: Failed to open channel 'RHCLUSTER' at 'gcomm://MYSQL01,MYSQL02,MYSQL03,MYSQL04': -110 (Connection timed out)
    130724 11:47:00 [ERROR] WSREP: gcs connect failed: Connection timed out
    130724 11:47:00 [ERROR] WSREP: wsrep::connect() failed: 6
    130724 11:47:00 [ERROR] Aborting



    Could anyone help me?


    Last edited by fonsecacassio; 07-24-2013, 09:52 AM.

  • #2
    Have you checked network connectivity between those nodes? Basically, at least the TCP ports 4567 (default group comms), 4444 (SST), 4568 (IST) must be open between all nodes.

    Comment

    Working...
    X