How to Install Apache Cassandra on Ubuntu 17.04 and CentOS 7
Updated by Andrew Lescher Contributed by Andrew Lescher
Introduction to Apache Cassandra
The Cassandra NoSQL database is ideal for situations requiring maximum data redundancy and uptime, ease of horizontal scaling across multiple unique servers, and rapidly evolving project demands during the development life cycle which would otherwise be heavily restricted by traditional relational database implementations. Apache Cassandra is an open-source application that is managed in a simple command line interface using the CQL language. CQL, or Cassandra Query Language is syntactically similar to the Structured Query Language, making it easy to pick up for those already familiar with SQL.
After completing this guide, you will have a single-node, production-ready installation of Apache Cassandra hosted on your Linode. This tutorial will cover basic configuration options, as well as harden database security. If the instructions differ between the Ubuntu and CentOS distros, they will be presented in sections underneath the bolded names of the distributions. In order to successfully execute the commands in this guide, you will need to run them as the “root” user, or log in using an account with root privileges, prefixing each command with
Before You Begin
- Complete the Getting Started guide for setting up a new Linode.
- While it is recommended you complete the entire Securing Your Server guide, it will be necessary at least to possess a limited user account.
Add Repositories and GPG Keys
Add required repositories/gpg keys. Be sure to run the key add commands in the order shown.
Caution(Ubuntu only) If you receive an error while running
apt updatethat pertains to a missing key, copy the key listed in the error message and add it to your keyring using the commands in step 4. As of this publish date, the only keys required are listed below.
Add the package
apt install software-properties-common
Add the Java repository:
Add the apache repository:
echo "deb http://www.apache.org/dist/cassandra/debian 39x main" | tee /etc/apt/sources.list.d/cassandra.list
NoteYou may want to follow the link to the Apache repository to confirm that “39x” is the latest available version.
Download the two public keys needed to access these repositories:
gpg --keyserver pgp.mit.edu --recv-keys 749D6EEC0353B12C gpg --export --armor 749D6EEC0353B12C | apt-key add - gpg --keyserver pgp.mit.edu --recv-keys A278B781FE4B2BDA gpg --export --armor A278B781FE4B2BDA | apt-key add -
Install the “yum-utils” package:
yum install yum-utils -y
Add the Datastax repository:
yum-config-manager --add-repo http://rpm.datastax.com/community
Add the public key for the datastax repository. Create a directory for the downloaded key:
Navigate to the “.keys” directory you just created and download the public key:
The key should now be contained in a file called “repo_key”. Install the key with the package manager:
rpm --import repo_key
Install Cassandra and Supporting Applications
Update the system and install Java along with Cassandra. Answer “yes” to the Java installation prompts regarding the license terms (Ubuntu only). NTP will help keep the Cassandra node synced to the correct time.
Install Cassandra, Java, and NTP:
apt-get update && apt-get upgrade -yuf apt-get install oracle-java8-set-default cassandra ntp -y
yum update && yum upgrade -y yum install java dsc30 cassandra30-tools ntp -y
Enable Cassandra on system boot and verify that it is running:
systemctl enable cassandra systemctl start cassandra systemctl -l status cassandra
Check the status of the Cassandra cluster:
UN is displayed in the output, the cluster is working. Your output should resemble this:
Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 127.0.0.1 103.51 KiB 256 100.0% c43a2db6-8e5f-4b5e-8a83-d9b6764d923d rack1
If you are receiving connection errors, open the
cassandra-env.sh file in a text editor:
-Djava.rmi.server.hostname= in the file. Uncomment this line and add your loopback address or public IP address by replacing
<public name> at the end of the line:
JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=<public name>"
Restart Cassandra with
systemctl restart Cassandra and check the node status
NoteIt may take a few seconds for Cassandra to refresh the configuration. If you receive another connection error, try waiting 15 seconds before rechecking the node status.
Enable Security Features
Enable user login authentication. Make a backup of the Cassandra configuration file “cassandra.yaml.”
NoteThe CentOS 7 installation already includes a backup file located at
cp /etc/cassandra/cassandra.yaml /etc/cassandra/cassandra.yaml.backup
Open “cassandra.yaml” in your preferred text editor:
Match the following variables in the file to the values shown below. If any values are commented out, uncomment them. The rest of the properties found in the cassandra.yaml config file should be set based on your project’s particular requirements and how you plan to utilize Cassandra. The default configuration should work well for development.
More information on this file can be found by following the Cassandra .yaml Configuration File Overview link in the “External Resources” section.
After editing the file restart Cassandra.
- Ubuntu /etc/cassandra/cassandra.yaml
1 2 3 4 5
authenticator: org.apache.cassandra.auth.PasswordAuthenticator authorizer: org.apache.cassandra.auth.CassandraAuthorizer role_manager: CassandraRoleManager roles_validity_in_ms: 0 permissions_validity_in_ms: 0
Add An Administration Superuser
Open the Cassandra command terminal by typing
cqlsh. Login with the credentials shown below for the default user “Cassandra”:
cqlsh -u cassandra -p cassandra
Create a new superuser. Replace the brackets as well as the content inside with the applicable information:
cassandra@cqlsh> CREATE ROLE [new_superuser] WITH PASSWORD = '[secure_password]' AND SUPERUSER = true AND LOGIN = true;
Log out by typing exit.
Log back in with the new superuser account using the new credentials, and remove the elevated permissions from the Cassandra account:
superuser@cqlsh> ALTER ROLE cassandra WITH PASSWORD = 'cassandra' AND SUPERUSER = false AND LOGIN = false; superuser@cqlsh> REVOKE ALL PERMISSIONS ON ALL KEYSPACES FROM cassandra;
Grant all permissions to the new superuser account. Replace the brackets and contents inside with your superuser account username:
superuser@cqlsh> GRANT ALL PERMISSIONS ON ALL KEYSPACES TO [superuser];
Edit The Console Configuration File
The cqlshrc file holds configuration settings that influence user preferences on how Cassandra performs certain tasks. Before proceeding, switch from the “root” user to your administrative Linux user account (you need sudo privileges for this).
Since your Cassandra username and password can be stored here in plaintext, this should only be accessible to your administrative user account, and is designed to be inaccessible to other accounts on your Linux system. Do not set this up as the root user. Caution: Before proceeding, fully evaluate the security risks and consequences to your node cluster before adding the [Authentication] section.
Create the file cqlshrc using your preferred text editor. If the
~/.cassandradirectory does not exist, create it:
sudo mkdir ~/.cassandra sudo vim ~/.cassandra/cqlshrc
Copy any sections below that you wish to add to your configuration. Details for this file can be found by following the “Cassandra cqlshrc File Configuration Overview” link in the “External Resources” section.
NoteCentOS 7 users can find a sample file containing all the configuration options at
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
;; Options that are common to both COPY TO and COPY FROM [copy] ;; The string placeholder for null values nullval=null ;; For COPY TO, controls whether the first line in the CSV output file will ;; contain the column names. For COPY FROM, specifies whether the first ;; line in the CSV file contains column names. header=true ;; The string literal format for boolean values boolstyle = True,False ;; Input login credentials here to automatically login to the Cassandra command line without entering them each time. When this ;; is enabled, just type "cqlsh" to start Cassandra. [authentication] username=[superuser] password=[password] ;; Uncomment to automatically use a certain keyspace on login ;; keyspace=[keyspace] [ui] color=on datetimeformat=%Y-%m-%d %H:%M:%S%z completekey=tab ;; The number of digits displayed after the decimal point ;; (note that increasing this to large numbers can result in unusual values) float_precision = 5 ;; The encoding used for characters encoding = utf8
Save and close the file. Update the file and directory with the following permissions:
sudo chmod 1700 ~/.cassandra/cqlshrc sudo chmod 700 ~/.cassandra
If you enabled the auto-login feature, login by typing
cqlsh. The command terminal should open, and your superuser name should be visible in the command line.
Rename the Cluster
Update your default cluster name from “Test Cluster” to your desired name.
Login to the control terminal with cqlsh. Replace [new_name] with your new cluster name:
UPDATE system.local SET cluster_name = '[new_name]' WHERE KEY = 'local';
Edit the cassandra.yaml file and replace the value in the cluster_name variable with the new cluster name you just set.
Save and close.
From the Linux terminal (not cqlsh), run
nodetool flush system. This will clear the system cache and preserve all data in the node.
Restart Cassandra. Log in with cqlsh and verify the new cluster name is visible.
Where To Go From Here
Be sure to check out the links in the “External Resources” section, which will help you further configure Cassandra to your needs, as well as provide resources to improve your understanding and ability to use Cassandra. To fully utilize the capabilities of Cassandra in a production setting, additional nodes should be added to your cluster. See the companion guide, “Deploy Additional Nodes To The Cassandra Cluster” to get started.
You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.
- Cassandra Documentation
- Cassandra cqlshrc File Configuration Overview
- Cassandra .yaml Configuration File Overview
- Recommended Production Settings For Apache Cassandra
- The Cassandra Query Language (CQL)
Join our Community
This guide is published under a CC BY-ND 4.0 license.