Changes in v2.2.0

Maintenance Release: November 25^th, 2024

• Build:
  • clustercontrol-controller-2.2.0-11297
• Controller:
  • Address an issue with MaxScale and missing dependency with killall (CLUS-5095).
  • Address an issue with PostgreSQL when adding a replica node where the memory configuration was taken from the primary node’s host and not the replica’s (CLUS-5104).
  • Address an issue where a failover job is marked as even though the failover was deemed unnecessary CLUS-5068).
  • Address an improvement with PostgreSQL to increase 2048 by default (CLUS-5054).
  • Address an issue with the default setup for SSL/TLS and CCX (CLUS-5077).
  • Address an issue where cloud-only backups are not purged correctly from local storage for CCX (CLUS-3709).
  • Address an issue with MSSQL and users not being replicated when adding a new replica node (CLUS-4996).
  • Address an issue with MySQL Replication where delete after upload breaks incremental backup grouping (CLUS-4198).

Maintenance Release: November 8^th, 2024

• Build:
  • clustercontrol2-2.2.5-1712
• Frontend(UI):
  • Address an issue with sorting columns in the Top Queries view (CLUS-5030).

  • Address an issue with pagination on the nodes page (CLUS-4964).

Maintenance Release: November 5^th, 2024

• Build:
  • clustercontrol2-2.2.5-1699
• Frontend(UI):
  • Address a regression with ilert (service config test) as a vendor option with the notification services (CLUS-5030).
  • Address an issue with slow queries pagination (CLUS-4962).
  • Address an issue with an incorrect confirmation dialog when adding an Elastic snapshot repo (CLUS-4662).

Maintenance Release: October 31^st, 2024

• Build:
  • clustercontrol-controller-2.2.0-10973
• Controller:
  • Address an issue with MaxScale when deploying & importing from RockyLinux 8/9, AlmaLinux 8/9, and RHEL 8/9 (CLUS-4929).

Maintenance Release: October 24^th, 2024

• Build:
  • clustercontrol-controller-2.2.0-10916
• Controller:
  • Address an improvement to allow disabling database growth analytics with this new CMON conf parameter database_growth_enabled=false (CLUS-4670).
  • Address an issue to disable Percona’s telemetry agent by default (v8.0 and upcoming v8.4) (CLUS-4925).
  • Address an issue importing a Galera cluster without schema (CLUS-4364).

Maintenance Release: October 9^th, 2024

• Build:
  • clustercontrol2-2.2.5-1655
  • clustercontrol-notifications-2.2.5-364
• Frontend(UI):
  • Address an improvement to add ilert as a vendor option with the notification services (CLUS-4869, CLUS-4908).

Maintenance Release: October 2^nd, 2024

• Build:
  • clustercontrol-controller-2.2.0-10707
  • clustercontrol2-2.2.5-1642
• Controller:
  • Address an issue to set ‘safety backup’ when doing a backup restore to be disabled by default with all database types (CLUS-4840).
  • Address an issue when doing PITR using a deprecated/removed variable skip-gtids with MariaDB (CLUS-4870).
  • Address an issue with database growth running every 1h to every 12h (CLUS-4670).
  • Address an issue when querying for runtime variables with PostgreSQL (CLUS-4832).
  • Address an improvement to deploy with a local mirrored repository (CLUS-4621).
  • Address an improvement to use systemd for starting, stopping and restarting MongoDB (CLUS-4337).
  • Address an issue to support insecure S3 uploads (CLUS-4763).
• Frontend (UI):
  • Address an issue to support Create new local repository with CCv2 UI (CLUS-4345).
  • Address an issue to obfuscate plain text password in the job specification (CLUS-3495).
  • Address a few minor cosmetic issues with the User registration form (CLUS-4557).
  • Address an issue with Galera Overview dashboard where the cluster size was incorrect when there was a split-brain issue (CLUS-4787).
  • Address a cosmetic issue with the deployment wizard for PostgreSQL when using pg_vector (CLUS-4736).
  • Address an issue with PostgreSQL Overview dashboard with TimescaleDB deployments (CLUS-4859).

Maintenance Release: September 24^th, 2024

• Build:
  • clustercontrol-controller-2.2.0-10614
• Controller:
  • Address a regression with mysqldump when performing partial backup where double quotes were enclosing the selected schemas (CLUS-4846).

Maintenance Release: September 23^rd, 2024

• Build:
  • clustercontrol-controller-2.2.0-10600
• Controller:
  • Address additional issues with mysqldump and database names with _ in their names (CLUS-4647).
  • Address a regression with PITR for MariaDB/MySQL where binary logs were applied from the beginning regardless of when the full backup was taken (CLUS-4806, CLUS-4795).
  • Address a race condition issue with the pbm agent script when started by several CMON threads (CLUS-4648).
  • Address an improvement for local repositories (CLUS-4624, CLUS-4621) – NOTE a UI update will arrive later.
  • Address an issue with s9s CLI where cloud credentials were exposed to non-admin users (CLUS-4784).
  • Address an issue to update the 1.9.5 CMON API docs to 2.2.0 (CLUS-4771).
  • Address an issue to remove duplicate and obsolete operational reports (CLUS-2417).
  • Address an issue with charts/graphs not showing up properly with operational reports (CLUS-4143, CLUS-2417).
  • Address an improvement to make WAL archiving default with pg_basebackup (CLUS-4768, CLUS-4572).

Maintenance Release: September 17^th, 2024

• Build:
  • clustercontrol2-2.2.5-1615
• Frontend (UI):
  • Address an issue with the Dashboard node dropdown when switching between clusters (CLUS-4696).
  • Address an issue with an incorrect MaxScale port showing in the nodes pages (CLUS-4678).
  • Address an issue where the Time value is always 0 with the Query Monitor -> DB Connections for MySQL (CLUS-4663).
  • Address an issue with an incorrect color selection for load balancers in the Add load balancer wizard (CLUS-4668).
  • Address an issue with the Rebuild Replica dialog loading spinner being stuck for PostgreSQL (CLUS-4785).

Maintenance Release: September 13^th, 2024

• Build:
  • clustercontrol-controller-2.2.0-10461
• Controller:
  • Address a regression with show global status when there is no Prometheus node available (CLUS-4767, CLUS-4770).
  • Address an issue with mysqldump and database names with . in their names when using UCS2 encoding (CLUS-4647).
  • Git HASH is now included with cmon —version (CLUS-4658).

Initial Release: September 11^th, 2024

• Build:
  • clustercontrol2-2.2.5-1603
  • clustercontrol-proxy-2.2.4-42
  • clustercontrol-controller-2.2.0-10417
  • clustecontrol-cloud-2.2.5-413
  • clustercontrol-clud-2.2.5-413
  • clustercontrol-ssh-2.2.5-201
  • clustercontrol-notifications-2.2.5-360
  • s9s-tools-1.9.2024082802-release1

# /etc/cmon-events.cnf
vault_token = hvs.A2j7ScVH2j7qC8CAQni7sJ31
vault_addr = http://127.0.0.1:8200
vault_secret_path = 4efbf326-7087-47d7-9200-6c4a135494af/cluster_0

$ apt update
$ apt purge apache2 # purge the Apache server since it's no longer required
$ apt purge clustercontrol2 # purge CCv2 web U since it is no longer required
# install clustercontrol-cc
$ apt install clustercontrol-mcc
# register the local CMON controller with cmon-proxy
$ ccmgradm init --local-cmon -p 443 -f /var/www/html/clustercontrol-mcc # serve web application on port 443
$ systemctl restart cmon-proxy
# change TLS cert if needed in /usr/share/ccmgr/ccmgr.yaml and restart cmon-proxy
$ cat /etc/share/ccmgr/ccmgr.yaml
filename: /usr/share/ccmgr/ccmgr.yaml
webapproot: /var/www
fetch_jobs_hours: 12
fetch_backups_days: 7
instances:
- xid: cqf1b1cfnetrgl51vhrg
url: 127.0.0.1:9501
name: local
use_cmon_auth: true
frontend_url: localhost
cmon_ssh_host: 127.0.0.1:9511
timeout: 30
logfile: /var/log/ccmgr.log
users:
- username: admin
passwordhash: fa31fa6e142d9d1b:6870:21790d5c340c9fe207d6a5e29fe39eaddeff200b517e90e19318dddb515a424f
frontend_path: /var/www/html/clustercontrol-mcc
port: 443
tls_cert: /usr/share/ccmgr/server.crt
tls_key: /usr/share/ccmgr/server.key
session_ttl: 1800000000000
# open ClusterControl Ops-C at https://<cmon controller ip>:443 and logon with one of your existing CC admin user

CCv2 UI

• Support for showing redundant indexes for MySQL.
• Support for using Apache mod_php with the Apache server instead of using mod_proxy.
  • Install php (and remove mod_proxy).
  • Copy the Apache configuration  /usr/share/cmon/apache/cc-frontend.conf to /etc/httpd/conf.d/cc-webapp.conf (as an example).
  • In the Apache configuration comment IncludeOptional /usr/share/cmon/apache/cc-frontend-cmon-api.conf and IncludeOptional /usr/share/cmon/apache/cc-frontend-license.conf.
  • Uncomment either IncludeOptional /usr/share/cmon/apache/cc-frontend-php-proxy-socket.conf or IncludeOptional /usr/share/cmon/apache/cc-frontend-php-proxy-curl.conf (second requires php curl module).
  • The Apache configuration are now stored for RPM-based distros as /usr/share/cmon/apache/cc-frontend.conf when the clustercontrol2 package is installed manually.
  • The cc-proxy.conf Apache configuration file is no longer required and is not part of the clustercontrol2 package any longer.
  • After upgrading from 2.1.0 or older version of the clustercontrol2 package the Apache configuration file cc-frontend.conf (if it exists) will be renamed to cc-webapp.conf.