Hi,

we did something similar. We did utilize some cassandra code though and wrote a custom commitlog reader that outputs our data into a readable form.

You can look here: http://grepcode.com/file/repo1.maven.org/maven2/org.apache.cassandra/cassandra-all/1.1.9/org/apache/cassandra/db/commitlog/CommitLogReplayer.java

This code is used to replay commitlogs when starting up cassandra. It has the ability to deserialize and transform the data into what you'll need.

-- artur


On 18/03/14 19:32, Han,Meng wrote:

Hi Jonathan,

Thank you for the timely reply. I am doing this experiment on a continuous basis. To be more specific, I will issue a large amount of read and write operations to a particular key in a short time interval. I'd like to know the order that write operations happens at each replica. TImestamps definitely help to determine order, but the WRITETIME and SStable2Json both looks me only return the timestamps when that key was updated the moment the WRITETIME/SStable2Json is issued. It looks like a one time thing to me. Or put in another way, if I want to get the write time for all write operations in that short invertal to determine a total order for write on that replia I have to constantly issue WRITETIME to this replica? Correct me if I am wrong here.

Light me up pleeeeeeeeeease!

On Tue, 18 Mar 2014 15:05:07 -0400, Jonathan Lacefield wrote:

Hello,
Is this a one time investigative item or are you looking to set something up to do this continuously? Don't recommend trying to read the commit log. You can always use the WRITETIME function in CQL or look within SSTables via the SStable2Json utility to see write times for particular versions of partitions.
Jonathan

Jonathan Lacefield
Solutions Architect, DataStax
(404) 822 3487
<http://www.linkedin.com/in/jlacefield>
<http://www.datastax.com/what-we-offer/products-services/training/virtual-training>


On Tue, Mar 18, 2014 at 2:25 PM, Han,Meng <meng...@ufl.edu <mailto:meng...@ufl.edu>> wrote:

    Hi Cassandra hackers!

    I have a question regarding extracting useful information from
    commit log.

    Since its a binary log, how should I extract information such as
    timestamp, values from it? Does anyone know any binary log reader
    that I can use directly to read commit log?
    If there is no such reader, could someone give me some advice hwo
    I can wrote such a reader?

    Particularly, I want to know the order that write operations
    happens at each replica(cassandra server node) along with their
    timestamps, Does anyone know other methods how I can get this
    information without instrumenting Cassandra code?

    Any help is appreciated!

    Cheers,
    Meng


Reply via email to