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

Wrong data in file when ran service mysql bootstrap=pxc

joannejoanne EntrantInactive User Role Beginner
I had the wrong data in file when ran, should have been empty for node1. How to do I re-issue for node1 on same server?
# clustercheck

HTTP/1.1 503 Service Unavailable
Content-Type: text/plain
Connection: close
Content-Length: 57

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

This server should be node1.

Comments

  • joannejoanne Entrant Inactive User Role Beginner
    Anyone?


    I ran this:




    mysql -e "show global 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 |
    +
    +
    +

    in my.cnf: wsrep_cluster_address=gcomm://
  • joannejoanne Entrant Inactive User Role Beginner
    I backed out some of the changes in my.cnf to contain just the bare min settings (just percona), and nodes now look like they are up.

    Should Node 1 now contain all the server addresses in wsrep_cluster_address? When I tried server failed to come up.
  • maganmagan Entrant Current User Role Beginner
    How many nodes are you using ? you need to post the content of configuration file ( my.cnf ) so that people can see what is wrong with your work.
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.