CODEWITHSUNDEEP
mysqlmariadbgalera
user5312201
user5312201

Reputation:

How can I remove a node from my galera cluster?

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

Upvotes: 5

Views: 18013

Answers (2)

fred
fred

Reputation: 1303

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

Upvotes: 8

Rick James
Rick James

Reputation: 142296

I see two choices here:

http://www.severalnines.com/blog/online-schema-upgrade-mysql-galera-cluster-using-rsu-method

(You aren't doing RSU, but that involves "removing a node".)

Upvotes: 1

Related Questions