Connecting to a GeminiDB Cassandra Instance over a Private Network

Usage Notes

• The target instance must be in the same VPC and subnet as the ECS.
• The ECS must be in a security group that has access to the instances. For details, see Setting Security Group Rules for a GeminiDB Cassandra Instance.

Prerequisites

1. A GeminiDB Cassandra instance has been created and is running properly.
2. An ECS has been created. The following uses a Linux ECS as an example.

   For details, see Purchasing an ECS in Getting Started with Elastic Cloud Server.

3. Download and install the Cassandra client that matches the CPU type of the ECS.
   • If the CPU type is x86, download the Cassandra client.
   • If the CPU type is Kunpeng, download the Cassandra client.
4. Before connecting to an instance over SSL, obtain an SSL certificate. For details, see Downloading the SSL Certificate.

Non-SSL Connection

1. Log in to ECS.

   For details, see Logging In to an ECS in Getting Started with Elastic Cloud Server.

2. Upload the Cassandra client installation package to the ECS.
3. Run the following command to decompress the client installation package. The x86 client is used as an example.

   unzip Cassandra_cqlsh_x86_64.zip

4. Run the following command to grant the execute permission on all files:

   chmod +x *

5. Connect to the DB instance in the directory where the cqlsh tool is located.

   ./cqlsh <DB_HOST> <DB_PORT> -u <DB_USER>

   Example:

   ./cqlsh 192.xx.xx.xx 8635 -u rwuser

   Table 1 Description

   Parameter	Description
   <DB_HOST>	Private IP address of an instance to be connected. To obtain this IP address, go to the Instance Management page and click the target instance name. The IP address can be found in the Private IP Address field under Node Information on the Basic Information page. If the instance you purchased has multiple nodes, select the private IP address of any node. Figure 1 Viewing the private IP address
   <DB_PORT>	Port number of the instance to be connected. The default port number is 8635. Replace it with the actual port number. Click the instance name to go to the Basic Information page and obtain the port number in the Network Information area. Figure 2 Viewing the port number
   <DB_USER>	Database account. The default value is rwuser.

6. Check the results. If the following information is displayed, the connection is successful.

   rwuser@cqlsh>

SSL

1. Log in to ECS.

   For details, see Logging In to an ECS in Getting Started with Elastic Cloud Server.

2. Upload the Cassandra client installation package to the ECS.
3. Upload the SSL certificate to the ECS.
4. Run the following command to decompress the client installation package. The x86 client is used as an example.

   unzip Cassandra_cqlsh_x86_64.zip

5. Run the following command to grant the execute permission on all files:

   chmod +x *

6. Connect to the DB instance in the directory where the cqlsh tool is located.

   export SSL_CERTFILE=/<PATH_OF_SSL_CERT_FILE>

   export SSL_VERSION=TLSv1_2

   ./cqlsh <DB_HOST> <DB_PORT> --ssl -u <DB_USER>

   Example:

   ./cqlsh 192.168.1.8 8635 --ssl -u rwuser

   Table 2 Description

   Parameter	Description
   <PATH_OF_SSL_CERT_FILE>	SSL file path.
   <DB_HOST>	Private IP address of an instance to be connected. To obtain this IP address, go to the Instance Management page and click the target instance name. The IP address can be found in the Private IP Address field under Node Information on the Basic Information page. If the instance you purchased has multiple nodes, select the private IP address of any node. Figure 3 Viewing the private IP address
   <DB_PORT>	Port number of the instance to be connected. The default port number is 8635. Replace it with the actual port number. Click the instance name to go to the Basic Information page and obtain the port number in the Network Information area. Figure 4 Viewing the port number
   <DB_USER>	Database account. The default value is rwuser.

7. Check the results. If the following information is displayed, the connection is successful.

   rwuser@cqlsh>

Follow-up Operations

After logging in to the instance, you can create keyspaces, databases, or tables. For details, see Buying and Connecting to a GeminiDB Cassandra Instance.