Cassandra Cheatsheet
Cassandra Client Guide
Installing cqlsh
This section details how to install the cqlsh
client, a
crucial tool for interacting with Cassandra databases. For users on
Alpine Linux, the following commands will set up the necessary
Python environment and install cqlsh
.
To install the cqlsh
client on alpine linux:
apk --no-cache add python3 py3-pip
pip3 install cqlsh
Connecting to Cassandra
Establishing a connection to your Cassandra cluster is
straightforward using cqlsh
. Below are the methods for
connecting from the same node where cqlsh
is installed,
and for connecting over a network to a remote Cassandra instance.
From the same node:
cqlsh -u user -p password
Over the network:
CQLSH_HOST=cassandra.databases CQLSH_PORT=9042 cqlsh -u user -p password
Describing Keyspaces
To understand the structure of your Cassandra database, you can list all available keyspaces. This command is fundamental for database exploration and management.
DESCRIBE keyspaces;
For more in-depth information on Cassandra and its command-line interface, refer to the official Cassandra documentation and the cqlsh reference.