In this tutorial, you will learn-
DevCenter is the front end query tool where you can write your query and execute it. DevCenter is provided by the Datastax.
Here are the steps of running DevCenter installation;
Step 1) First of all, download DevCenter from the datastax site.
Step 2) Go to DevCenter directory and execute DevCenter executable file.
After running above command, following page will be displayed. Below form is the user interface for DevCenter.
Step 3) 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
- Make sure that Cassandra enterprise server is running
- Click on the red rectangle (in the above screenshot) for creating a connection.
Step 4) After clicking on it, you will be displayed on the following page.
- Give connection name, you can give any connection name. This is not a specific thing.
- Provide IP address of the node as Contact hosts.
- Provide port number, by default port, is 9042.
- Next select compression type
- After providing this information, press finish button.
After this, DevCenter should run successfully.
Here is the screenshot that displays different parts in the DevCenter User interface.
- Select "connection" from the drop down. Usually, you have only one connection that you have been created.
- Select keyspace from the drop down from which you want to query data.
- Select a number of records that you want to retrieve and display on the DevCenter User interface.
- Execute button to execute the query.
- 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.
- Write query on the above form where the number is displayed. Select the query and press execute button.
- 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.
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.
This tutorial is step by step guidance on how to setup OpsCenter tool.
- You must have running Cassandra enterprise server for OpsCenter installation.
- 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.
This page provides OpsCenter version information. Press the next button
Step 2) After pressing next button, following page will be displayed.
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.
This page asks about the installation options.
- Select install type, choose Simple Install
- Check no to update system
- Select IP address of the machine.
- Press the next button
Step 4) After pressing the next button following page will be displayed.
OpsCenter is ready to install, press the next button
Step 5) After pressing the next button following page will be displayed.
Setup is being installed. After setup is successfully installed, press next button.
Step 6) After pressing next button following page will be displayed.
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.
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
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
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.
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.