Cannot join the New Cluster

Comments

3 comments

  • Avatar
    Ashraf Sharif

    Hi,

    This line tells us that there is no node in the cluster now is in primary state:

    [Warning] WSREP: no nodes coming from prim view, prim not possible

    On node1, what is the output of:

    mysql> SHOW STATUS LIKE 'wsrep%';

    Node2 was trying to establish communication with the primary component, however it failed. Probably because node1 was not in PRIMARY state, which you can verify by looking at the wsrep_cluster_status from the statement above. Did you look for any clue inside node1's MySQL error log?

    Regards,
    Ashraf

  • Avatar
    testjetco

    I got the solution.  iptable blocks the port 4567 traffic.  I added the following entries into /etc/sysconfig/iptables and made it work:

            -A INPUT -m state --state NEW -m tcp -p tcp --dport 4567 -j ACCEPT
            -A INPUT -m state --state NEW -m tcp -p tcp --dport 4444 -j ACCEPT

    Port 4567 is for gcomm while port 4444 is for rsync. 

    Any other ports I need to allow normal operation of MariaDB and Galera clustering?

  • Avatar
    Ashraf Sharif

    Hi,

    That was my hunch but I didn't think about that because I thought you had disabled firewall completely since you said "Node 1 and 2 firewalld - disabled".

    Anyway, we have listed out the necessary ports for Galera in our documentation page: https://severalnines.com/docs/requirements.html#firewall-and-security-groups 

    Regards,
    Ashraf

Please sign in to leave a comment.

Powered by Zendesk