Hack The Sec-Leading Resource Of Linux Tutorial: Cassandra

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline">
<span style="color: red;"><span style="font-size: large;"><u>Setup Cassandra and run a Single-Node Cluster</u></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers capabilities that relational databases and other <a href="http://www.hackthesec.co.in/search/label/nosql_database">NoSQL</a> databases simply cannot match such as: continuous availability, linear scale performance, operational simplicity and easy data distribution across multiple data centers and cloud availability zones. Cassandra’s architecture is responsible for its ability to scale, perform, and offer continuous uptime. Rather than using a legacy master-slave or a manual and difficult-to-maintain shared architecture, Cassandra has a masterless "ring" design that is elegant, easy to setup, and easy to maintain.</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuVjo0yCqyiJYDZ7C3zEZhBre8U3ebJTdOMaEGkTPY8xT6Kv8b8yjWHHvT9JFO58TbS-NVd4V1cVXIWBfAhCUktnTwoJ8ZD3sMobafW29y5msMnar5jum7doypNYRuQd7e590BQgujc_g/s1600/UBUNTU-Cassandra-hackthesec.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuVjo0yCqyiJYDZ7C3zEZhBre8U3ebJTdOMaEGkTPY8xT6Kv8b8yjWHHvT9JFO58TbS-NVd4V1cVXIWBfAhCUktnTwoJ8ZD3sMobafW29y5msMnar5jum7doypNYRuQd7e590BQgujc_g/s1600/UBUNTU-Cassandra-hackthesec.jpg" /></a><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span><br /><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Let’s see how we are going to install and use it to run a single-node cluster on Ubuntu 16.04.</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>System Update:</b></u><br />Update our system to latest updates and security patches available before installing other prerequisites and Cassandra, . You can run the command below to get the latest updates.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get update</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>Installing JDK 8:</b></u><br />Apache Cassandra is run on top of Java Virtual Machine (JVM). We’ll install Oracle JDK 8 on the system before we install Apache Cassandra. Apache Cassandra can also run on OpenJDK, IBM JVM and Azul Zing JVM.<br /><br />We will install Oracle JDK using the Webupd8 team team PPA repository. First step is to add the webupd8team ppa repository using below command.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo add-apt-repository ppa:webupd8team/java</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>Press [ENTER] to continue or ctrl-c to cancel adding it.</b><br />You need to press enter to continue adding the webupd8team PPA repository. Then update the package database and install JDK 8 by flowing below command.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get update</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5502r8sc_O6VBb4Mtn3ZJ4I7p4QLPUtAK0vhyphenhyphenywdwpXSRUDRZX6S7IG90GWnOyR37hadpD8PRv_BHgRSrVYaFDKG2LF1kiMn20smV2Cm8Sjx4hmW-eAA1XToEV03zS5XA5cEjI6y84hyphenhyphenw/s1600/1_jdk_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5502r8sc_O6VBb4Mtn3ZJ4I7p4QLPUtAK0vhyphenhyphenywdwpXSRUDRZX6S7IG90GWnOyR37hadpD8PRv_BHgRSrVYaFDKG2LF1kiMn20smV2Cm8Sjx4hmW-eAA1XToEV03zS5XA5cEjI6y84hyphenhyphenw/s1600/1_jdk_hackthesec.co.in.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now install the Oracle JRE package, this will not only installs but also makes it the default JRE.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get -y install oracle-java8-installer</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Accept the license agreement when prompted.</span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN7qlJXe6WeThTLSMyp_s0DgN78ESHdOlqtpyO638GzbscgfvXPUZmHOqcpiiHwckmsY0dZc8H-IG64QkCcVxA9S3Ug7tXP74cksS6lY_urHDsJ1Rj6fgZud7uc1EkyTVDQz5F5Bv6AXPB/s1600/2_oracle-java_hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN7qlJXe6WeThTLSMyp_s0DgN78ESHdOlqtpyO638GzbscgfvXPUZmHOqcpiiHwckmsY0dZc8H-IG64QkCcVxA9S3Ug7tXP74cksS6lY_urHDsJ1Rj6fgZud7uc1EkyTVDQz5F5Bv6AXPB/s1600/2_oracle-java_hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then accepting the Oracle Binary Code License Terms by Choosing <b>'Yes'</b> option</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaYmwVfnAewIyX5CCV0ULA9BAACrKvtgxC_n05K2kdfbUfY0c7UAR2eND-kRh3j16Ud_ymOS3y_F8UNPO1I6gqspazdKclDn1owd5uOBuGCtT8s1kJf2jZzfkOD1L-Lo4RNpLFTqmvhYTB/s1600/3_oracle-java-license-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaYmwVfnAewIyX5CCV0ULA9BAACrKvtgxC_n05K2kdfbUfY0c7UAR2eND-kRh3j16Ud_ymOS3y_F8UNPO1I6gqspazdKclDn1owd5uOBuGCtT8s1kJf2jZzfkOD1L-Lo4RNpLFTqmvhYTB/s1600/3_oracle-java-license-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once installation of Java 8 complete, you can check the current java version by running command below.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;"><span style="color: #333333; font-family: menlo,monaco,consolas,courier new,monospace;"><span style="line-height: 25.7143px;">ubuntu@ubuntu-16:~$ java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)</span></span></span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="color: #0b5394;"><u><b>Installing Apache Cassandra:</b></u></span><br />No we can start installing Apache Cassandra ,from the official Apache Software Foundation repositories, so start by adding the repo so that the packages are available to the system by adding the repo's source.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ echo "deb-src http://www.apache.org/dist/cassandra/debian 37x main" | sudo tee -a /etc/apt/sources.list.d/cassandra.sources.list</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then add the following three public keys from the Apache Software Foundation associated with the package repositories to avoid package signature warnings.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;"><span style="color: #333333; font-family: menlo,monaco,consolas,courier new,monospace;"><span style="line-height: 25.7143px;">$ gpg --keyserver pgp.mit.edu --recv-keys F758CE318D77295D
$ gpg --export --armor F758CE318D77295D | sudo apt-key add -</span></span></span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"> Add the second key using below commands.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;">$ gpg --keyserver pgp.mit.edu --recv-keys 2B5C1B00
$ gpg --export --armor 2B5C1B00 | sudo apt-key add -</span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"> To add third keys run the below commands.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;">$ gpg --keyserver pgp.mit.edu --recv-keys 0353B12C
$ gpg --export --armor 0353B12C | sudo apt-key add -</span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After this once again update your system, so that ‘apt-get’ can read the metadata of Cassandra repository.</span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3hGspjUd9Xri5z63A2QubM_mUWwD6gnGDTL-OQBxqRbCdl5tQfedCQNAzSuFZqbLqrM1lN62IxrvN5fxmGBz2wO3R-22zbELDuXWC6P8cElYkNAY0wPWz_RKyZTKi0LKt-IzubCPUN5KO/s1600/4_cassandra-key-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3hGspjUd9Xri5z63A2QubM_mUWwD6gnGDTL-OQBxqRbCdl5tQfedCQNAzSuFZqbLqrM1lN62IxrvN5fxmGBz2wO3R-22zbELDuXWC6P8cElYkNAY0wPWz_RKyZTKi0LKt-IzubCPUN5KO/s1600/4_cassandra-key-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After system updates, now let's install Cassandra 37x on your Ubuntu 14 LTS. This is the latest stable version of Cassandra.<br /><br />Run the below command to install Cassandra on your Ubuntu system and pres 'y' key to continue.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get install cassandra</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi0u8pMOf6hmOgE2WGHQ09aTnRiSLztt8YNodwAqHcEXSeowXYxx0Yziimtx1eCU_Tslhgeom1ab_ahyphenhyphen51FVo_ISZ4qqSExnISiSHrKFocUUrnJdse3Leg5G5e6iKF1khWOt65CuBEeVrL/s1600/5_intall-casandra-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi0u8pMOf6hmOgE2WGHQ09aTnRiSLztt8YNodwAqHcEXSeowXYxx0Yziimtx1eCU_Tslhgeom1ab_ahyphenhyphen51FVo_ISZ4qqSExnISiSHrKFocUUrnJdse3Leg5G5e6iKF1khWOt65CuBEeVrL/s1600/5_intall-casandra-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>Starting Cassandra service:</b></u><br />Now Cassandra service should be up and running on your system.<br />To confirm that it’s not running, use below command to check its status.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo service cassandra status </pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you did not get the running status, then flow the command below in your command line terminal to start its service.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo service cassandra start</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>Connecting to the Cluster:</b></u><br />Once your Cassandra service is up and running , check the status of the cluster using below command.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo nodetool status</pre>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">Datacenter: datacenter1
=======================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--  Address    Load       Tokens       Owns (effective)  Host ID                               Rack
UN  127.0.0.1  103.01 KiB  256          100.0%            da43244b-b1f1-4426-9b24-9ea3cb31ecb4  rack1</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">In the output, UN means it’s Up and Normal. Then connect to it using its interactive command line interface 'cqlsh'. </span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ cqlsh</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimN4Xz-Zb5Dbe50ZVifnbY23F33OcRr4wVloCvsro6dEfJ_wVDjkC-nEhto86B9zDXWljsreAYaH6oa0uOUF4eyM5RvYzYQq86cS7YY1W50iYsXCJhJ_-eOw0osXlQtyZidnVe8HVSoD-n/s1600/6_connecting-cluster-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimN4Xz-Zb5Dbe50ZVifnbY23F33OcRr4wVloCvsro6dEfJ_wVDjkC-nEhto86B9zDXWljsreAYaH6oa0uOUF4eyM5RvYzYQq86cS7YY1W50iYsXCJhJ_-eOw0osXlQtyZidnVe8HVSoD-n/s1600/6_connecting-cluster-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="color: #0b5394;"><u><b>Using Apache Cassandra:</b></u></span><br />Let’s try our Cassandra installation by creating a test database. First of all let’s create a keyspace, this is a namespace for tables. The keyspace name below is 'mydb'.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cqlsh> CREATE KEYSPACE mydb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }; 
cqlsh> use mydb;
cqlsh:moviedb> CREATE TABLE books (id int PRIMARY KEY, title text, year text);
cqlsh:mydb> DESC books;</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgecD3JL1s54qhL49It7Y5ReBs5D2Qc8wHnx1x56buaavMfHFVIUutV1sWv72w3AlFlmhNcV_7KDODBkKy_6cyybwUSYcd3oaUSgeKmllVPJ5TqB62tMTlbcz-2_89xbbHOyVU2KsHhi5XO/s1600/7_using-cassandra-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgecD3JL1s54qhL49It7Y5ReBs5D2Qc8wHnx1x56buaavMfHFVIUutV1sWv72w3AlFlmhNcV_7KDODBkKy_6cyybwUSYcd3oaUSgeKmllVPJ5TqB62tMTlbcz-2_89xbbHOyVU2KsHhi5XO/s1600/7_using-cassandra-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">The table is ready, now you can to add some data in it. </span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Thanks & Regards<a href="http://www.hackthesec.co.in/"><br />www.hackthesec.co.in</a></span></span></span><br /><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span><span style="font-weight: normal;"></span><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></h1>
</div>