I have two Datacenter, dc1 and dc2 on Openstack, each datacenter have 3 nodes. use the first node of both datacenter as seeds node.
keyspace "userElement" setting is 'NetworkTopologyStrategy', 'dc1' : 3, 'dc2' : 3};
My application use LOCAL_QUORUM to write data to "user" table inside "userElement" keyspace. normally, the replication working fine, all data write into dc1 will replicate to dc2. But sometimes, one of the records missing on dc2. For instance when I check record count(*).
cassandra@cqlsh> select count(*) from user.userElement; count ------- 16
cassandra@cqlsh> select count(*) from user.userElement; count ------- 15
How could I check or any log could show what happened?