Create a Clickhouse Instance from the Neevcloud Marketplace

Create a Clickhouse Instance

ClickHouse is an open-source columnar database management system (DBMS) for online analytical processing (OLAP). It allows for real-time data analysis with capabilities for handling large volumes of data in a highly performant and efficient manner.

Navigate to the Neevcloud dashboard, select Server, and click Create Cloud Server.

Select Image

Select the Marketplace

To navigate the App, then Select Clickhouse and Choose the version.

Hardware Configuration

Users can choose different CPU and RAM configurations to personalize their system. General Purpose and Memory Optimized, CPU Optimized, GPU Enabled, and Smart Servers are the options that are offered. Click these links for further information.

Select the volumes

Choose the volume size which will be your root disk,

Network configuration

• Public Network:- A public network is a type of network that is open and accessible to anyone, allowing users to connect freely. If you select a public network, you must configure it to allow public access to your server.

• Private Network:- A private network is accessible only to specific individuals or organizations, ensuring that the general public cannot connect to it. If you choose a private network, you must first create a Private network.

Authentication

• SSH_KEY:- An SSH KEY is a source access credential used in the Secure Shell(SSH) protocol, consisting of a pair of public and private keys that authenticate users and establish encrypted communication between a client and a server. it would be best if you had to create an SSH key to access your server.

Access to your server requires an SSH_KEY. It is mandatory

• Password:- A password is a secret string of characters used to verify a user's identity and grant access to a system or resource

To create a secure password with 10 characters, including symbols, Use a mix of uppercase and lowercase letters, Include numbers, and add special characters like !, $, #, etc. Avoid using easily guessable info like names or birthdates.

Generating SSH KEY

If you already have an SSH key, select it. If you don't have one, please follow this link to generate an SSH key.

Add Security Group

Click on Add Security Group. Ensure the required ports for Clickhouse are allowed.

Enter the server name > Click 'Create Server'

Once your instance is created the status will change to Active, and other details will be shown.

SSH

Now How to access the Clickhouse server follow these steps, First access the server via SSH using your SSH_key, also, if you want to access it by using Putty follow these links. Open the command prompt and navigate to the directory where you downloaded the SSH files.

NOTE: if your SSH is not functioning, so you have to set the permission.

cd .\Downloads\

ssh -i  your_ssh_key  ubuntu@your_server_IP_add

To verify clickHouse_Setup_defaults.txt, run the following commands:

Clickhouse

cat ClickHouse_Setup_Details.txt

Start the Clickhouse server

sudo clickhouse start

and connect with the Clickhouse client using a password.

sudo clickhouse-client --password