Skip to main content

remove node out of the cluster

  • March 3, 2016
  • 4 replies
  • 21 views

Peacherr
Forum|alt.badge.img+1

- We have 8 node in the cluster
- Node 6 have problem
- we replace Node 6 with Node9
- Now node 9 up
- Node 6 take standby state

we need to remove node 6 out of the cluster
but it always shows message
" All node need UP "

How can I remove node 6 (standby state) out of the cluster

4 replies

Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • March 3, 2016

 All nodes must be up in order to remove one node. 

 

What is the status of your node 6 , can you stat it up ?

 


Peacherr
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • March 3, 2016

it show node_state is standby it means node 6 not up 

but the cluster show status UP.

 

I found this document guide how to remove. and I try to remove node by using MC instead . it cannot click the button

 

 

 

Remove Unused Hosts From the Database Using MC

 

You remove nodes from a database cluster on MC's Manage page. Click the node you want to act upon, and then click Remove node in the Node List.

Using MC, you can remove only nodes that are part of the database cluster and which show a state of DOWN (red). When you remove a node, its color changes from red to clear and MC updates its state to STANDBY. You can add STANDBY nodes back to the database later.

 

 


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • March 3, 2016

Hi,

 

       Can you try resetting the state of Active Standby node before you remove node out of the cluster. Please find the instructions in the below URL

 

https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/ManageNodes/RevertingaHotStandbyNode.htm%3FTocPath%3DAdministrator's%2520Guide%7CManaging%2520the%2520Database%7CManaging%2520Nodes%7CActive%2520Standby%2520Nodes%7C_____3

 

 

 

Sruthi


Peacherr
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • March 5, 2016

thanks