Saturday, May 12, 2012

Cassandra Explorer - GUI for Cassandra

Please go to following url for the newest version.
http://blog.shelan.org/2012/06/cassandra-gui-20-making-things-little.html


WSO2 products can manage a Cassandra Cluster using Cassandra feature.[1]  (No need to follow the instructions to setup cassandra I have added a pre installed version [2])
If you have a Cassandra cluster i am sure you have the problem of viewing the data instantly. Cassandra CLI is one of the tools but it would be easier if it has a nice UI and would more convenient for administrators. Cassandra Explore has been developed to make the things easier for Cassandra users.

Download the Cassandra Feature pre installed WSO2 Carbon Server. [2] . (Until we officially release Cassandra Explorer with Cassandra feature lets use this.)

Extract the downloaded product and lets refer extracted folder as CARBON_HOME.

You have two different options with Cassandra feature.

1. Use internal Cassandra Server .

In this it will start internal Cassandra Server and you can use it to store data.

2. User External Cassandra Cluster.

This option if you already have setup your Cassandra Cluster and you need to view data. You need to
add your Cassandra Clusters details in CARBON_HOME/repository/conf/etc/cassandra-component.xml

Starting Carbon Server

1) If you need to use internal server. go to CARBON_HOME/bin and run sh wso2server.sh (linux) or
wso2server.bat

 If you need to connect to an external cassandra cluster you need to run same wso2server.sh with following parameter

sh wso2server.sh -Ddisable.cassandra.server.startup=true

and log in with default username and password (admin, admin)

List Key Spaces.

Click Cassandra Keyspaces ---> List to list down keyspaces.




Select a Key Space

Select a keyspace from available keyspaces.


Select a Column Family to Explore Data.

Click on Explore icon to view data in a Column Family.


View Data on Column Family.

This will display rows and columns in the Column Family. In a Row you can paginate through Columns. If you need to retrieve a key quickly enter your row ID and click explore row.



View data on a Row

Click on a row link to view data.

You can search  a Name or Value through search Box and will update the results as you type.


[1] http://wso2.org/library/knowledge-base/2012/04/deploy-cassandra-feature-wso2-carbon-product

[2] https://www.dropbox.com/s/m00uodj1ymkpdzb/wso2carbon-4.0.0-SNAPSHOT.zip

12 comments:

  1. Hi !

    I'm very interested by your tool but I can't figure out to make it work.

    I'm trying to connect to a remote server.
    I've changed values in cassandra-component.xml and cassandra-endpoint.xml in repository/conf/etc but it seems that it always tries to connect to localhost.
    Is there something else to do ? An other file to edit ?

    Here is the logs :

    [2012-06-05 18:06:40,447] INFO {me.prettyprint.cassandra.connection.CassandraHostRetryService} - Not checking that localhost(127.0.0.1):9160 is a member of the ring since there are no live hosts
    [2012-06-05 18:06:40,448] WARN {me.prettyprint.cassandra.connection.CassandraHostRetryService} - Downed localhost(127.0.0.1):9160 host still appears to be down: Unable to open transport to localhost(127.0.0.1):9160 , java.net.ConnectException: Connection refused
    [2012-06-05 18:06:40,448] INFO {me.prettyprint.cassandra.connection.CassandraHostRetryService} - Downed Host retry status false with host: localhost(127.0.0.1):9160

    Thanks for your help !

    ReplyDelete
    Replies
    1. Hi Clement,

      Thanks for the feedback.Yes I found that there were some problems when connecting to a remote server.This was initially developed to browse the in built Cassandra Server (Did some rapid changes to make this available to all the Cassandra Users). This is being actively developed so we are planning to release a new version in coming weeks which will address all those remote connection issues.In that you can switch to any new Cassandra Server without restarting and all the configurations can be done through UI.

      Delete
    2. Hi,

      so I'll wait for the next release !
      Thanks for your quick answer.

      Delete
    3. Hi,
      You can try the new version here.
      http://blog.shelan.org/2012/06/cassandra-gui-20-making-things-little.html

      thnks

      Delete
  2. Hi, I download and install BAM 2.4.1, and it cannot browse the data, even I can see the keyspace, column family, etc...
    The screenshot (in diagram 3/5) doesn't have "Explore" and "Share". Any idea?

    ReplyDelete
  3. This website of yours is really helpful it provided us with massive valuable information to work on there are many impressive post that you have done in this site which we found it as treasure in details please keep his excellent and delight job in further updates thank you very much indeed
    Data Entry Services

    ReplyDelete
  4. Java is a promient programming language in the current IT industry and the advanced level of Java courses are wanted by most of the professional. Your blog help me to observe some important points in Java language.

    Regards:

    J2EE Training in Chennai | Java Courses in Chennai

    ReplyDelete
  5. Your post is really awesome. Your blog is really helpful for me to develop my skills in a right way. Thanks for sharing this unique information with us.
    - Learn Digital Academy

    ReplyDelete
  6. BD JSC Result 2019 Publish Date Will Announce Soon. The Junior School Certificate Exam 2019 Start From 2nd November and Exam Complete 15th November 2019. The Written Exam Was Complete First and Then The Practical Exam Has begun.

    ReplyDelete
  7. You came here to know how to get SSC Result 2020 With full Marksheet. Wellcome to Lekhapora and the post SSC Result 2020. Here you are going to get some information like: About SSC Result 2020, SSC Result Online, SSC Result SMS, SSC Exam Result, SSC Result with Marksheet. Moreover, you are going to know about SSC Madrasha Board Result 2020.

    SSC Result By EIIN Number: EIIN refers to Educational Institute Identification Number. Every school and college has its own EIIN Number. One can get all the information and JSC, SSC & HSC Result by this EIIN Number. If anyone wants to all the SSC results of any school then he/she can try the SSC Result EIIN Method.

    Now you think to do a Board challenge for your SSC result. If yes, then you are in the right place. Let’s read the “How to apply for SSC result board challenge and rescutiny section” and follow the steps.

    Looking for SSC Result Dinajpur board 2020, SSC Result 2020 Publish Date by Dinajpur Board, Dinajpur Board SSC result by Message, SSC Result Dinajpur Board 2020 Check Online and Android Mobile Apps then you are the right place. Here you will get the Dinajpur board result.

    SSC Result Comilla Board 2020 – If you searching for Comilla Board 2020. SSC Result then this post may help for you where we will tell how to Check SSC results of Comilla board 2020 and also will discuss how to download the SSC mark sheet.

    If you are SSC examinee of Dhaka Board and looking for SSC result of Dhaka board then you are in the perfect place. In this article, we will try to cover all the possible way to get SSC result Dhaka board 2020. Read the content carefully to know how to get SSC result Dhaka board.

    SSC Result 2020 Rajshahi Board will Publish under the Bangladesh Education Board of Rajshahi Computer Center. The SSC Results Rajshahi Board and Result related all data will available on here. And also on the Board of Intermediate and Secondary, Rajshahi.

    Barisal Board SSC results 2020 will be published here. I discuss all about the results and the board. Barisal Board is the authority of secondary and higher secondary educational institutions in Barisal. It controls them following rules and regulation of Education Board of Bangladesh.

    ReplyDelete
  8. Jessore Board SSC Result 2020 will be published very soon. SSC Exam means Secondary School Certificate Examination. It is also a public examination which has taken by students of Secondary Schools in Bangladesh. There are eight general educations Board in Bangladesh.

    But unfortunately, most of the Muslim children go to general education from their childhood instated of Madrasah education. So, Details of Dakhil Result 2020 is shared below.

    Yes, it is the right place to know Chittagong Board SSC result 2020. Every year the Education Board of Bangladesh conducts the exam of SSC at the month of February to March and the exam result has to publish in every month of May.

    SSC Result BD is near to the door. It is very important for the students of SSC Exam, Dakhil Exam, and Vocational Examination in 2020. SSC stands for Secondary School Certificate which is the most significant for every student. Though it is the third board exam of a student it still has the most significant on a student’s life. Before the 2013 SSC Exam was the first board exam on a student’s life.

    SSC Result Sylhet Board 2020 will be published very soon. SSC Exam means Secondary School Certificate Examination. It is also a public examination which has taken by students of Secondary Schools in Bangladesh.

    Looking for SSC Result Mymensing board 2020, SSC Result 2020 Publish Date by Mymensing Board, Mymensing Board SSC result by Message, SSC Result Mymensing Board 2020 Check Online and Android Mobile Apps then you are the right place.

    Are you fond of Mobile and want to get your SSC Result by SMS? Do you want to know how to get SSC Exam Result by Mobile SMS? Here you can know the details.

    Are you are student of technical Education board and looking for Bangladesh Technical Boaord SSC Result 2020? Here you can find your desired information about SSC Exam Result.

    SSC Result is significant for who sat for the SSC or Dakhil or Vocational Examination in the year of 2020. In our counry Bangladesh, SSC or Secondary School Certificate examination is hard for a Secondary level students.

    ReplyDelete