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.