Installing Apache Cassandra on CentOS 7
Traducciones al EspañolEstamos 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.
Introduction to Apache Cassandra
The Cassandra NoSQL database is ideal for situations that require 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 Cassandra Query Language, or CQL. CQL 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. 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
.
Install Cassandra
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
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:
mkdir ~/.keys
Navigate to the “.keys” directory you just created and download the public key:
curl -o repo_key http://rpm.datastax.com/rpm/repo_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. NTP will help keep the Cassandra node synced to the correct time.
Install Cassandra, Java, and NTP:
yum update && yum upgrade yum install java dsc30 cassandra30-tools ntp
Activate Cassandra
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:
nodetool status
If
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 receive connection errors, see Troubleshooting Connection Errors.
Configure Cassandra
Enable Security Features
Enable user login authentication. Make a backup of the Cassandra configuration file “cassandra.yaml.”
Note
The CentOS 7 installation already includes a backup file located at/etc/cassandra/conf/cassandra.yaml.orig
.cp /etc/cassandra/cassandra.yaml /etc/cassandra/cassandra.yaml.backup
Open “cassandra.yaml” in your preferred text editor:
vim /etc/cassandra/conf/cassandra.yaml
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.
- File: /etc/cassandra/conf/cassandra.yaml
1 2 3 4 5 6 7
. . . 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 . . .
After editing the file restart Cassandra.
Add An Administration Superuser
Open the Cassandra command terminal by typing
cqlsh
. Log in with the credentials shown below for the default usercassandra
: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];
Log out by typing
exit
.
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 file 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
~/.cassandra
directory 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.
Note
CentOS 7 users can find a sample file containing all the configuration options at/etc/cassandra/conf/cqlshrc.sample
.- 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
. . . ;; 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 440 ~/.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.
vim /etc/cassandra/conf/cassandra.yaml
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.
Troubleshooting Connection Errors
If you receive connection errors when running nodetool status
, you may need to manually enter networking information.
Open the
cassandra-env.sh
file in a text editor.sudo vim /etc/cassandra/conf/cassandra-env.sh
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/conf/cassandra-env.sh
1 2 3
. . . JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=<public name>" . . .
Restart Cassandra after you’ve finished updating the
cassandra-env.sh
file:sudo systemctl restart cassandra
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 “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.
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