Page 2 of 2
Re: Remove node from cluster
Posted: Thu Mar 21, 2013 1:49 pm
by id10t
Hi Julie!
>> Where did you read this?
Pure logic:
1. 3 nodes cluster is a problematic from point of view of HA (cluster in critical state when node down)
2. Data isn't segmented when one node down in cluster of 3 nodes, only replicated. So you loosing a lot in MPP and it means performance.
Re: Remove node from cluster
Posted: Thu Mar 21, 2013 2:59 pm
by Julie
Thanks, sKwa. So if one node goes down the database is in a critical state because if another node goes down the cluster will fail, right? So I should add another node when we get the $$$
Re: Remove node from cluster
Posted: Thu Mar 21, 2013 11:10 pm
by id10t
Hi!
>> So if one node goes down the database is in a critical state because if another node goes down the cluster will fail, right?
Exactly.
To get a full advantage from HA its better to have 4 nodes.
FIX: (one fail in my "pure logic" )
What happens in two nodes?
If data segmented + K-Safety1 so each segment have to be on both nodes, but it's nothing else as a replication!
So you can't have data and segmented and KSafety 1 ==> KSafety = 0 ==> one more node down and good bay database!
And i believe it's a lot of a manual work to remove a node in cluster 3 nodes. Its change all schema.
PS
All this - "IMHO", Im not expert
Wait for Sharon - she knows everything