Create a Clickhouse Instance from the Neevcloud Marketplace
PreviousCreate a Ubuntu RDP Instance from the Neevcloud MarketplaceNextCreate an OpenLiteSpeed WordPress Instance from the NeevCloud Marketplace
Last updated
Last updated
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.
To navigate the App, then Select Clickhouse and Choose the version.
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.
Choose the volume size which will be your root disk,
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.
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.
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.
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.
To verify clickHouse_Setup_defaults.txt, run the following commands:
Clickhouse
Start the Clickhouse server
and connect with the Clickhouse client using a password.
