Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-12054

Add CQL Data Modeler to tree

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Normal
    • Resolution: Unresolved
    • None
    • Legacy/CQL
    • None

    Description

      cassandra-stess, like many powerful tools, is not easy to use. It requires some statistical understanding and syntactic skill, in order to get up and running with even a simple data model, user profile driven test (for details see the cassandra-stress docs). Furthermore, designing a good cassandra data model requires basic understanding of how CQL works and how c* data is laid out on disk as a result of partitioning and clustering.

      The CQL DataModeler aims to simplify this task, getting users up and running with user profile powered cassandra-stress tests in minutes.

      Given the feedback the community has voiced about the usability of cassandra-stress at NGCC, it was suggested that I contribute the data modeler to the open source project so it can be maintained in tree and leveraged by users.

      It is a simple static web application and users should be able to use it by just opening up index.html with their browser and populating the GUI.

      Check it out here:
      http://www.sestevez.com/sestevez/CassandraDataModeler/

      The source code sits in github, once we clean it up and know where it will live in tree, I'll submit a c* patch:
      https://github.com/phact/CassandraDataModeler

      I have developed this as a side project and not as production ready code. I welcome feedback on how it can be cleaned up and improved.

      cc: tjakecarlyeks

      Future improvements include:
      1) Add cluster distributions (currently only size and population are supported)
      2) Add functionality so that the histograms display overall distributions (combining cluster and population distributions for fields)
      3) Include batch configuration and insert distribution
      4) Include -pop and other command line options that are crucial for describing workloads
      5) Add sparse table capabilities (already in stress but currently undocumented)
      6) Add a few example data models to ship with the tool
      7) Eventually allow users to contribute back profiles to some sort of community

      IMO this jira should be contingent on 1, 3, 4, and 6 being completed.

      Attachments

        Activity

          People

            Unassigned Unassigned
            estevezsebastian@gmail.com Sebastian Estevez
            Votes:
            5 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated: