How can I remove a node from my galera cluster?

mysql mariadb galera
user5312201 picture user5312201 · Sep 8, 2015 · Viewed 12.6k times · Source

Is there any better way of doing it,apart from setting 'wsrep_cluster_address='gcomm://' for each node that I want to remove?

Answer

fred picture fred · Mar 30, 2016

I just did this. Seems to have worked. On the node you want to evict

Try

>show global status like 'wsrep%';

Copy paste the wsrep_gcomm_uuid

Go to another node and evict from there assuming the UUID = 1de97dad-f609-11e5-8a50-ce2e621b0c42

SET GLOBAL wsrep_provider_options="evs.evict=1de97dad-f609-11e5-8a50-ce2e621b0c42";

If the node is already shut down or non-responsive you can get the UUID from any other node from wsrep_evs_delayed

Related questions

Failed to bootstrap Galera Cluster

I'm trying to set up multi-master replication between two servers according to this tutorial: http://tecadmin.net/setup-mariadb-galera-cluster-5-5-in-centos-rhel/ My /etc/my.cnf.d/server.cnf on 1st server: [mariadb] query_cache_size=0 binlog_format=ROW default_storage_engine=…

Read More
MariaDB Galera Cluster set up problems

I am trying to get a mariadb cluster up and running but it is not working out for me. Right now I am using MariaDB Galera 5.5.36 on a 64 bit red hat ES6 machine. I installed mariadb through this repo here: […

Read More
Galera_new_cluster command not starting a cluster

Following documentation on how to set up a MariaDB Galera cluster, I simply created the proper config files and started my primary db server with the galera_new_cluster command (I'm running RHEL7). According to the documentation, at that point …

Read More