General questions about Managed Service for ClickHouse®
-
What part of database management and maintenance is Managed Service for ClickHouse® responsible for?
-
Which ClickHouse® version does Managed Service for ClickHouse® use?
-
How can I change the computing resources and storage size for a database cluster?
What is Managed Service for ClickHouse®?
Managed Service for ClickHouse® is a service that helps you create, operate, and scale ClickHouse® databases in a cloud infrastructure.
With Managed Service for ClickHouse®, you can:
- Create a database with the required performance characteristics.
- Scale processing power and storage dedicated for your databases as needed.
- Get database logs.
Managed Service for ClickHouse® takes on time-consuming ClickHouse® infrastructure administration tasks:
- Monitors resource usage.
- Automatically creates DB backups.
- Provides fault tolerance through automatic failover to backup replicas.
- Keeps database software updated.
You interact with database clusters in Managed Service for ClickHouse® the same way you interact with regular databases in your local infrastructure. This allows you to manage internal database settings to meet your app requirements.
What is ClickHouse® used for? Which database should I select?
ClickHouse® is designed primarily for analytics (OLAP) and only supports adding and reading data. You can update data but with limitations. For other purposes, you might want to use other managed DB services.
What part of database management and maintenance is Managed Service for ClickHouse® responsible for?
When creating clusters, Managed Service for ClickHouse® allocates resources, installs the DBMS, and creates databases.
For the created and running databases, Managed Service for ClickHouse® automatically creates backups and applies fixes and updates to the DBMS.
Managed Service for ClickHouse® also allows you to replicate data between database hosts (both within and across availability zones) and automatically routes the load to a backup replica in the event of a failure.
Which tasks are best addressed using Managed Service for ClickHouse®, and which using VMs with databases?
Yandex Cloud offers two ways to work with databases:
- Managed Service for ClickHouse® allows you to operate template databases with no need to worry about administration.
- Yandex Compute Cloud virtual machines allow you to create and configure your own databases. This approach allows you to use any database management systems, access databases via SSH, etc.
What is a database host and database cluster?
A database host is an isolated database environment in the cloud infrastructure with dedicated computing resources and reserved data storage.
A database cluster is one or more database hosts between which replication can be configured.
How do I get started with Managed Service for ClickHouse®?
Managed Service for ClickHouse® is available to any registered Yandex Cloud user.
To create a database cluster in Managed Service for ClickHouse®, you must define its characteristics:
- Host class (performance characteristics, such as CPUs, RAM, etc.).
- Storage size (reserved to the full extent when you create a cluster).
- Network your cluster will be connected to.
- Number of hosts for the cluster and the availability zone for each host.
For more information, see Getting started.
How many DB hosts can a cluster contain?
The minimum number of hosts depends on the selected type of storage:
- If you use non-replicated SSD storage, the minimum number of hosts is 3.
- If you use local SSD storage, the minimum number of hosts is 2.
- If using network HDD or network SSD storage, you can create single-host clusters.
The maximum number of hosts in a cluster is only limited by the requested computing resources and the size of the storage for the cluster.
For more information, see Quotas and limits.
How can I access a running DB host?
You can connect to Managed Service for ClickHouse® databases using standard DBMS methods.
Learn more about connecting to clusters.
How many clusters can I create within a single cloud?
For more information on MDB technical and organizational limitations, see Quotas and limits.
How are DB clusters maintained?
Maintenance in Managed Service for ClickHouse® implies:
- Automatic installation of DBMS updates and revisions for DB hosts (including disabled clusters).
- Changes to the host class and storage size.
- Other Managed Service for ClickHouse® maintenance activities.
For more information, see Maintenance.
How do I edit external dictionaries?
To rename a dictionary, run the query:
RENAME DICTIONARY <dictionary_name> TO <new_name>
For other changes, use the update API method.
Which ClickHouse® version does Managed Service for ClickHouse® use?
Managed Service for ClickHouse® uses some of the latest stable versions of ClickHouse®. For more information, see ClickHouse® versioning policy.
Which ClickHouse® version should I choose?
We recommend the latest available LTS version of ClickHouse®. For more information, see ClickHouse® versioning policy.
What happens when a new DBMS version is released?
When new minor versions are released, the cluster software is automatically updated after a short testing period.
Owners of the affected DB clusters are notified in advance about the maintenance work schedule and DB availability.
What happens when a DBMS version becomes deprecated?
When a DBMS version becomes deprecated, Managed Service for ClickHouse® automatically sends email notifications to the owners of database clusters created with this version.
New hosts can no longer be created using deprecated DBMS versions. Clusters on a deprecated version of ClickHouse® are updated according to the versioning policy.
Owners of the affected DB clusters are notified in advance about the maintenance work schedule and DB availability.
How do you calculate usage cost for a database host?
In Managed Service for ClickHouse®, the usage cost is calculated based on the following parameters:
- Selected host class.
- Size of the storage reserved for the database host.
- Size of the database cluster backups. Backup space in the amount of the reserved storage is free of charge. Backup storage that exceeds this size is charged at special rates.
- Number of hours of database host operation. Partial hours are rounded to an integer value. You can find the cost per hour of operation for each host class in Pricing policy.
How much does it cost to use my cluster?
In the management console, go to the folder page, select Managed Service for ClickHouse and click the appropriate cluster. The cost of your cluster usage per month will be shown on the right side of the screen. For more information, see Pricing policy.
How can I change the computing resources and storage size for a database cluster?
You can change computing resources and storage size in the management console. All you need to do is choose a different host class for the required cluster.
The cluster characteristics change within 30 minutes. During this period, other maintenance activities may also be enabled for the cluster, such as installing updates.
Does the service meet the requirements under Russian Federation Federal Law No. 152-FZ on Personal Data
?
Yes, it does. You can read the full security audit conclusion.
Can I get logs of my operations with services?
Yes, you can request log records about your resources from Yandex Cloud services. For more information, see Data requests.
ClickHouse® is a registered trademark of ClickHouse, Inc.