Advanced parameters for Aiven for ClickHouse®

See the configuration options available for Aiven for ClickHouse®:

Parameter
ip_filter array default: 0.0.0.0/0,::/0 IP filter Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
service_log boolean,null Service logging Store logs for the service so that they are available in the HTTP API and console.
static_ips boolean Use static public IP addresses
project_to_fork_from string,null Name of another project to fork a service from. This has effect only when a new service is being created.
private_access object Allow access to selected service ports from private networks private_access.clickhouse boolean Allow clients to connect to clickhouse with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations private_access.clickhouse_arrowflight boolean Allow clients to connect to clickhouse_arrowflight with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations private_access.clickhouse_https boolean Allow clients to connect to clickhouse_https with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations private_access.clickhouse_mysql boolean Allow clients to connect to clickhouse_mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations private_access.prometheus boolean Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations
privatelink_access object Allow access to selected service components through Privatelink privatelink_access.clickhouse boolean Enable clickhouse privatelink_access.clickhouse_arrowflight boolean Enable clickhouse_arrowflight privatelink_access.clickhouse_https boolean Enable clickhouse_https privatelink_access.clickhouse_mysql boolean Enable clickhouse_mysql privatelink_access.prometheus boolean Enable prometheus
public_access object Allow access to selected service ports from the public Internet public_access.clickhouse boolean Allow clients to connect to clickhouse from the public internet for service nodes that are in a project VPC or another type of private network public_access.clickhouse_arrowflight boolean Allow clients to connect to clickhouse_arrowflight from the public internet for service nodes that are in a project VPC or another type of private network public_access.clickhouse_https boolean Allow clients to connect to clickhouse_https from the public internet for service nodes that are in a project VPC or another type of private network public_access.clickhouse_mysql boolean Allow clients to connect to clickhouse_mysql from the public internet for service nodes that are in a project VPC or another type of private network public_access.prometheus boolean Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network
service_to_fork_from string,null Name of another service to fork from. This has effect only when a new service is being created.
recovery_basebackup_name string Name of the basebackup to restore in forked service
backup_hour integer,null max: 23 The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
backup_minute integer,null max: 59 The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
enable_ipv6 boolean Enable IPv6 Register AAAA DNS records for the service, and allow IPv6 packets to service ports
clickhouse_version string,null ClickHouse major version
tiered_storage_move_factor number max: 1 default: 0.2 Tiered storage move factor The percentage of free disk space required on local storage before data is moved to object storage. A value of 0.2 means data is moved when local storage has less than 20% free space.
server_settings object ClickHouse server settings, which can be found in the system.server_settings table. server_settings.vector_similarity_index_cache_size number max: 0.5 default: 0.07 vector_similarity_index_cache_size Fraction of total server memory allocated to the vector similarity index cache. 0 disables the cache. Default is 0.07 (7% of server memory). Only effective on ClickHouse 25.8+.
session_settings object ClickHouse session settings, which can be found in the system.settings table. session_settings.compatibility string,null When set, ClickHouse applies backward-compatible behavior from the specified version. Automatically set to the previous version on major version upgrade. Set to null to disable compatibility mode once all incompatibilities have been resolved. Takes effect after the next service restart/upgrade.