Uptime schedules allow users to shut off ClickHouse servers automatically on a schedule or after a period of inactivity. It’s an easy way to reduce the bill for servers that are used intermittently. When the server is shut down, Altinity.Cloud does not bill you for server compute resources or support. Storage (including backups) is still billed.
All users who have access to the cluster dashboard may access uptime schedules.
Important note! Uptime schedules are intended for ClickHouse clusters that only operate intermittently. Do not enable them for production clusters that operate continuously. Doing so may cause the ClickHouse server to stop unexpectedly, creating a potential service outage.
Accessing Uptime Schedules
To set up an uptime schedule open the cluster dashboard and select Uptime Schedule from the CONFIGURE menu. The Clusters View page allows you to view available clusters and access your profile settings.
Clusters with an active uptime schedule will also have a stopwatch icon beside the cluster name on the dashboard panel. You can access the uptime schedule by clicking on the icon.
If there is no icon, it means that no uptime schedule is currently active.
Regardless of how you access the uptime schedule, you will see a popup window that shows the current status. The default setting is ALWAYS ON, which means the cluster operates continuously.
Stopping Servers after a Period of Inactivity
Select STOP WHEN INACTIVE to configure the cluster to stop after a period of inactivity. For example, you may stop clusters after two hours of inactivity. This is a useful setting for development servers. Choose your desired inactivity period. Press CONFIRM to save the setting.
Once the server becomes inactive, you must restart it manually using the ACTIONS->RESUME on the cluster dashboard.
Stopping Clusters on a Schedule
You may also configure clusters to run on a schedule using the ON SCHEDULE tab. The following example shows how to configure a server to run 24 hours on Monday, Wednesday, Friday and 8am to 5pm on Tuesday, Thursday. Note that the time zone is GMT, so you’ll need to convert your local time zone to GMT values. Press CONFIRM to save the schedule.
Was this page helpful?
Glad to hear it!
Sorry to hear that. We'll track this issue and see how we can improve.