Changes in v1.9.7

Maintenance Release: March 22^nd, 2024

• Build:
  • clustercontrol-controller-1.9.7-8179
• Controller:
  • Address a potential performance issue when CMON starts with a large number of managed clusters and the clusters’ are stuck in ‘UKNOWN” state (CLUS-3568).

    A new command line option has been added that can be used with the CMON service file:

    --disable-dsl-advisors # disables advisors.

  • Address an issue with MongoDB deployment and debug strings in the output which caused issues with ‘mongosh’ (CLUS-3653).
  • Address uninitialized variables and debug log output issues with the MongoDB codebase (CLUS-3605, CLUS-3606).

Maintenance Release: March 13^th, 2024

• Build:
  • clustercontrol-controller-1.9.7-8075
• Controller:
  • Address a potential performance issue when CMON starts with a large number of managed clusters and the clusters’ are stuck in ‘UKNOWN” state (CLUS-3445).

    A new command line option has been added that can be used with the CMON service file:
    --cron-thread-delay=600 # seconds to delay before starting up cron job threads.

    Use it to delay the number of ‘cron’ threads being created when CMON starts so that the clusters’ state can be correctly set.

Maintenance Release: February 22^nd, 2024

• Build:
  • clustercontrol-1.9.7-8660
• Frontend (UI):
  • Address an issue where ‘integrations’ are not shown in the UI (CLUS-3478).

Maintenance Release: February 21^st, 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 13^th, 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 29^th, 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 16^th, 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 22^nd, 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 15^th, 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 12^th, 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 22^nd, 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 17^th, 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 26^th, 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 18^th, 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 16^th, 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 4^th, 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 20^th, 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 13^th, 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 11^th, 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 26^th, 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 25^th, 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

$ yum clean all
$ yum install clustercontrol2
$ systemctl restart httpd

$ apt update
$ apt install clustercontrol2
$ systemctl restart apache2