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

Failing to connect 2nd node

shailanshailan EntrantInactive User Role Beginner
I'm trying to bring up a xtradb cluster of 2 nodes running on two separate Ubuntu 12.04 servers, I was able to install Percona on the 1st node and get the service to start, however, when I try to start the service for the 2nd node, the service always fails to start.

In the below error.log file for the joiner, I'm going some error's which I can't figure out how to solve. I can see that the joiner node (dg-mysql02 does know about the other node in the cluster, dg-mysql01, but it seems like there is an issue when they try to sync.

Any help is appreciated.

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    Can you paste innobackupex.*.log files from joiner and donor? We might be able to find some clues on what happened here.

    What is the value for wsrep_sst_method?
  • DBennettDBennett Percona Director of DS Inactive User Role
    Hi shailan,

    Check the value of wsrep_sst_auth on the joiner node and make sure this account exists with the correct permissions on your donor before starting the first joiner. If you are starting a fresh cluster, you may have forgotten to set the wsrep_sst_auth account password.

    --Dave
  • Ron_JohnsonRon_Johnson Contributor Current User Role Beginner
    Can you paste innobackupex.*.log files from joiner and donor?

    I'm having the same problem, but don't (seem to) have any innobackupex.*.log files on either the joiner or donor.
    What is the value for wsrep_sst_method?

    xtrabackup-v2
    Check the value of wsrep_sst_auth on the joiner node and make sure this account exists with the correct permissions on your donor before starting the first joiner.

    On the joiner, there are db users "[email protected]" and "[email protected]" (which is the provider node). Is this correct?
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.