Updating Greenplum® cluster settings
After creating a cluster, you can:
To move a cluster to a different availability zone, restore it from a backup. While restoring the cluster, specify a new availability zone. You will thus move the cluster hosts.
If you use external data sources for PXF operations, learn how to configure the protocol. This will allow you to optimize operations with external data.
Change the cluster name and description
- Go to the folder page
and select Managed Service for Greenplum. - Select the cluster and click Edit cluster at the top of the page.
- Under Basic parameters, enter a new name and description for the cluster.
- Click Save.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To change the name and description of a Greenplum® cluster:
-
View the current name (
name
) and description (description
) of the cluster:yc managed-greenplum cluster get <cluster_name_or_ID>
-
View a description of the update cluster configuration CLI command:
yc managed-greenplum cluster update --help
-
Enter a new name and description for the cluster:
yc managed-greenplum cluster update <cluster_name_or_ID> \ --new-name <new_cluster_name> \ --description <new_cluster_description>
To change a cluster's name and description, use the update REST API method for the Cluster resource or the ClusterService/Update gRPC API call and provide the following in the request:
- Cluster ID in the
clusterId
parameter. To find out the cluster ID, get a list of clusters in the folder. - A new name in the
name
parameter. - A new description in the
description
parameter. - List of cluster configuration fields to update in the
updateMask
parameter (in this case,name
anddescription
).
Warning
This API method overrides all parameters of the object being modified that were not explicitly passed in the request to the default values. To avoid this, list the settings you want to change in the updateMask
parameter (one line separated by commas).
Change the public access setting
- Go to the folder page
and select Managed Service for Greenplum®. - Select the cluster and click Edit cluster at the top of the page.
- Under Network settings, enable or disable Public access.
- Click Save.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To change the public access setting Greenplum®:
-
View a description of the update cluster configuration CLI command:
yc managed-greenplum cluster update --help
-
Configure public access in the
--assign-public-ip
parameter:yc managed-greenplum cluster update <cluster_name_or_ID> \ --assign-public-ip=<public_access_to_cluster>
Where
assign-public-ip
is public access to the cluster, true or false.
Use the update API method and include the following in the request:
- Cluster ID in the
clusterId
parameter. To find out the cluster ID, get a list of clusters in the folder. - Public access setting in the
config.assignPublicIp
parameter. - List of cluster configuration fields to update in the
updateMask
parameter (in this case,name
anddescription
).
Warning
This API method overrides all parameters of the object being modified that were not explicitly passed in the request to the default values. To avoid this, list the settings you want to change in the updateMask
parameter (one line separated by commas).
Tip
If you enabled public access to the cluster but cannot access it from the internet:
- Check the security group settings.
- Wait a while. It may take some time to enable public access.
Changing additional cluster settings
-
Go to the folder page and select Managed Service for Greenplum.
-
Select the cluster and click Edit cluster in the top panel.
-
Change additional cluster settings:
-
Backup start time (UTC): Time interval during which the cluster backup starts. Time is specified in 24-hour UTC format. The default time is
22:00 - 23:00
UTC. -
Maintenance window: Maintenance window settings:
- To enable maintenance at any time, select arbitrary (default).
- To specify the preferred maintenance start time, select by schedule and specify the desired day of the week and UTC hour. For example, you can choose a time when the cluster is least loaded.
Maintenance operations are carried out both on enabled and disabled clusters. They may include updating the DBMS, applying patches, and so on.
-
DataLens access: Allows you to analyze cluster data in Yandex DataLens.
-
Data Transfer access: Enable this option to allow access to the cluster from Yandex Data Transfer in Serverless mode.
This will enable you to connect to Yandex Data Transfer running in Kubernetes via a special network. It will also cause other operations to run faster, such as transfer launch and deactivation.
-
Deletion protection: Manages protection of the cluster, its databases, and users against accidental deletion.
Enabled deletion protection will not prevent a manual connection with the purpose to delete database contents.
-
Hybrid storage: Activates the Yandex Cloud Yezzey extension
. This extension is used to export AO and AOCO tables from disks within the Managed Service for Greenplum® cluster to cold storage in Yandex Object Storage. This way, the data will be stored in a service bucket in a compressed and encrypted form. This is a more cost-efficient storage method.You cannot disable this option after you save your cluster settings.
Note
This functionality is at the Preview stage and is free of charge.
-
Connection pooler: Operation mode and parameters of the connection pooler:
- Mode:
SESSION
(default) orTRANSACTION
. - Size: Maximum number of client connections.
- Client Idle Timeout: Client idle time (in ms), after which the connection will be terminated.
- Mode:
-
-
Click Save.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To change additional cluster settings:
-
View a description of the update cluster CLI command:
yc managed-greenplum cluster update --help
-
Run the following command with a list of settings to update:
yc managed-greenplum cluster update <cluster_name_or_ID> \ --backup-window-start <backup_start_time> \ --datalens-access=<access_from_DataLens> \ --datatransfer-access=<access_from_Data_Transfer> \ --maintenance-window type=<maintenance_type>,` `day=<day_of_week>,` `hour=<hour> \ --assign-public-ip=<public_access_to_cluster> \ --deletion-protection=<cluster_deletion_protection> \
You can change the following settings:
--backup-window-start
: The cluster backup start time, set in UTC formatHH:MM:SS
. If the time is not set, the backup will start at 22:00 UTC.
-
--datalens-access
: Enables Yandex DataLens access. The default value isfalse
. -
--datatransfer-access
: Enables Yandex Data Transfer access. The default value isfalse
. -
--maintenance-window
: Settings for the maintenance window (including those for disabled clusters), wheretype
is the maintenance type:anytime
(default): Any time.weekly
: On a schedule. If setting this value, specify the day of week and the hour:day
: Day of week inDDD
format:MON
,TUE
,WED
,THU
,FRI
,SAT
, orSUN
.hour
: Hour (UTC) inHH
format:1
to24
.
-
--assign-public-ip
: Cluster accessibility from the internet. -
--deletion-protection
: Protection of the cluster, its databases, and users against accidental deletion,true
orfalse
.Enabled deletion protection will not prevent a manual connection with the purpose to delete database contents.
You can retrieve the cluster name with a list of clusters in the folder.
To change additional cluster settings, use the update REST API method for the Cluster resource or the ClusterService/Update gRPC API call and provide the following in the request:
-
Cluster ID in the
clusterId
parameter. To find out the cluster ID, get a list of clusters in the folder. -
Public access settings in the
config.assignPublicIp
parameter. -
Backup window settings in the
config.backupWindowStart
parameter. -
Settings for access from Yandex DataLens, in the
config.access.dataLens
parameter. -
Settings for the maintenance window (including those for disabled clusters) in the
maintenanceWindow
parameter. -
Cluster deletion protection settings in the
deletionProtection
parameter.Enabled deletion protection will not prevent a manual connection with the purpose to delete database contents.
-
List of cluster configuration fields to update in the
UpdateMask
parameter.
Warning
This API method overrides all parameters of the object being modified that were not explicitly passed in the request to the default values. To avoid this, list the settings you want to change in the updateMask
parameter (one line separated by commas).
Editing the scheduled maintenance operations settings
You can edit your cluster's scheduled maintenance operations settings.
-
Go to the folder page and select Managed Service for Greenplum.
-
Select the cluster and click Edit cluster in the top panel.
-
Under Managing background processes, change the parameters:
- Start time (UTC):
VACUUM
start time. The default value is19:00 UTC
. Once theVACUUM
operation is completed, theANALYZE
operation starts. - VACUUM timeout: Maximum
VACUUM
execution time, in seconds. Valid values: from7,200
to86,399
, with36,000
by default. As soon as this period expires,VACUUM
will be forced to terminate. - ANALYZE timeout: Maximum
ANALYZE
execution time, in seconds. Valid values: from7,200
to86,399
, with36,000
by default. As soon as this period expires, theANALYZE
operation will be forced to terminate.
The combined
VACUUM
andANALYZE
execution time may not exceed 24 hours. - Start time (UTC):
-
Click Save.
To edit your cluster's scheduled maintenance operations settings, use the REST API update method for the Cluster resource or the ClusterService/Update gRPC API call, and provide the following in the request:
-
Cluster ID in the
clusterId
parameter. To find out the cluster ID, get a list of clusters in the folder. -
New parameter values for the
configSpec.backgroundActivities.analyzeAndVacuum
object:start.hours
: Start hour of theVACUUM
operation in UTC. Valid values: from0
to23
, with19
by default.start.minutes
: Start minute of theVACUUM
operation in UTC. Valid values: from0
to59
, with0
by default.vacuumTimeout
: Maximum duration of theVACUUM
operation, in seconds. Valid values: from7,200
to86,399
, with36,000
by default. As soon as this period expires,VACUUM
will be forced to terminate.analyzeTimeout
: Maximum duration of theANALYZE
operation, in seconds. Valid values: from7,200
to86,399
, with36,000
by default. As soon as this period expires, theANALYZE
operation will be forced to terminate.
-
List of cluster configuration fields to update in the
UpdateMask
parameter.
Warning
This API method overrides all parameters of the object being modified that were not explicitly passed in the request to the default values. To avoid this, list the settings you want to change in the updateMask
parameter (one line separated by commas).
Changing Greenplum® settings
You can change the DBMS settings of the hosts in your cluster.
- Go to the folder page and select Managed Service for Greenplum.
- Select the cluster and click Edit cluster in the top panel.
- Change the Greenplum® settings by clicking Settings under DBMS settings.
- Click Save.
- Click Save.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To change the Greenplum® DBMS settings:
-
View the full list of settings specified for the cluster:
yc managed-greenplum cluster get <cluster_name_or_ID>
-
View a description of the update cluster configuration CLI command:
yc managed-greenplum cluster update-config --help
-
Set the required parameter values:
All supported parameters are listed in the request format for the update method, in the
greenplumConfig_<Greenplum_version>
field. To specify a parameter name in the CLI call, convert the name fromlowerCamelCase
tosnake_case
. For example, themaxConnections
parameter from an API call must be converted tomax_connections
for the CLI command:yc managed-greenplum cluster update-config <cluster_name_or_ID> \ --set <parameter_1_name>=<value1>,<parameter_2_name>=<value2>,...
Managed Service for Greenplum® runs the update cluster settings operation.
To change Greenplum® settings, use the update REST API method for the Cluster resource or the ClusterService/Update gRPC API call and provide the following in the request:
-
New settings in the
configSpec.greenplumConfig_<version>
parameter. -
List of cluster configuration fields to update in the
updateMask
parameter.Warning
This API method overrides all parameters of the object being modified that were not explicitly passed in the request to the default values. To avoid this, list the settings you want to change in the
updateMask
parameter (one line separated by commas).
Increasing storage size
Make sure the cloud has enough quota to increase the storage size. Open the cloud's Quotas
To increase the cluster storage size:
- In the management console
, select the folder with the cluster you need. - Select Managed Service for Greenplum.
- Select the cluster you need.
- At the top of the page, click Edit cluster.
- Edit the settings in the Storage section.
- Click Save.
To increase the cluster storage size, use the update REST API method for the Cluster resource or the ClusterService/Update gRPC API call and provide the following in the request:
- Cluster ID in the
clusterId
parameter. To find out the cluster ID, get a list of clusters in the folder. - New master and segment host storage size in the
masterConfig.resources.diskSize
andsegmentConfig.resources.diskSize
parameters. - List of cluster configuration fields to update in the
UpdateMask
parameter.
Warning
This API method overrides all parameters of the object being modified that were not explicitly passed in the request to the default values. To avoid this, list the settings you want to change in the updateMask
parameter (one line separated by commas).
Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.