Connecting to an Instance over a Public Network

Prerequisites

1. Bind an EIP to the GeminiDB Cassandra instance node and set security group rules. For details, see Binding and Unbinding an EIP and Configuring Security Group Rules.
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 the 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>	EIP bound to the instance to be connected. To obtain the EIP, go to the Instances page and click the target instance name. The EIP can be found in the EIP column in the Node Information area on the Basic Information page. If the instance you purchased has multiple nodes, select the EIP of any node. Figure 1 Viewing the EIP If no EIP is bound to the instance, bind an EIP to the instance by following Binding and Unbinding an EIP and then connect to the instance.
   <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>	Username of the instance administrator. The default value is rwuser.

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

   rwuser@cqlsh>

SSL Connection

1. Log in to the 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>	EIP bound to the instance to be connected. To obtain the EIP, go to the Instances page and click the target instance name. The EIP can be found in the EIP column in the Node Information area on the Basic Information page. If the instance you purchased has multiple nodes, select the EIP of any node. Figure 3 Viewing the EIP If no EIP is bound to the instance, bind an EIP to the instance by following Binding and Unbinding an EIP and then connect to the instance.
   <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>	Username of the instance administrator. 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.