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

New cluster install, first cluster node doesn't show as

deejbeedeejbee EntrantInactive User Role Beginner
I've been trying to install Percona onto a 3 node cluster. I cant' even get the first node to show up a cluster size of 1:


mysql> show status like 'wsrep%';
+--------------------------+----------------------+
| Variable_name            | Value                |
+--------------------------+----------------------+
| wsrep_cluster_conf_id    | 18446744073709551615 |
| wsrep_cluster_size       | 0                    |
| wsrep_cluster_state_uuid |                      |
| wsrep_cluster_status     | Disconnected         |
| wsrep_connected          | OFF                  |
| wsrep_local_bf_aborts    | 0                    |
| wsrep_local_index        | 18446744073709551615 |
| wsrep_provider_name      |                      |
| wsrep_provider_vendor    |                      |
| wsrep_provider_version   |                      |
| wsrep_ready              | ON                   |
+--------------------------+----------------------+
11 rows in set (0.00 sec)


running:
sudo /etc/init.d/mysql bootstrap-pxc

produces this:
[ ok ] Bootstrapping Percona XtraDB Cluster database server: mysqld already running.

So I have no idea why the cluster size is not 1.

Comments

  • Kenn TakaraKenn Takara Percona Percona Staff Role
    Hi,

    There are blank entries for 'wsrep_provider_name', 'wsrep_provider_vendor', etc... It doesn't look like galera was loaded correctly,

    You can check the logs for lines like:
    2017-07-27 08:36:41 120457 [Note] WSREP: wsrep_load(): loading provider library '/path/to/libgalera_smm.so'
    2017-07-27 08:36:41 120457 [Note] WSREP: wsrep_load(): Galera 3.21(r8678538) by Codership Oy <[email protected]> loaded successfully

    to see if it was loaded successfully. If the library is not found, the node will start up as a normal Percona Server node.
  • deejbeedeejbee Entrant Inactive User Role Beginner
    Where do I find the logs?

    I just installed this using the installation guide on your web site (sudo apt-get install percona-xtradb-cluster-56)

    I tried removing it entirely using:
  • przemekprzemek Percona Support Engineer Percona Staff Role
    First of all, check your configuration files. You need some wsrep* settings to get the cluster going.
    Check the documentation:
    https://www.percona.com/doc/percona-xtradb-cluster/LATEST/configure.html
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.