Tuesday 12 January 2016

Removing Leaf from cluster


All steps to be performed on Master Aggregator

STEP 1
######
memsql-ops memsql-list

STEP 2
######
memsql-ops agent-list

STEP 3
######
show leaves;

STEP 4
######
show partitions on db1;

STEP 5
######
show partitions extended;

STEP 6
######
memsql-ops memsql-unmonitor 4B4FD60
memsql-ops memsql-unmonitor 73E66DE

STEP 7
######
memsql-ops agent-uninstall --force Aa10a01
memsql-ops agent-uninstall --force A36a36a

STEP 8
######
memsql-ops memsql-list
memsql-ops agent-list


STEP 10
######
REMOVE LEAF '172.27.1.218':3306;
REMOVE LEAF '172.27.3.68':3306;
OR
REMOVE LEAF '172.27.1.218':3306 force;
REMOVE LEAF '172.27.3.68':3306 force ;
REBALANCE PARTITIONS ON db1;

STEP 11
######
SHOW LEAVES;
SHOW AGGREGATORS;
show partitions extended;
SHOW CLUSTER STATUS;


No comments:

Post a Comment