Cluster details
Here all the details about the cluster are displayed:
- Cluster name
- Provider
- AWS or GCP
- Self-hosted
- Whether the cluster is deployed on Gigapipe's infrastructure, or directly on your own
- Region
- Where geographically the cluster is situated
- Number of shards
- Number of replicas
- Machine type
- Number of CPUs per node
- Amount of RAM per node
- Disk #X
- Number of the discs, their type and the volume
- Available disk space on each disk – current volume available / total
- Rows
- Current number of the rows stored in all tables
- Created
- Date and time (local) the cluster was created
- Status
- The current status of the ClickHouse cluster (Active, scaling, updating, deleting etc)
- ClickHouse Endpoint
- Click here to test the ready state of the ClickHouse cluster (active cluster returns an ‘OK’ message. The URL of this page is the ClickHouse endpoint
- If you wish to connect directly to the ClickHouse endpoint, either copy the URL or right click and ‘copy link address’
- Grafana Endpoint
- CLick ‘Launch Grafana’ to launch the regional instance of Grafana. You can then login using your Gigapipe account login credentials (or login via Google)
- ClickHouse version
- This is the current version of ClickHouse deployed on the cluster. You can change your ClickHouse version up or down whenever you need to
📄️ Deactivating/reactivating clusters
You can temporarily deactivate your cluster (cluster charges will stop) but retain the existing data for use at a later date. You do this by using the ‘deactivate’ functionality. Gigapipe will turn off all existing nodes, but retain the live disks containing your data. You won’t be able to ingest data or query anything, however if you wished to regain access to this data at a later date, you can ‘reactive’ the cluster at anytime and continue where you left off.
📄️ Change ClickHouse version
Gigapipe supports cross version clusters. This means you can pick whichever stable (supported) version you would like when creating the cluster. Here is a list of currently supported versions.
📄️ Deleting clusters
To permanently delete an existing cluster, you may use the “Delete Cluster” function on the cluster details page. This will delete all nodes, pods and data from the cluster.
📄️ Querying the database
You may query the database either through the Gigapipe UI using the SQL query builder, or by connecting to ClickHouse directly yourself through the endpoint.
📄️ Materlialized Views
Any select query can be automatically saved as a materialized view by clicking on the “Save query as view” button just below the SQL query builder box, next to “Run query” button.
📄️ Change machine types
In Gigapipe you can scale both horizontally (adding more nodes) and vertically (more powerful machines on each node).
📄️ Scaling a cluster
In Gigapipe you can scale both horizontally (more powerful machines on each node) and vertically (adding more nodes).
📄️ Importing data from S3
The Amazon S3 importer will allow you to import data (buckets) directly from Amazon S3 into your managed ClickHouse cluster.
📄️ Scale & add disks
Once a cluster has been created, the existing disks can be expanded at any time either manually, or by enabling the auto-scaling disks feature.