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

Removing a node

ac1dr41nac1dr41n EntrantInactive User Role Beginner
Amazingly enough I can't find information about how to do this. I have an 8 node cluster in a test environment. I want to eliminate 4 nodes from it. I figured I would just shut down 4 of them and be on my way. but the other four just keep spitting out errors into the error file trying to reconnect with those other four.

How do you cleanly remove a node from the cluster? I can't find any documentation or commands about how to do it?

Comments

  • karilehkarileh Entrant Current User Role Beginner
    What does your wsrep_cluster_address -attribute look like in my.cnf of remaining nodes ? Is it possible that in remaining nodes are pointing to eliminated nodes ? Also you can check that wsrep attributes are identical in all nodes with show status like 'wsrep%';
  • ac1dr41nac1dr41n Entrant Inactive User Role Beginner
    No, the one node that was eliminated was not the originating "master". And yes, all the wsrep attributes are the same across all other nodes.
  • shriramrbkshriramrbk Entrant Current User Role Beginner
    Is there any way to do it without changing the `wsrep_cluster_address` value in my.cnf (as this would require MySQL server restart) ?
  • przemekprzemek Percona Support Engineer Percona Staff Role
    If you had 8 nodes and "eliminated 4 nodes", means it was not a clean service shutdown of those, remaining nodes detected split brain situation and therefore stopped working waiting for missing nodes to reconnect. Please read about Quorum in Galera.
    Solution - stop the nodes with correct service stop command, ideally one by one.
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.