Skip to main content

Scheduled Scaling

Scheduled Scaling changes a cluster's number of nodes at the times and on the days of the week that you configure. Use it for predictable workload peaks and low periods, such as regular business hours and overnight traffic.

Each rule specifies Day of week, Execution Time, and Number of Nodes. The node size and cache capacity per node stay the same. Total compute and cache capacity change with the number of nodes.

Warning:

  • During scaling, some connections might disconnect and reconnect intermittently.
  • Reducing the number of nodes reduces total cache capacity and can affect query response times.
  • Increasing the number of nodes can increase charges.

Rule requirements and behavior​

  • Configure at least one rule. You can configure up to 24 rules for a cluster.
  • Each rule must have a unique Execution Time. Keep at least one hour between rule execution times.
  • Select at least one Day of week for each rule.
  • You cannot use 0 as Number of Nodes.
  • If the execution time has already passed for the current day, the rule first runs at that time on the next selected day of the week.
  • A rule runs only while the cluster is Running. If the cluster is not Running, VeloDB Cloud retries the scheduled execution for up to 30 minutes and then skips that execution.

Before you begin​

  • You need permission to manage compute resources in the warehouse.
  • The cluster must be Running.
  • If Auto Scaling is enabled, select Auto Scaling in Scaling Mode and click Disable before configuring Scheduled Scaling.
  • Review the current node size, cache per node, and node count before choosing target counts.
  • Confirm the time zone shown next to Execution Time.

Create a schedule​

  1. Log in to the VeloDB Cloud console.

  2. In the upper-left corner, select the warehouse that contains the cluster.

  3. In the left navigation pane, under Compute, click Clusters.

  4. Click Physical Clusters.

  5. Click Card, then select the running cluster to open its details panel.

  6. Click Scaling. In Scaling Mode, select Scheduled Scaling.

  7. Review Node Size, Cache per Node, and Number of Nodes under Current Configuration.

  8. Under Target Configuration Range, configure the rule:

    FieldDescription
    Day of weekSelect the days from Monday through Sunday on which the rule should run.
    Execution TimeSet the time when the rule should run on the selected days. Use the time zone displayed in the console.
    Number of NodesSet the target number of nodes for the cluster.

  9. Click the checkmark icon to save the rule.

  10. To add another rule, click Add Rule, configure its days, execution time, and node count, then click the checkmark icon.

  11. Review the complete schedule, then click Confirm.

To verify the configuration, reopen Scaling Mode, select Scheduled Scaling, and check the saved rules.

When a rule changes the cluster's node count, the cluster status changes to Scaling and returns to Running when the resource change finishes. Verify the number of nodes and total compute and cache capacity in the cluster details panel.

Change a schedule​

  1. Open Scaling Mode for the cluster and select Scheduled Scaling.
  2. Edit a rule's Day of week, Execution Time, or Number of Nodes.
  3. Click the checkmark icon to save the rule.
  4. Review the updated schedule, then click Confirm.

Stop scheduled scaling​

  1. Open Scaling Mode for the cluster.
  2. Select Manual Scaling.
  3. Review the target configuration and click Confirm.

To replace the schedule with workload-based scaling, select Auto Scaling, configure the minimum and maximum node counts, and click Enable.

See also​

On This Page