Altinity Cloud Manager Release Notes - Older releases

These are the release notes for older versions of Altinity Cloud Manager. You can go directly to a particular release through one of these links:

2024

2023

2022

2021

2020

24.7.39

Released 2025-01-02

Added

  • New ‘Clone’ action allows users to clone a cluster and all configuration settings under a different name (Cluster)
  • Preferred replica can now be configured for a backup (Cluster)
  • An Environment can now be exported to a Terraform script (Environment)
  • ClickHouseOperatorConfiguration resources can be accessed directly now (Environment)
  • New signup screen

Changed

  • Cost allocation tags UI has been improved (Environment)
  • DBA Tools -> Cleanup storage UI has been improved (Cluster)
  • Resources pie charts on the Environment screen have been improved (Environment)
  • In the pending changes screen, the user name is now displayed (Cluster)
  • When configuring ZooKeeper, the custom root path is used now by default (Cluster)
  • Modification time is added to the list of detached parts in DBA tools (Cluster)

Fixed

  • Alternate DNS names can now be used with internal subdomain (Cluster)
  • ON CLUSTER queries are now handled correctly for table names containing whitespaces (Cluster)
  • Cluster Export/Import now respects Datadog configuration properly (Cluster)
  • Fixed UI issues for users that do not have any environments available
  • Fixed a race condition with restoring a cluster from a backup from a non-standard backup location, when restore could start before the configuration is applied (Cluster)

24.6.29

Released 2024-11-18

Added

  • New Cleanup Storage tool in DBA tools (DBA Tools)
  • MySQL protocol can be enabled for BYOC environments under private network (Cluster)
  • Okta roles mapping is now available for users in Login Settings (Organization)
  • Anywhere environments can be exported into Terraform configuration (Environment)
  • Node taints are now displayed (Environment)
  • Restore a specific table partition from a backup (Cluster)
  • Hetzner Cloud support (Cluster)

Changed

  • Availability Zones can now be selected when re-scaling cluster
  • Deleted cluster and user names are preserved in Audit log now (Organization)
  • Cluster->Configure menu has been reordered (Cluster)
  • Kafka Connections is not a part of cluster configuration. Multiple connections are supported (Cluster)
  • Altinity user is now managed by RBAC. That makes changes of Altinity access instant
  • Environment backup settings can only be changed for BYOK environments. Contact Altinity support if you need to change for other types. (Environment)

Fixed

  • Fixed resuming the cluster if node type has been changed
  • Fixed Test Connection button that was not available for users

24.5.31

Released 2024-10-03

Added

  • Added Okta role mappings for envsupport and grafana roles
  • Added an option to configure custom label for availability zone separation

Fixed

  • Fixed a bug with re-scale on schedule that did not trigger node type change correctly
  • Fixed a bug where SaaS environments provisioned using Anywhere stack were displayed as BYOC
  • Fixed a bug where users logging in with Okta are denied access sometimes

24.5.25

Released 2024-09-17

Added

  • Added the new 2FA option for password logins that validates login using security code from email (Organization)
  • Added an option to configure default user role and ‘Opened’ mode in Login Settings (Organization)
  • Added an option to use S3 compatible non-AWS storage for backups (Environment)
  • Added cost estimate when re-scaling a cluster (Cluster)
  • Added configurable query timeout in Explorer (Cluster)

Changed

  • Improved flexibility of availability zones configuration for BYOC/BYOK (Environment)
  • Proper tolerations are prepopulated now on BYOC nodes (Environment)
  • Environments can now be deleted with 2FA via email confirmation (Environment)
  • Alert user if EBS params controller is missing in AWS BYOK environment (Storage)
  • Improved conversion procedure from non-replicated to ReplicatedMergeTree table (DBA Tools)

Fixed

  • Fixed a bug that allowed user to bypass Okta and use password login in some cases (Organization)
  • Fixed a bug that did not allow to re-scale cluster, i.e. change a node type, until cluster is online (Cluster)
  • Fixed a bug that could result in cluster online status to be stale for several minutes (Cluster)
  • Fixed a bug that allowed to scale cluster volumes over 16TB that is not supported by AWS/GCP (Storage)
  • Fixed a bug that did not allow to free a cordoned volume properly before deleting (Storage)
  • Fixed a bug that could cause Kafka tables not properly restarted (Workload)
  • Fixed a bug that did not allow to use non-letter characters in backup inclusion and exclusion rules (Backup)
  • Fixed a bug that did not allow to create table on all nodes when table name contained non-alphanumeric characters (DBA Tools)

24.4.20

Released 2024-07-24

Added

  • Cloud-specific cost allocation tags can be configured for BYOC environments now
  • Annotations can now be specified for ClickHouse® clusters. Those can be useful in some BYOK environments.
  • Infrequent access tier is now used for backups on S3 that are stored more than 2 weeks (e.g. weekly and monthly)
  • New environment creation wizard and numerous improvements for Anywhere environments configuration

Changed

  • Backup operations are now enabled for env admins
  • XML configuration files are now validated for XML correctness
  • It is now allowed to have two payment methods for one account, e.g. credit card and marketplace
  • Performance for Schema and Kafka tabs was improved
  • Increased the number of IP addresses that can be used in IP whitelisting. Now it is more than 200.
  • Improved Zookeeper deployment manifests

Fixed

  • Fixed compatibility issues with 24.3+ ClickHouse versions
  • Fixed a bug when two settings with the same key could be entered
  • Fixed display of query results in Explorer for ClickHouse versions 24.3 and above
  • Added PodDisruptionBudget back for Zookeeper that had been incidentally removed in earlier releases
  • Billing data is now correctly displayed when there are multiple organizations with the same domain name

24.3.30

Released 2024-05-28

Added

  • New Audit Report functionality in DBA Tools
  • Secret references can be used for all server configuration settings now
  • Added list view for Nodes
  • Added tax configuration to the billing
  • When cluster is rescaled from 1 to more replicas, users are warned about existing non-replicated tables and suggested to convert those to replicated ones
  • Last Login column has been added to the Accounts view
  • Maintenance Window configuration is now available

Changed

  • Improved configuration of node types for Anywhere clusters
  • Improved performance of starting up clusters with a lot of data
  • Red icon is displayed if cluster is open to the public Internet
  • Backup infrastructure deployment has been improved to avoid unnecessary restarts. After this release no new restarts will be needed.
  • Backup and object storage for ClickHouse® data is now displayed separately in usage details and invoices
  • When cluster is restored from a backup, node/storage/version is properly retrieved from a source cluster
  • Added extra checks when restoring a cluster from a backup to avoid incorrect restore
  • Enabled multiple include/exclude table/engine filters when restoring a cluster from a backup

Fixed

  • Fixed the ClickHouse version inconsistency display during version upgrades
  • Fixed a bug with new Anywhere environments configuration that could be configured to incorrect Kubernetes namespace sometimes
  • Fixed a bug with Anywhere BYOC AWS setup did not prepopulate default node groups and storage classes
  • Fixed a bug when ClickHouse users could not be managed properly via UI in certain cases
  • Anywhere users can subscribe to alerts finally. It did not work before.
  • Several backup actions can not be executed in parallel for the same cluster anymore, since it could lead to errors
  • Fixed a bug when Publish on a stopped cluster unexpectedly resume it

24.2.25

Released 2024-04-03

Added

  • Enabled integration with Prometheus and Loki, for example Grafana Cloud
  • Added an option to configure logs retention period for Anywhere clusters
  • Added a new workload page for Kafka consumers
  • The trial expiration is set to 14 days from the first user login
  • Added an option to export a cluster as CHI yaml manifest
  • Enabled cluster audit logs for envadmins

Changed

  • Import dataset feature is improved to work properly on replicated clusters
  • When restoring a cluster from a backup, source cluster node type and version is preselected now
  • Clusters list view is improved

Fixed

  • Fixed a bug when new environment could not be created if user’s first or last name is not defined
  • Fixed a bug when envuser could not change Altinity Access for the cluster
  • Fixed Environment screen rendering for mobile devices
  • Fixed display of running queries and replication queue on heavy loaded servers
  • Fixed a bug when availability zones would be applied in the wrong order in rare cases
  • Fixed a bug when adding unsupported node type was silently ignored. Now error is returned
  • Fixed a bug when backup costs were not included to cost by day charts
  • Fixed a bug when node view could not be open on inactive/failed node
  • Fixed a bug when converting non-replicated to ReplicatedMergeTree table on a multi-node cluster could result in inconsistent data
  • Fixed a bug when errors could be ignored when running multi-statement queries in Explorer

24.1.21

Released 2024-02-15

Added

  • ‘Uptime Schedule’ is renamed to ‘Activity Schedule’. It now allows to specify an instance type for inactive time, scaling down cluster in low hours automatically
  • GCP Marketplace integration is added. GCP Marketplace is available as a payment method
  • Display a message that cluster is connected to the remote backup bucket
  • When external custom domain is configured instructions for DNS configuration are now displayed
  • Discounts are now applied to the current period. Previously, discounts were only applied to generated invoices for the previous months
  • Added an option to select ZooKeeper node type when launching a new cluster if multiple node types are configured for ZooKeeper

Changed

  • Upgraded clickhouse-operator to from 0.22.1 to 0.23.1 version release notes
  • Upgraded clickhouse-backup from 2.4.6 to 2.4.31 version release notes
  • Better progress is displayed when provisioning the BYOK/BYOC environments
  • Removed redundant fields from Cluster Launch Wizard
  • Allow to start volume modification if previous modification is still in progress
  • Improved performance of listing backups

Fixed

  • Fixed restart behaviour when server settings are changed. Previously, cluster would not restart sometimes when needed.
  • Fixed a number of issues when updating and removing volumes in multi-volume clusters
  • Fixed a bug when ZooKeeper cluster size was not respected when stopping/starting ClickHouse® cluster
  • CPU/RAM settings for unknown node type are now preserved (BYOK)

23.7.37

Released 2023-12-12

Added

  • New users except ‘admin’ are now created in SQL with CREATE USER
  • SQL users can be used in Explorer
  • RBAC data (SQL users) are stored in and restored from a backup
  • Allow to export table level statistics (sizes, row counts) to the Datadog
  • Default On/Off switch for Datadog configuration
  • Allow to switch On/Off zone awareness routing to ClickHouse® nodes
  • Allow to restore selected tables or database engines from a backup
  • Cloud regions are automatically pre-populated for Anywhere environments
  • Azure support

Changed

  • IP whitelisting is enabled by default for new cluster. User IP is detected.
  • Named collection control is enabled for admin
  • Improvements to managing AWS volumes. Allow to change volume type
  • “Copy Data between Clusters” now allows the external destination
  • Added validation for node type configuration
  • Improved performance of test datasets loading
  • Usability improvements on Workload tab
  • System events are now hidden in Audit log by default, but can be shown using a switch

Fixed

  • Fixed a bug when System node pool could not be managed from ACM
  • Fixed a bug when node endpoint was not accessible under custom domain name

23.6.37

Released 2023-10-24

Added

  • Tiered storage support for EBS/PD volumes
  • Allow to free and remove disks in multi-volume configuration
  • Alert user is cluster is stopped for more than 30 days
  • New Monitoring role for Grafana access only
  • New Env Support role for accessing clusters without destructive actions
  • Access token for Anywhere API
  • Map Octa roles to ACM roles
  • Added Azure as a backup destination option
  • Added on screen notification when ClickHouseInstallation templates are used
  • Added on screen notification when cluster is connected to other cluster’s backup and a way to reset it
  • Added cluster lock feature to prevent accidental changes
  • Added an option to restore a table from the backup to a different database
  • Added alternate DNS names to Connection Details popup
  • Enabled storage of UDF metadata in ZooKeeper for ClickHouse® 23.3 and above
  • Added ‘Enabled object labels’ option to backup settings
  • Added new ‘Setup Environment’ wizard
  • Added AWS Marketplace integration

Changed

  • Do not allow to start a cluster without CPU cores configured for a node type
  • Made a link ClickHouse release notes more visible
  • Clicking to Upgrade advisory icon now opens up an Upgrade screen
  • Success/Failure notifications are not sent to both user who started the process and cluster owner
  • Improved setting up BYOC Anywhere clusters UI

Fixed

  • Fixed a bug when load balancer status for a node was not properly changed and displayed
  • Fixed a bug with KILL MUTATION that might not work in some cases
  • Fixed a bug when Kafka Connection wizard could trigger the cluster update
  • Fixed default ZooKeeper storage class
  • Fixed a Back button navigation from Nodes screen
  • Fixed a bug when launching cluster from a backup could use incorrect CPU/RAM requests

23.5.15

Released 2023-08-15

Added

  • Environment audit logs, available for env and org admins
  • Org admins can now configure login settings
  • Allow to login with password for org admins even if passwords access is disabled for organization
  • Cluster role

Changed

  • Distributed queries are now handled using ‘secret’ to authenticate between nodes
  • Changed description of available login option to make it more clear

Fixed

  • Fixed an inconsistent display of storage usage across nodes that happens sometimes
  • Fixed storage throughput calculation that was sometimes incorrect

23.4.36

Released 2023-07-25

Added

  • Access change reason to Altinity Access
  • Startup time option for slow starting clusters
  • Storage management for supporting multiple volumes in a more flexible way
  • Management of auto templates for Anywhere environments
  • History of cluster setting is now preserved, and it allows to rollback
  • Stop button when rebalancing disks

Changed

  • Added DataDog and Loki logs configuration on the separate Environment tag
  • ‘default_replica_path’ now includes uuid
  • Upgrade version recommendations have been improved
  • Access Management is enabled for ‘admin’ user by default in new clusters
  • Cost estimates for are more accurate now
  • Workload->Mutations has been improved
  • clickhouse-backup has been upgraded to 2.2.8
  • It is now possible to change ZooKeeper node type for running clusters
  • Improvements to Node Type configuration
  • Allow IAM role access to the backup bucket instead of credentials

Fixed

  • Fixed node storage % incorrect display in some cases
  • Fixed hint for Clone Database
  • Fixed datadog deployment in Anywhere environment
  • Fixed Anywhere environment setup when EKS cluster is provisioned by Altinity

23.3.31

Released 2023-06-07

Changed

  • Disable ‘Reset Anywhere’ for users

Fixed

  • Removed an error from the logs that table system.crash_log does not exist when opening up a cluster page
  • Fixed Node Selector spec

23.3.28

Released 2023-05-31

Changed

  • clickhouse-operator has been upgraded to 0.21.1 version
  • Added a user friendly page when ACM is not-available
  • Disable gp2 storage class

Fixed

  • Correctly set 4000 IOPS for 1000MB/s gp3 volumes throughput
  • Fixed some corner cases with ZooKeeper re-scale

23.3.26

Released 2023-05-17

Added

  • Allow to modify gp3 volume throughput in Rescale
  • New ‘Mutations’ tab in Workflow
  • New ‘Crashes’ tab in DBA tools
  • Introduce cluster owner, allow to change owner
  • Set labels on S3/GCS backups
  • Configure logs location in environment settings for Anywhere environments
  • Delete of Anywhere environments
  • Added a support for custom image registries for Anywhere environments
  • Allow to test backup bucket access
  • Allow to pick up availability zones when starting a cluster

Changed

  • Changed default Altinity Access level to ‘System’
  • ALERTS popup has been improved
  • Improved ClickHouse® version upgrade recommendations that were incorrect sometimes
  • system.session_log is enabled by default (it has been disabled in 22.8+ ClickHouse releases)
  • ZooKeeper configuration management has been changed. That allows re-scale w/o a downtime and also better HA
  • Allow to use IAM access for backup buckets
  • ZooKeeper node configuration is now re-created using Publish
  • Upgraded clickhouse-backup to 2.2.5. That fixes the concurrency issue and also allows to resume interrupted backup automatically.
  • Upgraded clickhouse-operator to 0.21.0. That eliminates some unneeded restarts, e.g. when changing log level.

Fixed

  • Fixed a bug with ‘Copy Data between Clusters’ that could not copy some types of MergeTree tables
  • Fixed a bug where pressing MANAGE CLUSTERS in Environments List page did not navigate to cluster page properly
  • Fixed ‘Last Insert Timestamp’ that has been empty in some cases
  • Automatically enabled monitoring and backups for new Anywhere environments

23.2.35

Released 2023-04-17

Fixed

  • Fixed Cluster soft restart
  • Backup creation waiting time has been increased to 23 hours
  • Zookeeper tolerations are now updated on rescale/republish
  • Fixed display of tolerations when re-connecting to an existing Anywhere environment

23.2.33

Released 2023-04-11

Added

  • Backup configuration is now available on a cluster level. Different clusters may have different backup settings.
  • New volume performance guidelines when starting a cluster
  • Now user is alerted it profile setting is used instead of a server setting
  • New resource limit for total number of nodes
  • Allow to exclude individual node from a load balancer
  • Users can add custom Grafana dashboards
  • Support alternate cluster names
  • New Altinity Support role (available for Altinity staff only)
  • Discounts management (available for Altinity staff only)

Changed

  • SHARE button has been renamed to INVITE
  • Rescale screen shows storage units now
  • “Kafka Connection Check” has been moved to the cluster page. It can not insert Kafka configuration directly to the cluster
  • Notifications include FQDN for cluster names now
  • Improvements to Environment dashboard
  • If environment backup settings are changed those are applied automatically to clusters now
  • More DataDog regions are available now

Fixed

  • Fixed “Copy Data between Clusters” for Anywhere environments with custom node taints
  • Fixed a bug when Node View was not available for offline nodes
  • Rebalance is available back for envadmins

23.1.23

Released 2023-03-10

Fixed

  • Fixed a bug with version upgrades for ClickHouse® 23.1 and above that might result in cluster not going online after restart
  • Fixed a bug with “Workload->Replication” screen did not display any results
  • Fixed a bug with “Copy Data Between Clusters” tool that did not work correctly in a replicated cluster with non-partitioned tables in some cases
  • Display an error message if “Schema Consistency -> Create table on all nodes” fails with an error

23.1.21

Released 2023-02-20

Added

  • Clone database feature that allows to clone database w/o data copy on same host
  • Force restart of an individual node
  • Show pod events in a node view
  • Current quota usage is now displayed on an environment screen
  • User role can be specified when inviting user to an environment
  • Progress bar when applying changes to a cluster
  • Operator managed persistence is now default for new environments, and can be turned on for existing ones. It allows to re-scale volumes w/o downtime
  • Re-publish ZK clusters

Changed

  • Backup configuration is currently always deployed, even if schedule is disabled
  • ClickHouse® version recommendations were improved
  • IAM-managed access to backup bucket is now allowed
  • Data rebalance UI has been improved
  • Cluster are now sorted alphabetically
  • Asynchronous metrics log frequency is reduced for new clusters
  • Changed some ‘default’ profile settings (part of operator release):
    • Enabled ‘do_not_merge_across_partitions_select_final’
    • Set ’load_balancing’ to ’nearest_hostname’
    • Set niceness (‘os_thread_priority’) to 2.

Fixed

  • Fixed data consistency checks for 3 replica clusters
  • Improved loading speed for Accounts screen
  • Copy Data wizard can now work with non-Altinity.Cloud ClickHouse
  • Fixed Auth0 integration with Okta

22.12.25

Released 2022-12-25

Added

  • User is notified with a warning sign when backups are not configured
  • User is notified with a popup message when data migration is completed or failed
  • ‘Delete table’ action is added to Data Consistency tab
  • List of databases granted to ClickHouse® user are displayed
  • Quick filter was added in order to see unhealthy nodes on Dashboard page
  • Support Bare Metal environments as a hook for non-cloud customers billing
  • Markdown is supported for Notifications (Altinity only)
  • Recipients selection has been re-worked for Notifications (Altinity only)
  • Altinity is notified when user removed the payment method (Altinity only)

Changed

  • ‘Environment Settings’ was renamed to ‘Environment Variables’ on the cluster page
  • DBA tools UI was made more intuitive
  • Improved new Anywhere environment setup process
  • Improved Data Rebalance function that could sometimes move too much data
  • Backup configuration is moved to a separate resources instead of being bundled with ClickHouse configuration. This change requires restart.
  • Backup stability improvements, and clickhouse-backup:2.1.1 certification

Fixed

  • Fixed a bug when node status was not updated for a few minutes after ClickHouse cluster is up an running
  • Fixed a bug with backup being restored from AWS to GCP environments or vice versa could not be restored to a new cluster due to mismatching node types
  • Fixed a bug when Rescale ignored auto publishing being turned off
  • Fixed a bug when ‘Run DDL ON CLUSTER’ did switch off automatically when specific node is selected
  • Fixed a bug with rescaling GCP clusters in old tenants
  • Fixed a bug when profile settings could not be changed on a cluster that can not start
  • Fixed Data Migration tool that did not work in Anywhere environments due to hard-coded tolerations
  • Fixed a bug with backup compression format was not respected for GCP clusters
  • Fixed a bug with memory and volume graphs displaying incorrect data

22.11.30

Released 2022-11-14

Added

  • Used/available quota is now displayed when starting a cluster
  • New System Metrics Grafana dashboard
  • Reset Anywhere action in order to disconnect from the Anywhere environment
  • Rebalance data across storage volumes
  • Tracking customer credits when invoicing

Changed

  • In the list of accounts, environments for a particular account are now displayed
  • Anywhere connection wizard has been improved
  • Sensitive environment settings are back to readonly for non-Anywhere clusters
  • Multiple improvements to backup functionality
  • Multiple improvements to Copy Data between Clusters feature
  • Log storage has been migrated to Grafana Loki

Fixed

  • Fixed latest backup timestamp that has not been updated sometimes
  • StatusCheck now works for Anywhere environments
  • Billing estimates are now correct for Anywhere clusters
  • MaterializedView tables are now correctly restored when using Consistency check tool
  • Fixed a UI bug with ClickHouse version was not displayed when one of cluster nodes was down
  • Fixed Kafka Connection tool generated XML that was sometimes incorrect
  • Fixed Environment Variable settings page that did not allow to specify non-secret settings
  • Fixed a bug that did not allow to restore GCP backup to AWS or vice versa to an automatically created cluster due to incorrect node specifications
  • Billing reports are now displayed correctly for Anywhere clusters

22.10.24

Released 2022-09-15

Added

  • Allow to restrict access to cluster management for Altinity stuff
  • Setup and initial configuration of Anywhere environments
  • Dashboard is enabled for env and org admins
  • Copy Data feature is enabled for env and org admins
  • Logging into Loki for Anywhere tenants
  • Option to turn on ClickHouse SQL access management for users
  • New ‘Errors’ tab under DBA tools
  • New ‘Cluster Consistency’ tab under DBA tools
  • Pod status in the Node view
  • Environment variables from a k8s secret

Changed

  • Processes tab have been improved
  • Multi-statements now can be executed in Explorer
  • When ClickHouse cluster is upgraded to the new version, the UI now allows to easily pick Altinity.Stable and Community versions
  • ClickHouse version upgrade recommendations have been improved
  • When user returns with a direct cluster link, cluster Environment is automatically selected as a current one

Fixed

  • Fixed sort order in a list of nodes dropdown in Explorer
  • Fixed backup restore scenarios between different environments and clusters
  • Fixed a bug with detached parts could not be deleted for ‘.inner.’ tables
  • Fixed Kafka connection tool in GCP environments

22.9.21

Released 2022-08-15

Added

  • Added a feature to convert from non-replicated to replicated MergeTree (available for Altinity staff only)
  • Data Migration Tool to copy data between clusters (available for Altinity staff only)
  • New ‘Launch from Backup’ wizard that allows to pick any backup source, including outside of Altinity.Cloud
  • Replication status in Workload
  • Alert cluster owners when Altinity access level is changed
  • Backlink button to the Environment page
  • Proxy connection mode for Anywhere clusters

Changed

  • Workload tab was refactored to show 3 panels: Queries, Replication and Processes
  • Workload is sorted in descending order by default
  • Table creation hints were updated in Explorer
  • Improved loading test datasets feature
  • User is automatically redirected to the last visited page on re-login

Fixed

  • Fixed restoring a backup in sharded and replicated cluster with tables replicated to every shard
  • Fixed sorting order in dashboard
  • Last insert timestamp now displays timestamp for Kafka inserts correctly now
  • Fixed SELECT ALL IGNORED for detached parts

22.8.15

Released 2022-07-07

Added

  • New tool to review and remove detached parts
  • New tool to test connectivity to Kafka broker
  • New tool to import test datasets – available for 22.3 ClickHouse version and above

Changed

  • Default log level for new clusters is set to ‘information’. Users can edit log level using ’logger/level’ cluster setting
  • Storage size is displayed as ‘Pending’ if rescale has not been complete
  • Improved version upgrade recommendations
  • Improved Schema and Workload tabs

Fixed

  • Fixed a bug with uptime schedule that could unexpectedly stop clusters sometimes
  • Fixed a bug with memory configuration settings if cluster is resumed to the different node size

22.7.13

Released 2022-06-03

Added

  • User role is now displayed on Account page
  • A warning is displayed on ClickHouse version upgrade is available
  • Sorting has been added to the Schema tab
  • A tool to convert a table from MergeTree to ReplicatedMergeTree (available for superadmins only)
  • VPC Endpoint status is displayed on Connections popup
  • Custom tolerations can be specified for node types

Changed

  • User is automatically authenticated as ClickHouse admin when starting a new cluster
  • Schedule icon opens a Schedule popup now
  • When rescaling a volume, minimum rescale ratio is 20% of the volume size
  • Org admin can access Environment details now (previously it was only possible with Env admin)

Fixed

  • ClickHouse use authentication fixes
  • List of backups was sometimes not properly sorted
  • Fixed a possible race condition in backup and restore of replicated clusters

22.6.18

Released 2022-05-13

Added

  • Explorer now requires user authorization using ClickHouse user/password
  • Altinity staff does not have an access to the data by default. Multiple levels of access can be granted by a customer – that enables ‘altinity’ user to work with the data.
  • New ‘Workload’ tab in Explorer to analyze typical queries
  • Copy to Clipboard buttons in Connection Details

Changed

  • DataDog metrics are labeled with environment and cluster
  • clickhouse-operator user is restricted to Altinity network only
  • Brute force protection is enabled for password recovery form

22.5.15

Released 2022-04-25

Added

  • Cluster Uptime feature that allows stopping the cluster automatically when inactive or by schedule.
  • Reset to defaults is available on ClickHouse settings and profile settings pages.
  • Email notification is sent to the user when trial is extended.
  • Connection to Remote environment via Altinity Connector.

Changed

  • Display a warning when downgrading ClickHouse major version
  • Display a warning when non-replicated MergeTree table is created on replicated cluster
  • Cluster Dashboard now shows LB type and storage type

Fixed

  • Fixed UI slowness when a long query is being executed.
  • Fixed Schema tab that may be not displaying tables when databases contains hundreds of those.
  • Small UI fixes in different places.

22.4.15

Released 2022-04-06

Added

  • Breakdown by clusters on a billing page
  • Initial support for user managed environments
  • Environment connection status

Changed

  • Changed cluster wizard to make it easier to use
  • Fractional disk sizes are not allowed anymore
  • ‘Pay by Invoice’ option is disabled

Fixed

  • Fixed a bug with local backups not being deleted that might result in higher disk usage
  • Fixed a possible backup failure on clusters with async_inserts=1
  • Fixed a bug with ALTER TABLE did not work sometimes on clusters restored from a backup
  • Fixed a bug with schema did not refresh sometimes
  • Fixed a bug in incorrect retention of backups of sharded cluster

22.3.14

Released 2022-03-17

Added

  • Allow to select a node type when launching a cluster from backup (available for Altinity staff only)

Changed

  • DROP TABLE is executed now before restoring a table from the backup
  • CPU is correctly displayed in cores on Environment page in this release
  • clickhouse-operator has been upgraded to 0.18.3
  • Fixed a bug that did not allow to enter ‘0’ in cluster settings
  • Fixed a bug that might result in cluster not going online when using ClickHouse versions 22.2 and above
  • Fixed a bug with incorrect display of billing data for GCP environments
  • Fixed a bug with AWS NLB usage
  • Fixed a bug with cluster metadata not being stored in backup sometimes

22.2.15

Released 2022-02-28

Added

  • Notifications for cluster related events can be configured
  • Datadog integration
  • Option to force Auth0 authentication for organization
  • Dark UI theme
  • Cmd/Ctrl+Enter in Explorer can be used to run a query

Changed

  • ZooKeeper is now stopped when cluster is stopped
  • Warning has been removed from volume rescale popup
  • Monitoring links have been moved to the top in order to make it easier to find
  • Max part size has been reduced to 50GB
  • Column compression tab is more compact now
  • When backup operation is in progress all operations that may incidentally restart the cluster are blocked now

Fixed

  • Fixed a bug with list of databases sometimes could not be parsed in user dialog
  • Fixed a bug with replica cluster creation
  • Fixed latest backup timestamp display for stopped clusters
  • Fixed a bug with table restore from a backup that could download full cluster backup instead of a single table

22.1.28

Released 2022-01-31

Added

  • Restore cluster from an External backup (available for superadmins only)
  • Restore single table from a backup
  • New Grafana dashboard for logs

Changed

  • UI facelifting on Cluster and Nodes dashboards
  • System tables are now hidden by default on Schema dashboard
  • Stronger security for Grafana monitoring dashboard
  • Better performance of Billing dashboard
  • Use ‘pd-ssd’ fast storage for ZooKeeper nodes in GCP
  • Cluster dashboard now shows a warning if backup utility is outdated
  • Backup line item is now correctly displayed for GCP clusters
  • Support plan is now displayed on a billing page
  • Error Log section is removed from ClickHouse logs page

Fixed

  • Fixed ON CLUSTER switch behavior
  • Removed deprecated ClickHouse settings from default profile
  • Removed deprecated node annotations

21.13.21

Released 2021-12-21

Added

  • Expiration date for trials can be adjusted from UI (previously it could only be done with an API call)
  • Expiration date for notifications can be configured
  • Units to the billing usage page
  • Legend to the Columns tab that clarifies key flags

Changed

  • UI has been refreshed with a new version of Clarity.Design library
  • When user VPC endpoint is configured Access Point URLs are switched to ‘internal’ now
  • AWS NLB is disabled by default. It can be enabled on Environment level if needed
  • Cron job logs are sent to centralized logging

Fixed

  • Processes view is fixed for ClickHouse versions 21.8
  • Estimated costs for GCP are corrected
  • Trial notifications are not longer created for blocked organizations

21.12.26

Released 2021-12-01

Added

  • Post-trial workflow allows user to signup to the paid account
  • Column level compression tab in Schema popup
  • New billing user role in order to access billing only
  • Soft rolling restart of ClickHouse nodes is now available. The previous ‘hard’ restart can be used as well.
  • Background operation status is now displayed on the cluster dashboard
  • Billing integration for GCP
  • Backups for GCP

Changed

  • ZooKeeper is updated to 3.7.0. It only affects new clusters.
  • clickhouse-backup is updated to 1.2.2
  • User will receive notification when subscribes or unsubscribes from ClickHouse alerts
  • Billing company name can now be different from the organization name

Fixed

  • Fixed ‘Refresh’ button on Processes tab that did not refresh the screen sometimes
  • Fixed an issue when sometimes schema was displayed as empty

21.11.24

Released 2021-10-27

Added

  • Usage details are available in Billing
  • Download links to issued invoices are available in Billing
  • Backup cost is extracted as a separate line item. Previously it was a part of a storage cost.
  • VPC Endpoint status is displayed when enabled
  • Datadog integration is supported for ClickHouse logs. Contact us with your datadog agent id.
  • GCP support
  • Enabled support for Altinity Builds of ClickHouse

Changed

  • Networks are removed from ClickHouse users creation. It is now controlled in Connectivity on a cluster level
  • ZooKeeper cluster size can not be selected anymore. It is adjusted automatically.
  • Available API endpoints are now filtered according to the user role. Previously, user could see all API even if those could not be used.

Fixed

  • Fixed a bug with node endpoints being unavailable under VPC endpoint

21.10.28

Released 2021-09-21

Added

  • Allow users to configure alerts for the cluster. Note: cluster may be restarted when email is used for a first time
  • IP/CIDR whitelisting to protect access point access
  • Compression ratio column on a Schema tab
  • Email notifications (system)
  • Notifications to a specific recipient (system)
  • ‘Prepare All Invoices’ super-button that sends invoices to all paid customers (system)
  • CC and BCC addresses for invoices

Changed

  • Users and ClickHouse users passwords are now required to be 12 characters at least
  • Session timeout is increased to 60 minutes
  • Troubleshooting mode now allows Altinity Engineers to enter the failed node
  • ‘View Logs’ are renamed to ‘Logs’
  • Backup utility is updated to altinity/clickhouse-backup:1.0.16. That improves speed of backups among other fixes.

21.9.9

Released 2021-08-12

Added

  • Cluster level access control
  • Cluster Restart action
  • User level configurable API tokens

Changed

  • Improved ZK cluster scale up/down logic
  • Improved Invoices creation logic
  • Security improvements

21.8.20

Released 2021-07-21

Added

  • Billing integration
  • Price estimator is now displayed when starting a cluster
  • In-app notifications
  • Allow to deploy 3-node ZK cluster in the regions with only two AZs available (e.g. us-west-1)
  • Cluster name now appears at all cluster related popup windows

Changed

  • Upgraded clickhouse-operator to 0.15.0
  • Backup and security improvements

21.7.19

Released 2021-06-18

Added

  • Support for multiple environments for an organization
  • Basic usage information at the billing page
  • Download of logs
  • Password recovery if user has lost his password
  • Externally available status page that can be referenced as https://status.<tenant-name>.altinity.cloud

Changed

  • ClickHouse custom images are restricted to Yandex and Altinity only
  • Non-XML config files are now allowed (e.g. for dictionaries)
  • Backup and security improvements

21.6.9

Released 2021-05-19

Added

  • New Environment Settings section into cluster configuration
  • default_replica_path and default_replica_name settings are now pre-populated that to simplifies creation of ReplicatedMergeTree tables (requires ClickHouse 21.1+)
  • Node selector is now available at the Explorer page. It allows to run queries against an individual node.

Changed

  • Improved usability of cluster settings
  • Fixed a bug with “.inner.” tables did not properly work in Explorer
  • Fixed a bug with orgadmin did not have permissions to modify cluster settings
  • Fixed a bug with orgadmin could see user plain password in user audit log when password is changed
  • Upgraded to clickhouse-operator to 0.14.1. That fixes a possible failure of schema creation when adding a new replica to the cluster.
  • Upgraded clickhouse-backup to 1.0.9. That fixes restore of materialized views and distributed tables.
  • Backup and security improvements

21.5.10

Released 2021-04-27

Added

  • Node endpoints connection details
  • Last query and last insert timestamps
  • Fixed default ClickHouse version when upgrading.
  • Login screen protection from a brute force attack

Changed

  • Now it is possible to rollback quickly to the older version if ClickHouse does not start after upgrade
  • Fixed Share feature when user belongs to a different environment
  • Enabled multi-AZ ZooKeeper deployment
  • Upgraded to clickhouse-operator 0.14.0
  • Improvements to ACM dashboard
  • Backup and security improvements

21.4.10

  • Schema tab has been fully re-designed
  • Atomic databases can be now correctly backed up with the new version of backup utility (requires cluster re-publish)
  • We have added gp3 storage option, and removed unencrypted volumes completely
  • ClickHouse Version is now automatically defaults to the latest Altinity Stable release
  • The number of replicas for Zookeeper clusters has been added to a list of Zookeepers
  • General stability and security improvements

21.3.21

  • New ‘Share’ function to invite users
  • Cluster created by one user can not be deleted by another user anymore
  • Improved Account Details screen
  • New service status page that allows to subscribe for status changes
  • Added a startup mode advanced setting. New ‘Direct’ mode decreases startup times for huge clusters
  • Added input validation in different places
  • Added a limit on maximum number of shards and replicas
  • Added an option to re-scale ZooKeeper from 1 to 3 nodes and vice versa (available only for admins yet)
  • Stability, security and backup improvements

21.2.15

  • Grafana is now accessible under ‘/monitoring’ path rather than a separate endpoint. That works under VPC as well.
  • Individual shards and replicas can be directly accessed by TCP and HTTP clients. In order to use that cluster needs to be re-published. Ask us for more detail if interested.
  • Flexible backup schedule (available on request)
  • Restore a backup to a new cluster (available on request)
  • Cluster names are now forced to use only lower case latin characters and numbers
  • Fixed a bug with RENAME TABLE query did not work in ON CLUSTER mode
  • Fixed a bug with losing SSL files when stopping the cluster for a long time
  • UI stability improvements and bug fixes

21.1.12

  • UI performance optimizations
  • Usability changes in Rescale screen
  • Added a validation to Profile Settings values
  • Login attempts are now correctly logged into Audit Log
  • Macros section is removed. Macros can be overridden via Settings if needed and looked up in system.macros table
  • Fixed a bug in Query Explorer that did not display query results with WITH statement properly
  • Fixed a bug that did not allow to Resume to a different node type
  • UI improvements and minor bug fixes

20.5.10

  • Handling of custom configuration files in cluster settings has been improved
  • Altinity Stable ClickHouse version has been upgraded to 20.8.11.17
  • Cluster Migrate feature has been temporary disabled
  • UI improvements and minor bug fixes

20.4.3

  • Grafana has been switched to Edge Ingress load balancer, and is now secured by https
  • UI improvements and minor bug fixes

20.3.4

  • Platform specific settings are now protected from user modifications
  • Node and Cluster status is displayed correctly
  • ClickHouse version has been added to the clusters list
  • Session times out after 30 minutes of user inactivity
  • Healthcheck screen has been improved
  • Automatic redirect from HTTP to HTTPs when accessing the management plane