1. Home
  2. Docs
  3. ClusterControl
  4. Changelogs
  5. Changes in v1.9.7

Changes in v1.9.7

Maintenance Release: February 21st, 2024

  • Build:
    • clustercontrol-controller-1.9.7-7812
  • Controller:
    • Address an issue when the hostgroup is empty and CMON does not take any action. An issue with generating alarms has been corrected (CLUS-3066).
    • Address an issue with too many cronjobs (>128) defined for simultaneous execution (CLUS-3445).
    • Address an issue with clusters disappearing from the cluster list with an offline / no internet environment when trying to ‘Installing Zip requirement: zip’ (CLUS-3447).

Maintenance Release: February 13th, 2024

  • Build:
    • clustercontrol-controller-1.9.7-7600
  • Controller:
    • Address an issue where the MySQL binary logs were copied with backup verification jobs (CLUS-3199, CLUS-3143).

Maintenance Release: January 29th, 2024

  • Build:
    • clustercontrol-controller-1.9.7-7465
  • Controller:
    • Address an issue with inaccurate replication lag (CLUS-3297).
    • Address an issue when the ProxySQL hostgroup is empty and CMON does not take any action (CLUS-3066).
    • Address an issue with the deployment of Oracle MySQL 8 on Ubuntu 20. GPG key updated. (CLUS-3261).

Maintenance Release: January 16th, 2024

  • Build:
    • clustercontrol2-2.0.0-1161
  • Frontend (UI):
    • Address an issue with Add Replication Node for MySQL. Picking a custom template/configuration was missing (CLUS-3270).
    • Address an issue with the cluster list view where navigating to the last few clusters was not possible (CLUS-3265).
    • Address an issue where the ‘Repository’ option was missing when importing a cluster (CLUS-3089).
    • Address an issue with the UI toaster message when saving a backup schedule (CLUS-3187).
    • Address an issue with the Add Replication node wizard where the selected MySQL configuration template is switched back to the default template when moving between the steps (CLUS-3144).
    • Address a cosmetic issue with the alarm details dialog and the ellipses alignment (CLUS-3274).

Maintenance Release: December 22nd, 2023

  • Build:
    • clustercontrol2-2.0.0-1133
  • Frontend (UI):
    • Address an issue with DB Users for MySQL when enable_is_queries=0 (CLUS-3067).
    • Address an issue where the option to clear an alarm was missing (CLUS-3055).
    • Address an issue where ‘[]’ was enclosing recipients’ email addresses for scheduled operational reports (CLUS-3120).
    • Address an issue with the backup verification schedule where the verification process started immediately instead of as scheduled (CLUS-3124).
    • Address issues with showing non-supported MariaDB versions (CLUS-3144).
    • Address an issue where the nodes page was shown instead of the dashboard (CLUS-3183, CLUS-3113, CLUS-2882, CLUS-3248).
    • Address an issue with the Query Monitor->Query Outliers showing incorrect durations in days/weeks (CLUS-3165).
    • Address an issue with ProxySQL when removing servers from a host group and modifying a server’s settings such as weight (CLUS-3091).

Maintenance Release: December 15th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-7128
  • Controller:
    • Address an issue with forcing failover for MySQL Replication regardless of the state of the primary node (CLUS-3239).

Maintenance Release: December 12th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-7051
  • Controller:
    • Address an issue with MongoDB 4.2.8 and connection failures when the hello() method is not available (CLUS-3065).
    • Address an issue with the LDAP configuration not being persisted between UI sessions (CLUS-3043).
    • Address an issue with operational reports where the remaining license expiration days were not accurate  (CLUS-2779).

Maintenance Release: November 22nd, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6806
  • Controller:
    • Address issues with the SMTP mail server configurations that used a custom port, TLS enabled, and special characters in password/usernames (CLUS-2946).
    • Address an issue with MySQL user management ‘showing unknown json error’ for users without grants instead of proper error message (CLUS-2899, CLUS-2867).
    • Address an issue restoring a backup with pgBackRest (PITR) using a stop time of now() (CLUS-2726).
    • Address additional issues with plain text passwords being shown in MongoDB job logs (CLUS-2823).

Maintenance Release: November 17th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-8653
    • clustercontrol2-2.0.0-1093
  • Controller:
    • Address an issue where ‘Invalid Cluster ID’ was shown on the Query Monitor page (CLUS-3039).
  • Frontend (UI):
    • Address an issue where the pgBackRest backup records were not marked as deleted (CLUS-3004).
    • Address an upgrade issue where both MySQL and ProxySQL nodes were upgraded instead of only the MySQL node (CLUS-3030).
    • Address an issue where host discovery for SSH connectivity was broken when using a custom SSH port (CLUS-2997).
    • Address an improvement to artificial support schema.* for PostgreSQL Using the wildcard will translate the statement into GRANT SELECT ON ALL TABLES IN SCHEMA foo TO user (CLUS-2962).
    • Address an issue where the alarm notifications (number of alarms) were not in sync with the number of alarms shown in the alarms table (CLUS-2950).
    • Address an issue where EOL MongoDB 4.2 was still available to be selected in the deployment wizard (CLUS-2917).
    • Address an issue where Keepalived nodes were shown as primary nodes (CLUS-2940).
    • Address an issue where the Transaction Log page was missing with MySQL (CLUS-2807).

Maintenance Release: October 26th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6677
  • Controller:
    • Address an issue where ‘free monitoring’ is no longer available with MongoDB community editions (CLUS-2744).
    • Address an issue verifying backups on Elasticsearch. Only a checksum verification is performed at this time (CLUS-2824).
    • Address an issue where MongoDB passwords were shown in clear text in logs (CLUS-2823).
    • Address an issue where a MySQL Replication Primary node was set to read-only if one of the replicas momentarily ran out of disk space (CLUS-2569).

Maintenance Release: October 18th, 2023

  • Build:
    • clustercontrol2-2.0.0-1057
  • Frontend (UI):
    • Address an issue where the Resync node menu action was not visible (CLUS-2869).
    • Address an issue where an option to set the data dir for the Prometheus installation (agent-based monitoring) was missing (CLUS-2823).
    • Address an issue where some charts were missing with MongoDB Shards deployments (CLUS-2883).
    • Address an issue where the time could not correctly be selected in the time picker when scheduling a backup (CLUS-2869).
    • Add cluster information in the header of the cluster page with cluster type, status, auto recovery, and nodes (CLUS-2856).
    • Address an issue where Delete Job was missing from the Job menu (CLUS-2855).
    • Address an issue with the CC logo (CLUS-2760).

Maintenance Release: October 16th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6636
  • Controller:
    • MongoDB 4.4 is now the oldest version that can deployed (CLUS-2818).
    • Address an issue with restoring backups on a cluster where hostnames were used (CLUS-28263).
    • Address an issue with Elasticsearch failing to find a valid node during deployment (CLUS-2826).
    • Address an issue with PgBackRest backup retention for differential backups. There is now a new configuration variable pgbackrest_diff_backup_count_retention with a default value of 20 days which is set for repo1-differential-diff (CLUS-2817).
    • Address an issue where passwords were shown in plain text in the MongoDB logs (CLUS-2823).

Maintenance Release: October 4th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6597
  • Controller:
    • Address an issue where cmon backup metadata were created in the stanza directory with pg_backrest (CLUS-2789).
    • Address an issue where operational reports were not sorted by ID DESC (CLUS-2514).
    • Address an issue where mongosh was not installed with deb/rpm packages (CLUS-2741).
    • Address an issue where the ‘backup user’ password after the backup restore was invalid (CLUS-2589).
    • Address an issue when deploying a delayed MySQL replica (CLUS-2754).
    • Address an issue promoting a replica when it is delayed or lagging (CLUS-2729).
    • Address an issue where a replica fails when configuring the ‘delayed’ threshold manually (CLUS-2739).
    • Address a potential memory corruption issue with the large number of running internal threads stuck on reading LDAP cert parameters from the config file (CLUS-2737).
    • Address an issue to recognize non-UTC timestamps in WAL files (CLUS-2757).
    • Address an issue where pgBackRest full and incremental backup records were not properly deleted with the backup retention period setting (CLUS-2740, CLUS-2511).
    • Address an issue where in certain scenarios auto recovery was disabled by running jobs (CLUS-2400).
    • Address various minor issues where PITR failed on the master if backups were taken on replicas (CLUS-2387).

Maintenance Release: September 20th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6542
  • Controller:
    • Address an issue when doing a reconfigure ‘backup dir’ with PBM (CLUS-2526).
    • Address issue with pgBackRest and automatically rebuild replicas after restore. This is enabled by default now (CLUS-2711).
    • Address an issue with LDAP authentication failing when there is a DN change on the directory service side (CLUS-2633).
    • Address an issue where PBM fails after upgrading to 1.9.7 (CLUS-2640).

Maintenance Release: September 13th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6524
    • clustercontrol2-2.0.0-1005
  • Controller:
    • Address an issue when restoring with pg_basebackup where the replicas were not automatically rebuilt. This is now the default behavior (CLUS-2711).
    • Address issues with PITR pg_basebackup. If no PTIR time is set then recovery_target is set to immediate (CLUS-2609).
    • Address an issue with not masking the password when pg_basebackup failed in the job log (CLUS-2638).
    • Address an issue with ProxySQL when adding a new user (CLUS-2616, CLUS-2678).
  • Frontend (UI):
    • Address an issue with primary colors and corner radius for some components (CCv2-1040).
    • Address an issue where network usage charts randomly switch series during auto updates (CCV2-1030).
    • Address an issue with a broken jobs page when there are no jobs (CCV2-1023).
    • Address an issue with database name validation missing in the deployment wizard (CCV2-1016).
    • Address issues with when restoring with pg_basebackup. ‘Immediate’ is the default behavior if PITR is not selected. Date and time are correctly converted to UTC for job task/spec. (CCV2-1027).
    • Address an issue with team permissions with user management where specific permissions were missing from the dropdown (CCV2-1029).
    • Address an issue when deploying additional ProxySQL nodes with native clustering where it was not possible to continue to the next step (CCV2-2706).

Maintenance Release: September 11th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6517
    • clustercontrol-1.9.7-8642
  • Controller:
    • Address an issue of failing to promote replicas when there is nothing to catch up on the primary (CLUS-2559).
    • Address an issue with the license at deployment time (CLUS-2478).
    • Address an issue disabling ‘read-only’ on a node when auto_manage_readonly=false (CLUS-2501).
    • Address an issue with creating a cluster from backup with MySQL Galera (CLUS-2594).
    • Address an issue with MariaDB Enterprise where -no-backup-locks is not supported (CLUS-2612).
    • Address an issue to raise alarms when CMON starts up with potentially invalid configuration files and silently fails (CLUS-2367).
  • Frontend (UI):
    • Address an issue where backup_failover_host=auto was incorrectly sent to CMON (CLUS-2592).

Maintenance Release: August 26th, 2023

  • Build:
    • clustercontrol-controller-1.9.7-6488
  • Controller:
    • Address an issue where the ‘vendor=postgres’ failed to be recognized after upgrading to 1.9.7 (CLUS-2601).

Initial Release: August 25th, 2023

  • Build:
    • clustercontrol-1.9.7-8636
    • clustercontrol-controller-1.9.7-6487
    • clustercontrol-cloud-1.9.7-395
    • clustercontrol-notifications-1.9.7-339
    • clustercontrol-ssh-1.9.7-151
    • clustercontrol2-2.0.0-979

In this release, we have added support for the following key features:

  • Enterprise Vendors for PostgreSQL and MongoDB – use enterprise software repositories.
  • Support for PostgreSQL 15, MongoDB 6.0, MariaDB 10.11, and MS SQL Server 2022.
  • Support for RedHat 9, AlmaLinux 9, and RockyLinux 9.
  • General Availability of our new web frontend – ClusterControl v2
    • Mail notifications, Certificate management
    • Advisors, Incident management services, Topology View

Features

Enterprise Vendors

ClusterControl now supports using Enterprise vendors for PostgreSQL and MongoDB. You can manage and monitor EDB Postgres Advanced Server and MongoDB Enterprise clusters by using their enterprise repositories when provisioning databases. You need a valid repository token (depending on the vendor) in order to use the enterprise packages.

The s9s CLI adds two new vendor (–vendor) options:

  • enterprisedb for EDB Postgres Advanced Server
  • mongodbenterprise for MongoDB Enterprise

ClusterControl v2.0 – New web frontend

We have been migrating the feature set of the ClusterControl GUI (v1) to a new web frontend. This is a completely rewritten web application that aims to modernize the UI and improve the user experience and ease of use.
It is now in a state where we have feature parity with the old user interface. You can start using ClusterControl (GUI) v2 without having to rely on the functionality of the old web application.

‘CCv2’ is now the default web application when you install ClusterControl following the product download page instructions. The old web application ‘CCv1’ is still accessible until the end of the year at which time it will no longer be supported.

Upgrade to CCv2

You can upgrade/move from the CCv1 web application to the CCv2 web application with a few easy steps (existing ClusterControl installation). This setup will still provide access to the old ‘CCv1’ user interface while the new web application is accessible at another port.

Upgrade notes:

  • The 3rd party notifications configurations for PagerDuty, Opsgenine, Slack, etc. need to be manually re-created in CCv2 and removed from CCv1.
  • The DB Status and DB Variables pages are coming in a future CCv2 patch.

 

Steps described in the following sections should be performed on the ClusterControl node unless specified otherwise.

Red Hat/AlmaLinux/RockyLinuxDebian/Ubuntu
$ yum clean all
$ yum install clustercontrol2
$ systemctl restart httpd
Note

Open the web browser and go to https://{ClusterControl_host}:9443. Log in with your user credentials used with ‘CCv1’

$ apt update
$ apt install clustercontrol2
$ systemctl restart apache2
Note

Open the web browser and go to https://{ClusterControl_host}:9443. Log in with your user credentials used with ‘CCv1’

Was this article helpful to you? Yes No