Not the answer you need?
Register and ask your own question!

Percona XtraDB Cluster 8.0 - cluster size as 1 at node 2 and 3

AneeshBabuAneeshBabu Current User Role Supporter
edited October 23 in Percona XtraDB Cluster 8.x

Hi there....

when the checked the cluster size showing as below at node 2 and node 3, what could be the problem..?

Attaching the config file of 3 nodes.


Node -2

[email protected] > show status like '%cluster_size%';

+--------------------+-------+

| Variable_name     | Value |

+--------------------+-------+

| wsrep_cluster_size | 1    |

+--------------------+-------+

1 row in set (0.00 sec)


Node -3

[email protected] > show status like '%cluster_size%';

+--------------------+-------+

| Variable_name     | Value |

+--------------------+-------+

| wsrep_cluster_size | 1    |

+--------------------+-------+

1 row in set (0.00 sec)



Below is the status when issued the clustercheck command.

[email protected]:~# clustercheck

HTTP/1.1 503 Service Unavailable

Content-Type: text/plain

Connection: close

Content-Length:

Percona XtraDB Cluster Node is not synced or non-PRIM.

Tagged:

Answers

  • vadimtkvadimtk Contributor Percona Staff Role

    In your configs you should have

    wsrep_cluster_address = gcomm://192.168.0.1,192.168.0.2,192.168.0.3

    on ALL your nodes, not only on Node 1

  • AneeshBabuAneeshBabu Current User Role Supporter

    Hi @vadimtk

    added the wsrep_cluster_address = gcomm://192.168.0.1,192.168.0.2,192.168.0.3 in all the nodes 1,2,3.

    After bootstrapped the first node ,Started the mysql service at node 2 ,facing the below error.

    Attaching the error log file for your reference.


    Note : I have changed the variable from ON to pxc-encrypt-cluster-traffic=OFF in all the config files.



    [email protected]:~# service mysql start

    Job for mysql.service failed because the control process exited with error code.

    See "systemctl status mysql.service" and "journalctl -xe" for details.


    [email protected]:~# systemctl status mysql.service

    ● mysql.service - Percona XtraDB Cluster

      Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)

      Active: failed (Result: exit-code) since Fri 2020-10-23 17:54:16 UTC; 1min 21s ago

     Process: 6245 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)

     Process: 3748 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=0/SUCCESS)

     Process: 2375 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=0/SUCCESS)

     Process: 2373 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

     Process: 6240 ExecStart=/usr/sbin/mysqld $_WSREP_START_POSITION (code=exited, status=1/FAILURE)

     Process: 6192 ExecStartPre=/bin/sh -c VAR=`bash /usr/bin/mysql-systemd galera-recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, s

     Process: 6186 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

     Process: 6155 ExecStartPre=/usr/bin/mysql-systemd check-grastate (code=exited, status=0/SUCCESS)

     Process: 6106 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)

     Main PID: 6240 (code=exited, status=1/FAILURE)

      Status: "Server startup in progress"

    Oct 23 17:53:43 pxc-2 systemd[1]: Starting Percona XtraDB Cluster...

    Oct 23 17:54:16 pxc-2 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

    Oct 23 17:54:16 pxc-2 mysql-systemd[6245]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable

    Oct 23 17:54:16 pxc-2 mysql-systemd[6245]: WARNING: mysql may be already dead

    Oct 23 17:54:16 pxc-2 systemd[1]: mysql.service: Failed with result 'exit-code'.

    Oct 23 17:54:16 pxc-2 systemd[1]: Failed to start Percona XtraDB Cluster.

    lines 1-21/21 (END)

    [8]+ Stopped                systemctl status mysql.service

  • AneeshBabuAneeshBabu Current User Role Supporter

    Hi there ..

    Can anyone look in to this issue ..?

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.