Updating Managed Service for Trino cluster settings
If you have a Trino cluster in your project, you can update its settings.
Note
When you partially update settings, Managed Service for Trino recreates the cluster. While the new configuration is being applied, the cluster switches to Updating, and active queries get interrupted. For more information, see Updating a cluster.
-
Open the
TrinoClusterresource file, e.g., using theopen trinocluster.yamlcommand. -
Edit the following properties:
spec.version: Trino version. Use the value indicated inTrinoImageCatalog.spec.deletionProtection: Deletion protection. The possible values aretrueandfalse.spec.coordinator.resources.requests.cpu: Guaranteed number of CPUs for the coordinator pod.spec.coordinator.resources.requests.memory: Guaranteed RAM for the coordinator pod.spec.coordinator.resources.limits.cpu: Maximum number of CPUs for the coordinator pod.spec.coordinator.resources.limits.memory: Maximum RAM for the coordinator pod.spec.worker.replicas: Number of workers Minimum1.spec.worker.resources.requests.cpu: Guaranteed number of CPUs for the worker pod.spec.worker.resources.requests.memory: Guaranteed RAM for the worker pod.spec.worker.resources.limits.cpu: Maximum number of CPUs for the worker pod.spec.worker.resources.limits.memory: Maximum RAM for the worker pod.spec.config: Additional Trino settings. The available keys and values are defined in the validation schema for the relevant Trino version. The operator publishes the schema inConfigMaptrino-omdb-operator-<version>within its namespace. For example, theio.trinokey specifies a logging level (the possible values areDEBUG,INFO,WARN, andERROR).spec.accessControl: Access rules for catalogs, schemas, tables, functions, procedures, and queries. See Access management.
-
Apply the manifest:
kubectl apply -f trinocluster.yaml -n <namespace>. Optionally, you can specify the namespace in themetadata.namespaceresource property and skip it in the command.
-
If you have not opened a project yet, select one.
-
Select the namespace the cluster was created in.
-
In the left-hand menu, select Trino → Clusters.
-
Select a cluster.
-
Click Edit.
-
Edit the following fields:
Basic properties
- Trino version: Trino version from
TrinoImageCatalog. - Deletion protection: Toggle for protection against accidental deletion.
The Name field is read-only.
Coordinator configuration
- Requested CPU, Requested RAM: Requested resources for the coordinator pod.
- CPU limit, RAM limit: Maximum resources for the coordinator pod.
Worker configuration
- Number of workers: Number of worker pods.
- Requested CPU, Requested RAM: Requested resources for the worker pod.
- CPU limit, RAM limit: Maximum resources for the worker pod.
Additional settings
This is a section for adding, updating, and removing Trino settings. The key is read-only for existing rows; you can only change the value.
Access settings
This section configures access rules for the Catalog rules, Schema rules, Table rules, Function rules, Procedure rules, and Query rules subsections. The list of fields and privileges matches the cluster creation form.
- Trino version: Trino version from
-
Click Save.
This is it, your cluster settings have been updated.