Cassandra is an eventual consistent DB, how to find when a row is actually
written in multi DC environment? Here is the problem I am trying to solve
- I have multi DC (3 DC's) Cassandra cluster/ring - One of the application
wrote a row to DC1(using Local Quorum) and within span of 50 ms, it tried to
read same row from DC2 and could not find the row. Our both DC's have sub milli
second latency at network level, usually <2 ms. We promised 20 ms consistency.
In this case Application could not find the row in DC2 in 50 ms
I tried to use "selectWRITETIME(authorizations_json) from token_authorizations
where ...." to find when the Row is written in each DC, but both DC's returned
same Timestamp. After further research I found that Client V3 onwards Timestamp
is supplied at Client level so WRITETIME does not help
So how to determine when the row is actually written in each DC?