Hello!
I have set a cassandra cluster with two nodes, Node A and Node B --> RF=2,
Read CL=1 and Write CL = 1;
Node A is seed...
At first everything is working well, when I add/delete/update entries on Node
A, everything is replicated on Node B and vice-versa, even if I shut down node
A, and I made new insertions on Node B meanwhile, and After that I start up
node A again Cassandra recovers OK....BUT there is ONE case when this situation
fails.... I am going to describe the process:
Node A and Node B are sync.
Select Count (*) From MYTABLE;---> 10 rows
Shut down Node A.
Made some inserts on Node B.
Select Count (*) From MYTABLE;---> 15 rows
Shut down Node B.
Start Up Node B.
Select Count (*) From MYTABLE;---> 15 rows
(Everything Ok, yet).
Start Up Node A.
Select Count (*) From MYTABLE;---> 10 rows (uhmmm...this is weird...check it
again)Select Count (*) From MYTABLE;---> 15 rows (wow!..this is correct, lets
try again)Select Count (*) From MYTABLE;---> 10 rows (Ok...values are dancing)
If I made the same queries on NODE B it Behaves the same way.... and it only is
solved with a nodetool repair...but I would prefer an automatic fail-over...
is there any way to avoid this??? or a nodetool repair execution is mandatory???
Thanks in advance!!!
