Shelan's Blog: cassandra

Monday, June 18, 2012

Cassandra GUI 2.0 - Making things a little bit easier

Update (2014 October 31st)

You can download WSO2 Storage server 1.1.0 which ships Cassandra explorer and many interesting tools to manage storages. Please follow the following links for documentation to use Cassandra Explorer.

Download the product
https://docs.wso2.com/display/SS110/Downloading+the+Product

Extract the binary and run the product. (See "Starting the server" after extracting )
https://docs.wso2.com/display/SS110/Running+the+Product

Documentation about Explorer
https://docs.wso2.com/display/SS110/Explore+Cassandra+Cluster

========================================================================

Cassandra GUI evolved from its first version and new version includes bug fixes and enhanced features.

New features.

Complete pagination for Row view of explorer
Search rows by their names. (Filtered on the fly as you type.)
Filtering non displayable data and label them with warnings.

Bug Fixes

Remote connection problem
Connect to Remote Cassandra server without restarting the server.

Start the Server

You can download the server here.

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

go to CARBON_HOME/bin and run sh wso2server.sh (linux) or
wso2server.bat

default user name and password : admin, admin

Following screen shots include a quick flow on how it works.

1) Click connect to cluster on right hand side panel. Give connection URL and credentials (if there is any) to connect.

eg: URL = localhost:9160, or 10.100.3.234:

2) After a Successful connection you will be directed to keyspace listing page. Which will include Keyspaces and clickable column family names. Click on a Column Family to Explore data.

3) Row view Page.

After clicking the column family you have landed in the row view page. It includes rows of your column family and a slice of column data as a summary.

You can search, paginate or change no of items to filter your data. Click "view more" to explore a single row.

4) Column family view page will list all the columns in a single row. You can filter the data with column name,value or time stamp. full numbered pagination is available.

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