How to Download & Install DataStax DevCenter and OpsCenter

What is DataStax DevCenter?

DevCenter is the front end query tool where you can write your query and execute it. DevCenter is provided by the DataStax.

How to Download & Install DataStax DevCenter

Here are the steps to download and install DataStax DevCenter:

Step 1) Download DataStax DevCenter

First of all, download DevCenter from the DataStax official site.

Step 2) Execute the .exe file

Go to DevCenter directory and execute DevCenter executable file.

Download & Install DataStax DevCenter

After running above command, following page will be displayed. Below form is the user interface for DevCenter.

Step 3) Create connection with Cassandra Enterprise server

In this step, you have to create a connection with Cassandra enterprise server. Go to connection window and click on the icon as shown here

Download & Install DataStax DevCenter

  • Make sure that Cassandra enterprise server is running
  • Click on the red rectangle (in the above screen shot) for creating a connection.

Step 4) Add connection details

After clicking on it, you will be redirected to the following page:

  1. Give connection name, you can give any connection name. This is not a specific thing.
  2. Provide IP address of the node as Contact hosts.
  3. Provide port number, by default port, is 9042.
  4. Next select compression type
  5. After providing this information, press finish button.

Download & Install DataStax DevCenter

After this, DevCenter should run successfully.

Here is the screenshot that displays different parts in the DevCenter User interface.

Download & Install DataStax DevCenter

Step 5) Establish a connection and run the query

  1. Select “connection” from the drop down. Usually, you have only one connection that you have been created.
  2. Select keyspace from the drop down from which you want to query data.
  3. Select a number of records that you want to retrieve and display on the DevCenter User interface.
  4. Execute button to execute the query.
  5. Here is the little form where all the keyspaces are displayed. The system provides us with some keyspaces like System_traces and System. While some keyspaces are created by the user such as nhanes_ks.

Here is the screenshot that shows how to query data and where query results are displayed.

Download & Install DataStax DevCenter

  1. Write query on the above form where the number is displayed. Select the query and press Download & Install DataStax DevCenterexecute button.
  2. After query selection and execute the button, you will be displayed the query result as shown above with number 2. There are two columns in the table testable in the java_api keyspace. Column names are id and name. There are only two records in the table testtable.

What is DataStax OpsCenter?

OpsCenter is the visual management and monitoring tool for Apache Cassandra and DataStax enterprise. This is a very helpful tool for architects, database administrators, and database operators.

In large organizations, they have thousands of servers. It is very difficult to monitor these servers that which server is running and which server is down. OpsCenter is the tool where you can monitor all the Cassandra nodes by sitting and watching on a single machine.

How to Download & Install DataStax OpsCenter

Here is a step by step process on how to download and install DataStax OpsCenter tool:

Requirements

  1. You must have running Cassandra enterprise server for OpsCenter installation.
  2. You must have OpsCenter setup for Linux.

Step 1) Go to the OpsCenter directory and run OpsCenter. After running the OpsCenter, following page will be displayed.

Download & Install DataStax OpsCenter

This page provides OpsCenter version information. Press the next button

Step 2) After pressing next button, following page will be displayed.

Download & Install DataStax OpsCenter

This page is about the agreement. Accept the agreement and press the next button.

Step 3) After pressing the next button, following page will be displayed.

Download & Install DataStax OpsCenter

This page asks about the installation options.

  1. Select install type, choose Simple Install
  2. Check no to update system
  3. Select IP address of the machine.
  4. Press the next button

Step 4) After pressing the next button following page will be displayed.

Download & Install DataStax OpsCenter

OpsCenter is ready to install, press the next button

Step 5) After pressing the next button following page will be displayed.

Download & Install DataStax OpsCenter

Setup is being installed. After setup is successfully installed, press next button.

Step 6) After pressing next button following page will be displayed.

Download & Install DataStax OpsCenter

Setup has been installed successfully, press finish button.

Before starting OpsCenter, DataStax agents needs to be installed on each node.

Step 7) First of all, you need to install Datastax agent on each node.

For installing DataStax agent, go to the datastax-agent directory in the dse directory and run the below command.

Download & Install DataStax OpsCenter

After running this command, datastax-agent will be installed on the node. Do the same procedure for all the nodes in the cluster.

Step 8) For running OpsCenter, run the below command

Download & Install DataStax OpsCenter

After running the above command, OpsCenter will run successfully.

Step 9) For watching OpsCenter user interface, go to web browser and type in URL http://localhost:8888.

The following page will be displayed

Download & Install DataStax OpsCenter

Here is the monitoring tool where you can monitor all the nodes. You can find information how much space on the disk is filled and how much space remains.

Summary

  • DevCenter is the front end query tool where you can write your query and execute it. DevCenter is provided by the DataStax.
  • OpsCenter is the visual management and monitoring tool for Apache Cassandra and DataStax enterprise. This is a very helpful tool for architects, database administrators, and database operators.
  • OpsCenter is the tool where you can monitor all the Cassandra nodes by sitting and watching on a single machine.
  • This tutorial explains installation procedure of OpsCenter also how datastax agent, OpsCenter is installed, and the commands used to install and run DataStax agents and OpsCenter.