Access the instance
Clients reach Alauda Data Services Analytical Database E1 through Services created by the operator, authenticating as users you declare in the instance spec.
TOC
ServicesPortsConnectingUsersThedefault user is restricted on purposeThe operator's own accountCluster shared secretFilesServices
Two kinds of Service are created by default:
Cluster-level and shard-level Services are not created unless you supply a clusterServiceTemplate or shardServiceTemplate. Without those templates no such object exists, so do not write client configuration against their names.
The instance-wide Service defaults to type LoadBalancer. On a cluster with no load balancer provider it will sit without an external address indefinitely. If you want in-cluster access only, override the type with a service template:
Port numbers in a service template are validated and must be between 1 and 65535.
Ports
Connecting
In-cluster, native protocol:
In-cluster, HTTP:
Targeting one specific host, for example to inspect a single replica:
Users
Users, profiles and quotas are declared under spec.configuration and rendered into the server's users.d directory. Settings under spec.configuration.settings are rendered into config.d instead.
The key syntax is path-like: everything before the first / is the user, profile or quota name, and the rest is the XML path beneath it. Repeat a key with a list value to emit multiple elements.
Produce a password hash with:
The default user is restricted on purpose
The shipped operator defaults give the default user the default profile, the default quota, and a network allow-list of ::1 and 127.0.0.1 only. It is therefore not usable from other pods. Declare your own user rather than loosening default.
The operator also adds a host regular expression to every account, matching the names of the instance's own pods. It is an extra allowance, not a second restriction: ClickHouse admits a connection that matches any entry under networks. It never blocks a connection that networks/ip allows, so restrict access by narrowing networks/ip.
The operator's own account
The operator connects to each server to read metrics, maintain schema and drop DNS caches. It uses its own account, whose credentials it reads from a Secret named in the operator configuration, over the HTTP port with short connect and query timeouts. Do not remove or repurpose that account: without it, schema propagation and metrics collection stop.
Cluster shared secret
Interserver communication inside a cluster can be authenticated with a shared secret, declared per cluster:
Create the Secret before the instance, in the same namespace, with any random value under the named key. The alternatives are value, which puts the secret into the instance manifest in plain text, and auto: "yes", which asks the operator to generate and store the value itself.
Do not use auto: "yes" on ACP. The operator's role grants only get and list on Secrets, so it cannot create the generated Secret; the pods then wait forever in CreateContainerConfigError with secret "<instance>-<cluster>-auto-secret" not found. Use secretKeyRef.
Files
Arbitrary configuration files can be injected with spec.configuration.files, where each key is a filename and the value is its content. Binary content is supported with the YAML !!binary tag. A filename may be prefixed to choose its destination directory — common, users, or host. Unknown prefixes and subfolders are ignored, so a file that never appears is usually a prefix typo.
ClickHouse is a registered trademark of ClickHouse, Inc. https://clickhouse.com
Alauda is an independent vendor. This product is not affiliated with, endorsed by, or sponsored by ClickHouse, Inc. All trademarks are the property of their respective owners and are used here for identification purposes only.