ClickHouse Usage Process
ClickHouse is a columnar database oriented to online analysis and processing. It is independent of the Hadoop big data system and features compression rate and fast query performance. In addition, ClickHouse supports SQL query and provides good query performance, especially the aggregation analysis and query performance based on large and wide tables. The query speed is one order of magnitude faster than that of other analytical databases. CloudTable ClickHouse cluster management also provides the following functions:
In ClickHouse cluster management, you need to create a dedicated cluster and can use it on demand. Dedicated clusters are physically isolated and are not affected by other services, facilitating user management.
After the ClickHouse cluster is created, use the client to access the cluster. For details, see the following sections.
- Preparing an ECS.
- Using a Client to Access a ClickHouse Cluster.
- ClickHouse Commands.
Table 1 ClickHouse usage process Step
Substep
Description
Detailed Instructions
Preparations
Creating a user and granting permissions to use CloudTable
- Before using CloudTable ClickHouse, you need to register a Cloud account and grant the necessary permissions to your account.
- Grant the necessary service permissions to a user group, and then add users to this group to enable their access.
Creating a cluster
Creating a ClickHouse cluster
Before using ClickHouse to execute tasks, you need to create a ClickHouse cluster.
Downloading the client
Downloading the ClickHouse client
After creating a cluster, download and install the client. After the client is installed, you can use the SSH tool to connect to the cluster.
Preparing an ECS
-
If the client tool runs on Linux, you need to prepare a Linux ECS that is in the VPC as a ClickHouse cluster and the Linux ECS serves as a client host.
If the client tool runs on Windows, you need to prepare a Windows ECS that is in the VPC as a ClickHouse cluster and the Windows ECS serves as a client host.
Installing the client
-
Place the downloaded client on the ECS, decompress the package, and install the client.
Connecting to the cluster
-
After installing the MySQL client on the ECS, you can run commands to connect to the cluster and perform service operations.