http://cassandra.apache.org/downloadIn this example I am referring Cassandra 2.1.5 verison.2) Now unzip the folder by using command:
Cassandra Database Client GUI and Query Tool. The RazorSQL Apache Cassandra database client and query tool includes a Cassandra database browser, SQL editor, table editor, Cassandra import and export tools, Cassandra backup tools, and other custom Cassandra GUI tools. Listed below are more details on. The Udemy Getting Started With Apache Cassandra free download also includes 4 hours on-demand video, 6 articles, 22 downloadable resources, Full lifetime access, Access on mobile and TV, Assignments, Certificate of Completion and much more.
Download free fonts for Mac, Windows and Linux. All fonts are in TrueType format. Fontsup.com is a great collection of free fonts. However, if you’re using a Mac, I have had a lot of problems with the default system Python with the combination of Cassandra and Django. I would recommend reinstalling a new version of Python. If you don’t have the Python version that you want, downloads are available at. Cassandra extensions: The programming interface of the Cassandra framework allows you to create your own plug-ins in C and C, which can be dynamically incorporated into the framework.
tar -xzvf $PATH/apache-cassandra-2.1.5-bin.tar.gz
It will extract the tar file in the folder.
3) All the logs will go in the log folder which is configured by conf/logback.xml
~/cassandra/logs
4) The default data directories configured are:
data_file_directories : ~/cassandra/data/data
commitlog_directory: ~/cassandra/data/commitlog
saved_caches_directory: ~/cassandra/data/saved_caches
If the location needs to be overriden, then changes need to be made in the conf/cassandra.yaml
file. All the configuration related changes are there in this file only.
5) Set the CASSANDRA_HOME location in the environment variable. ~/.bash_profile
vim ~/.bash_profile
Add entries
export CASSANDRA_HOME=/Users/chikki/Documents/cassandra/apache-cassandra-2.1.5
6) Close the command window and open it again.
7) Start the cassandra server
cassandra
This command will start the cassandra server. The log will also be printed on screen with lots of information.
8) Now open another tab in the command window and login to cassandra with cqlsh shell
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 2.1.5 | CQL spec 3.2.0 | Native protocol v3]
The installation is done. Now, you can perform operations on Cassandra database.
Django is a Python web server while Cassandra is a high availability database. This article will be a complete guide for installation and use of Django with Cassandra.
Django Installation
Installing Python
Since Django is a Python web server, you’ll need Python. You can check if you have Python already.
However, if you’re using a Mac, I have had a lot of problems with the default system Python with the combination of Cassandra and Django. I would recommend reinstalling a new version of Python.
If you don’t have the Python version that you want, downloads are available at:
Cassandra Version
Various versions of Django are only compatible with different versions of Python. Currently, Django version 1.8 is the stable version release.
After you have obtained Python, you will need pip
(which is a Python package installer).
To get pip
, you will need to download the following file:
After download the get-pip.py
file, you can install pip
by changing directory to the download location.
After you have pip, you can install Django and the django cassandra driver.
Installing Cassandra
Now that you have Django and the Django’s Cassandra library, you have to install Cassandra of course. I’ve written another blog post about installing and setting up Cassandra.
Setting up a new Django project
We will create a Django project in the folder that we are at.
A new folder called mysite/
will be created with the Django files.
INSTALLED_APPS=('django_cassandra_engine',)+INSTALLED_APPS |
This app should be the first app
on INSTALLED_APPS
list.
Also, you need to change another group of lines.
2 4 6 8 10 12 14 | 'default':{ 'NAME':'db', 'HOST':'db1.example.com,db2.example.com', 'replication':{ 'replication_factor':1 } } |
HOST
should be the IP address or domain name. You can also change the names of NAME
and TEST_NAME
.
After we have configured the settings, we can create an application where our website will render. The application is another folder with Python files that will render our Django website.
The following directory structure is created inside the top level mysite/
folder:
2 4 6 8 | import uuid from cassandra.cqlengine.modelsimport Model classExampleModel(Model): read_repair_chance=0.05# optional - defaults to 0.1 example_id=columns.UUID(primary_key=True,default=uuid.uuid4) |
Since we already installed Cassandra, in another terminal, we will need to start the service.
Download Cassandra For Windows 10
Back inside the Django project, change directory to the top level mysite/
where manage.py
is.
With Cassandra running in the other terminal, we will now sync the model for Cassandra.
With Cassandra running, after syncing with the Cassandra database, we should be able to access the Cassandra shell.
With this command, we can access the Cassandra shell inside the db database we create inside the mysite/settings.py
. Nothing is inside the db at the moment though. Let’s exit our of the shell and come back to it later.
We will allow the root index /
to work at http://localhost:8080. Inside example/urls.py
, we will need to adjust the url settings.
2 4 | from.import views urlpatterns=[url(r'^$',views.index,name='index'),] |
Datastax Cassandra Download For Mac
What this snippet does is that it allows a function named index inside example/views.py
to render the page at http://localhost:8080.
Inside example/views.py
, we can write:
2 4 | returnHttpResponse('Hello world') |
After saving that file, if you change directory to the top level mysite/
, you can run the following command to boot your Django server up.
If you visit http://localhost:8080, you should see the 'Hello world'
in plain text.
Inside the example/views.py
, we can start connecting to the Cassandra database with Python. Add the following imports for Cassandra and to the model to be able to establish Python connection with Cassandra.
2 4 6 8 10 12 14 | from cassandra.cqlengine.managementimport sync_table from models import ExampleModel cluster=Cluster(['127.0.0.1']) session.set_keyspace('db') insert=ExampleModel(description='Hello world description') cluster.shutdown() |
Make sure that cassandra -f
is running! Visit http://localhost:8080, and the page should render 'Hello world'
like before, but this time, it will also insert a row for 'Hello world description'
in Cassandra.
In another terminal, you go to the top level mysite/
directory, and run the following command with cassandra -f
running in another terminal:
2 4 | example_id|description |'Hello world description' |
Download Cassandra Mac
You have done your first insert with Django and Cassandra and checked the contents from the Cassandra shell!