Connecting to Cassandra Database via SSH

SSH is a web-based shell-like interface that enables remote access and management of an application by allowing the execution of commands. You can issue commands to perform operations like monitoring, debugging, configuration parameters changing, a single database backing up, and etc. The default connection time-out time for SSH is 60 minutes. Any network disconnection will cause WebShell disconnected.

Note:

  • For security reasons, only the account holders who have passed our verification will be granted permission to the SSH service. If you would like to enable it, please update your billing information.

  • The default connection time-out time for WebShell is 60 minutes. Any network disconnection will cause WebShell disconnected.

1. Locate your target deployment

Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.

2. Go to the Shell / SSH page

Click the “Shell / SSH” tab > the connect icon to open the shell interface.

3. Connect to the database

Click the "Connect" icon to launch a shell session

Connect to Cassandra database with default super user

"cassandra" is the default super user we created in Cassandra Server. We can get the password for cassandra from system environment variable. cqlsh is a command line shell for interacting with Cassandra through CQL (the Cassandra Query Language).

We use cqlsh to connect to Cassandra Server

Please issue the command below in the shell session:

cqlsh -u cassandra -p $ROOT_PASS

Connect to Cassandra database with a regular user

If you created a regular user(non-superuser) with the access permission to a database, you can connect to the Cassandra database with your regular user by issuing the command below.

cqlsh -u <username> -p <yourpassword>

Replace the <username> with your own username. Replace the<yourpassword> with the password of the user.

4. Manage the database

Now you are ready to manage your database using command lines as you like.

Copyright © 2021 Cloud Clusters Inc. all right reserved,powered by GitbookRevised on 05/31/2021

results matching ""

    No results matching ""