View All Products
Compute
Storage
Databases
Networking
Developer Tools
Delivery
Security
Services
Industries
Pricing
Community
Engage With Us

Installing Apache Cassandra on Ubuntu 18.04

Updated Originally authored by Linode
Select distribution:
Traducciones al Español
Estamos traduciendo nuestros guías y tutoriales al Español. Es posible que usted esté viendo una traducción generada automáticamente. Estamos trabajando con traductores profesionales para verificar las traducciones de nuestro sitio web. Este proyecto es un trabajo en curso.
Create a Linode account to try this guide with a $ credit.
This credit will be applied to any valid services used during your first  days.

After completing this guide, you will have a single-node, production-ready installation of Apache Cassandra hosted on your Linode running Ubuntu 18.04. This tutorial will cover basic configuration options, as well as harden database security.

Note
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 sudo.

Before You Begin

  1. Complete the Getting Started guide for setting up a new Linode.
  2. While it is recommended you complete the entire Securing Your Server guide, at minimum, you should add a limited user account.

Install OpenJDK (Java)

Apache Cassandra requires OpenJDK 8 or OpenJDK 11 (both are LTS releases). OpenJDK 11 has been officially supported in Cassandra since 4.0.2 (February 8, 2022).

  1. Check to see if you have Java installed and, if so, verify that it is a compatible version.

    java -version

  2. If Java is not installed, install OpenJDK. The command below installs OpenJDK 11, though you can replace the package with openjdk-8-jdk if you wish to use OpenJDK 8.

    apt update
apt install openjdk-11-jdk

Install Cassandra

Add Apache Cassandra’s repository and GPG keys so that you can install Cassandra.

  1. Add the Apache Cassandra repository:

    echo "deb http://www.apache.org/dist/cassandra/debian 40x main" |  sudo tee /etc/apt/sources.list.d/cassandra.list
    Note
    The above command installs the latest version within the Apache Cassandra 4.0 release. To see what other versions are available, you can review the repository and adjust the command as needed.

  2. Add the keys required to access the repository:

    curl https://downloads.apache.org/cassandra/KEYS | sudo apt-key add -

  3. Get the latest package information from the newly added source and install Apache Cassandra.

    sudo apt update
sudo apt install cassandra

Activate Cassandra

  1. Enable Cassandra on system boot and verify that it is running:

    sudo systemctl enable cassandra
sudo systemctl start cassandra
sudo systemctl -l status cassandra

  2. Check the status of the Cassandra cluster:

    nodetool status

    If UN is displayed in the output, the cluster is working. Your output should resemble the following:

    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 receive connection errors, see Troubleshooting Connection Errors.

Configure Cassandra

Enable Security Features

In this section, you will enable user login authentication. You can also configure other security settings based on your project’s needs.

  1. Make a backup of the Cassandra configuration file cassandra.yaml.

    sudo cp /etc/cassandra/cassandra.yaml /etc/cassandra/cassandra.yaml.backup

  2. Open cassandra.yaml in your preferred text editor:

    Note
    Locations of the cassandra.yaml file may differ slightly between distros.
    sudo vim /etc/cassandra/cassandra.yaml

  3. Match the following variables in the file to the values shown in the example file. If any values are commented out, uncomment them. The rest of the properties found in the cassandra.yaml 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.

    File: Ubuntu /etc/cassandra/cassandra.yaml
     1
 2
 3
 4
 5
 6
 7
 8
 9
10

    . . .

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

. . .

    More information about this file can be found in the Cassandra Configuration File guide in Apache’s official documentation.

  4. After editing the configuration file restart Cassandra.

    sudo systemctl restart cassandra

Add An Administration Superuser

  1. Open the Cassandra command terminal by typing cqlsh. Log in with the credentials shown below for the default user cassandra:

    cqlsh -u cassandra -p cassandra

  2. Create a new superuser. Replace the brackets as well as the content inside with the applicable information:

    CREATE ROLE [new_superuser] WITH PASSWORD = '[secure_password]' AND SUPERUSER = true AND LOGIN = true;

  3. Log out by typing exit.

  4. Log back in with the new superuser account and replace the username and password with your new credentials:

    cqlsh -u new-super-user -p my-scecure-password

  5. Remove the elevated permissions from the Cassandra account:

    ALTER ROLE cassandra WITH PASSWORD = 'cassandra' AND SUPERUSER = false AND LOGIN = false;
REVOKE ALL PERMISSIONS ON ALL KEYSPACES FROM cassandra;

  6. Grant all permissions to the new superuser account. Replace the brackets and contents inside with your superuser account username:

    GRANT ALL PERMISSIONS ON ALL KEYSPACES TO [superuser];

  7. Log out by typing exit.

Edit The Console Configuration File

The cqlshrc file holds configuration settings that influence user preferences and how Cassandra performs certain tasks.

Note
Ensure you complete the steps in this section using your limited user account. This account will need sudo privileges, if it does not already have them.

Since your Cassandra username and password can be stored in plaintext, the cqlshrc file should only be accessible to your administrative user account, and is designed to be inaccessible to other accounts on your Linux system.

Important
Do not complete this section as the root user. Before proceeding, fully evaluate the security risks and consequences to your node cluster before adding the [authentication] section.

  1. Create the file cqlshrc using your preferred text editor. If the ~/.cassandra directory does not exist, create it:

    sudo mkdir ~/.cassandra
sudo vim ~/.cassandra/cqlshrc

  2. Copy any sections below that you wish to add to your configuration, and ensure you replace the superuser and password value in brackets with your own values. Details for this file can be found in the Configuring cqlsh From a File guide on the DataStax site.

    File: ~/.cassandra/cqlshrc
     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
30
31
32
33

    . . .

;; 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

. . .

  3. Save and close the file.

  4. Update the cqlshrc file and directory with the following permissions:

    sudo chmod 440 ~/.cassandra/cqlshrc
sudo chmod 700 ~/.cassandra

  5. Login by typing the command below. You will be prompted to enter your password. The cqlsh command terminal should open, and your superuser name should be visible in the command line.

    cqlsh -u superuser
    Note

    You can also login by providing your username and password:

    cqlsh -u superuser -p password

Rename the Cluster

In this section, you will update your default cluster name from “Test Cluster” to your desired name.

  1. Log into the cqlsh control terminal if you are not already logged in.

    cqlsh -u superuser

  2. Replace [new_name] with your new cluster name:

    UPDATE system.local SET cluster_name = '[new_name]' WHERE KEY = 'local';

  3. Type exit to return to the Linux command line.

  4. Edit the cassandra.yaml file and replace the value in the cluster_name variable with the new cluster name you just set.

    sudo vim /etc/cassandra/cassandra.yaml

  5. Save and close.

  6. From the Linux terminal (not cqlsh) clear the system cache. This command will not disturb your node’s data.

    nodetool flush system

  7. Restart Cassandra:

    sudo systemctl restart cassandra

  8. Log in with cqlsh and verify the new cluster name is visible.

    cqlsh -u superuser

    Connected to my-cluster-name at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 4.0 | CQL spec 3.4.5 | Native protocol v4]
Use HELP for help.
superuser@cqlsh>

Troubleshooting Connection Errors

If you receive connection errors when running nodetool status, you may need to manually enter networking information.

  1. Open the cassandra-env.sh file in a text editor.

    sudo vim /etc/cassandra/cassandra-env.sh

  2. Search for -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:

    File: /etc/cassandra/cassandra-env.sh
    1
2
3

    . . .
JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=<public name>"
. . .

  3. Restart Cassandra after you’ve finished updating the cassandra-env.sh file:

    sudo systemctl restart cassandra

  4. Check the node status again after the service restarts:

    nodetool status
    Note
    It 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.

Where To Go From Here

Be sure to check out the links in the More Information 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 Adding Nodes to an Existing Cluster for more information.

More Information

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.

This page was originally published on

ubuntu database nosql

Your Feedback Is Important

Let us know if this guide was helpful to you.

Join the conversation.
Read other comments or post your own below. Comments must be respectful, constructive, and relevant to the topic of the guide. Do not post external links or advertisements. Before posting, consider if your comment would be better addressed by contacting our Support team or asking on our Community Site.
The Disqus commenting system for Linode Docs requires the acceptance of Functional Cookies, which allow us to analyze site usage so we can measure and improve performance. To view and create comments for this article, please update your Cookie Preferences on this website and refresh this web page. Please note: You must have JavaScript enabled in your browser.