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

Changes in v1.9.5

Maintenance Release: January 26th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6068
    • clustercontrol-1.9.5-8502
  • Controller:
    • Address an issue where the backup compression option had no effect with MS SQL Server (CLUS-1812).
    • Address an issue where the Query Monitoring agent was not installed on a newly added node (CLUS-1823).
    • Address an issue with binary characters from the last_sql_error field of MySQL host instances.
  • Frontend (UI):
    • Address an issue when adding recipients for mail alerts (CLUS-1653).
    • Address an issue where the test mail for notifications could not be sent using another email address than the logged-in user (CCV2-600).
    • Add a sleep step before creating the ccrpc user with the offline install script.

Maintenance Release: January 12th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6045
  • Controller:
    • Address an issue parsing the UUID during bootstrapping a Galera cluster (CLUS-1803).
    • Address an issue with dropping wsrep_on session variable on connection (CLUS-1714).
    • Address an improvement to send license expiration alerts 60 days prior by default instead of 30 days (CLUS-548).
    • Address an issue where MaxScale deployment failed due to DB user creation failure (CLUS-1764).
    • Address improvements to support CMON-Proxy.

Maintenance Release: December 16th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-6004
    • clustercontrol-1.9.5-8494
  • Controller:
    • Address an issue installing using offline repositories with MS SQL Server (CLUS-1719).
    • Address an issue with an incorrect URL to documentation when ‘host is already in a cluster’ errors are in the cmon log (CLUS-1743).
    • Address an issue with the log collection job stops if the pgbackrest.log (PostgreSQL/pgbackrest) file was not found. Changed from Error to Warning instead which allows the job to continue with collecting the rest of the logs(CLUS-1746).
    • Address an issue with deployment failure for MS SQL Server on Centos/RHEL8 (CLUS-1720).
  • Frontend (UI):
    • Address an improvement to configure UI session expiration time. Add a define('SESSIONS_LIFETIME', 3600); parameter to the<webroot>/html/clustercontrol/bootstrap.php file (CLUS-1557).

Maintenance Release: December 6th, 2022

  • Build:
    • clustercontrol-1.9.5-8489
  • Frontend (UI):
      • Address an issue with offline installation using the <webroot>/app/tools/setup-cc.sh

Maintenance Release: November 28th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5950
  • Controller:
    • Address an issue with the cmon agent ‘access denied’ when the agents are installed on several nodes (CLUS-1665).
    • Address an issue with the cmon agent being unable to reconnect after database nodes are restarted (CLUS-1665, CLUS-1680).
    • Address an issue with email alerts where the date header was off with 2h (CLUS-1682).
    • Address an issue parsing the CMON configuration when upgrading. Fixes the CMON and MySQL parsers (CLUS-1674).

Maintenance Release: November 22nd, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5938
  • Controller:
    • Address an issue with recovery jobs stuck in a running state (CLUS-1681).

Maintenance Release: November 21st, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5934
  • Controller:
    • Address an issue with Redis / Redis Sentinel where the bind address was set to the private IP and not 0.0.0.0 by default (CLUS-1671).

Maintenance Release: November 15th, 2022

  • Build:
    • clustercontrol-1.9.5-8481
  • Frontend (UI):
    • Support for Ubuntu 22.04 LTS. Only works at the moment with:
      • PostgreSQL.
      • MariaDB.
      • MongoDB.
      • MySQL Cluster (NDB).

Maintenance Release: November 7th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5911
  • Controller:
    • Address an issue to use a systemd override file for custom PGDATA and PGPORT with PostgreSQL (CLUS-1539).

Maintenance Release: November 1st, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5901
  • Controller:
    • Address an issue with the topology view being incorrect when using a short hostname or IP (CLUS-1645).
    • Address an issue where CMON keeps overwriting the mysql-server_version variable for ProxySQL. It now sets it once at deployment (CLUS-1638).

Maintenance Release: October 24th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5884
  • Controller:
    • Address a potential infinite loop issue when parsing the pg_hba.conf (PostgreSQL).

Maintenance Release: October 24th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5880
    • clustercontrol-1.9.5-8464
  • Controller:
    • Address an issue when updating grants in the pg_hba.conf file to only modify our own changes (CLUS-1627).
    • Address an issue rebuilding a replica with the sudo password set for the SSH user (CLUS-1630).
    • Address an issue where we could end up with multiple primaries after failover (PostgreSQL) (CLUS-1602).
    • Address an issue with HAProxy when a PgBouncer node is removed from the cluster, HAProxy redirects to an existing node in the cluster, i.e., not the previously removed PgBouncer node (CLUS-1614).
  • Frontend (UI):
    • Address an issue to restore an encrypted backup from another cluster. Select the cluster to use for the backup decryption key. (CLUS-1612, CLUS-1622).

Maintenance Release: October 17th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5861
    • clustercontrol-1.9.5-8445
  • Controller:
    • Address an improvement to stop a replica if the replication has a failure instead of keeping the replica running. A new CMON configuration parameter replication_stage_failure_stop_node=true|false can be used to set the behavior (CLUS-1532).
    • Address an issue to silence gethostname errors from the logs by reverting to use the hostname value in the cmon cnf files when checking for SMTP servers (EHLO) (CLUS-1624).
    • Address an issue to restore an encrypted backup from another cluster (CLUS-1612, CLUS-1622).
    • Address an issue to deploy ProxySQL on PXC 8 and MySQL 8 (CLUS-1507, CLUS-1616).
    • Address an issue with parsing REVOKE permission when showing/retrieving MySQL DB users (CLUS-1625).
  • Frontend (UI):
    • Address and issue restoring encrypted backups with Xtrabackup that have an extension .aes256 (CLUS-1626, CLUS-1634).
    • Address an issue with HAProxy deployment to show also the internal/data networks to be selected (CLUS-1535).
    • Address PgBackrest tooltip issues in the backup page (CLUS-1629).
    • Address an issue with re-render when adding a PgBouncer node. Subsequent nodes can now be added without manually having to resize or refresh the page (CLUS-1607).

Maintenance Release: October 11th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5841
  • Controller:
    • Address an issue where MongoDB backups were shown as failed (new restore_to_time to parse instead) after the upgrade to 1.9.5 (CLUS-1601).
    • Address an issue to disable binary logging on PXC (CLUS-878).
    • Address an issue when creating a MySQL replica cluster with a non-root user (CLUS-1508).

Maintenance Release: October 7th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5838
  • Controller:
    • Address an issue when creating a ProxySQL user with a regular expression for the DB schema.

Maintenance Release: October 3rd, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5827
    • clustercontrol-1.9.5-8438
  • Controller:
    • Address an issue installing MySQL 5.7 on Debian 11 (CLUS-1604).
    • Address calculating DB growth where the number of tables to include was limited to 25. It’s now a configurable variable cmon_max_table_on_db_size_calc and set to 100 by default (CLUS-1561).
    • Address an issue where a deleted user’s sessions were automatically terminated (CCV2-542).
    • Address an issue using a local mirrored repository when adding new nodes. The vendor repo was used instead of the local repository (CLUS-1600).
    • Address and issue to include cluster_id in the cluster list result set (CCV2-516).
    • Address a segfault issue with MongoDB and DB growth calculation (CLUS-1516).
    • Address an improvement to pass controller-id and MySQL-DB to cmon at start (CLUS-1588).
  • Frontend (UI):
    • Address an issue fetching the trial license (CCV2-545).

Maintenance Release: September 27th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5810
  • Controller:
    • Address an issue to limit the number of node restart/recovery attempts for Galera. An exponential back-off mechanism (with base 3s) has been added. This applies to node and cluster recovery(CLUS-1266).Screenshot_2022-09-27_at_7.19.12.png
    • Address an issue rebuilding a PostgreSQL replica node on Centos if the postgresql.conf is stored in the data directory (CLUS-1569).
    • Address an issue with PgBouncer where it did not stop when it got unregistered (CLUS-1580).
    • Address and issue where Invalid Security Configuration error alarm was sent even though ‘cluster_ssl_enforce’ was set to false on MariaDB 10.2 (CLUS-1550).

Maintenance Release: September 19th, 2022

  • Build:
    • clustercontrol-controller-1.9.5-5794
    • clustercontrol-1.9.5-8430
  • Controller:
    • Address an issue with MS SQL Server to improve automatic failover and prevent potential multiple primaries. The best secondary node to promote to a new primary is determined by the sync lag(CCV2-519, CCV2-464).
    • Address an issue for MaxScale where a new promoted Primary was not correctly reflected in MaxScale. The old primary was still receiving traffic (CLUS-1558).
    • Address an issue with failing QMON agent installation for PostgreSQL with existing users like a monitor user(CLUS-1547).
    • Address an issue to improve forced failover for MS SQL Server (CLUS-1560).
    • Address an issue where the SQLServerAdmin user was different when adding a new node for MS SQL Server (CCV2-501).
    • Address an issue rebuilding an MS SQL Server node where the state must be either NOT_HEALTHY or NOT_SYNCHRONIZING (CLUS-1555).
  • Frontend (UI):
    • Address an issue with backup schedules where the next scheduled time for CEST was incorrect (CLUS-1546).

Maintenance Release: September 12th, 2022

  • Build:
    • clustercontrol-controller- 1.9.5-5779
  • Controller:
    • Address an issue for MaxScale where dynamic changes to/var/lib/maxscale/maxscale.cnf.d files didn’t have any effect (CLUS-1538).
    • Address an issue with removing/uninstalling ProxySQL nodes (CLUS-1544).
    • Address an issue installing Garbd and Keepalived with yum (CLUS-5344).

Initial Release: August 31st, 2022

  • Build:
    • clustercontrol-1.9.5-8416
    • clustercontrol-controller-1.9.5-5742
    • clustercontrol-ssh-1.9.5-129
    • clustercontrol-cloud-1.9.5-355
    • clustercontrol-notifications-1.9.5-326

In this release, we added support for a new Linux distribution.

Use OpenSUSE 15/SUSE Linux Enterprise Server 15 with ClusterControl.

OpenSUSE is an open-source community project with Linux-based distributions sponsored by SUSE Software Solutions Germany GmbH and other companies.

SUSE Linux Enterprise Server (SLES) receives more intense testing than the upstream OpenSUSE community distro, intending that only mature, stable versions of packages will make it through to SLES.

Features

OpenSUSE 15/SUSE Linux Enterprise Server 15

  • Support for:
    • MariaDB Server v10.x with mariabackup (Xtrabackup is not available)
    • MariaDB Galera Cluster v10.x with mariabackup (Xtrabackup is not available)
    • PostgreSQL v10+
    • MySQL NDB Cluster
    • HAProxy on OpenSUSE only
  • Current limitations:
    • ProxySQL is currently not supported
    • HAProxy is currently only supported on OpenSUSE
    • Co-located PostgreSQL nodes is not supported
    • TimescaleDB is not supported on OpenSUSE/SLES
    • Oracle MySQL Replication is not supported
Was this article helpful to you? Yes 1 No