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

Changes in v1.9.5

Maintenance Release: April 11th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6270
    • clustercontrol-1.9.5-8550
  • Controller:
    • Address an issue with keepalived details page being blank/empty (CLUS-1860).
  • Frontend (UI):
    • Address an issue when retrieving datapoints for the dashboards to improve situations when the pages failed to load properly (CLUS-1901).
    • Address an issue with hiding a user’s email address if the user’s account has been disabled (CLUS-1653).

Maintenance Release: April 3rd, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6258
  • Controller:
    • Address an issue with MariaDB the systemd override.conf file (CLUS-1749).
    • Address an issue with MariaDB and permissions on the systemd service file (CLUS-1683).
    • Address an issue with syntax errors when importing ProxySQL users with column-based grants (CLUS-1887).
    • Address an issue with log messages (printf) when deleting backups during restore (CLUS-2040).
    • Address an issue with repetitive ‘Node auto recovery delay backoff reset: 0’ log messages.

Maintenance Release: March 17th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6225
  • Controller:
    • Address an issue with confusing log messages during node recovery with delayed backoff (CLUS-1939).
    • Address an issue to improve log messages when a backup user is failed to be created with MySQL replication and MySQL Galera clusters.
    • Address an issue with the ‘postinst’ script and libcrypto on OpenSUSE/SLES.
    • Update CMON-DOCS to show RPCv2 documentation at the top of the page.
    • Address an issue with the backup user not being created when importing Oracle MySQL 8 (CLUS-1844).
      Note
      For existing clusters with issues with the backup user you might need to do a reset:

      $ s9s cluster --change-config --cluster-id=122 --opt-name=backup_user --opt-value=""
      OK.
      $ s9s cluster --change-config --cluster-id=122 --opt-name=backup_user_password --opt-value=""
      OK.
      $ s9s cluster --list-config --cluster-id=122 | egrep '(backup_user|backup_password)'
      backup_user ""
      backup_user_password "<hidden>"

Maintenance Release: March 2nd, 2023

  • Build:
    • clustercontrol-cloud-1.9.5-386
  • Cloud:
    • Address an issue with excessive ‘error 500’ in the cmon-cloud.log (CLUS-1846).

Maintenance Release: March 1st, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6154
  • Controller:
    • Address additional issues setting up a replica cluster with MariaDB Galera 10.6 (CLUS-1850).
    • Address an issue with the ‘CMON agent server’ and timeouts when our software/package repository server might be slow to respond.
    • Address an issue improving error messages when failing to deploy MariaDB Galera 10.6 (CLUS-1936).
    • Address an issue deploying HAProxy with PgBouncer without passing the admin user and password via the S9S CLI (CLUS-1935, CLUS-1895).
    • Address an issue with parsing \ with pg_hba.conf files (CLUS-1923).
    • Address an issue when creating a maintenance period with a non-existing cluster (CLUS-1809).
    • Address an issue with IP address changes with CMON’s internal hostname_internal. It now correctly updates when MySQL’s report_host is changed (CLUS-1929).

Maintenance Release: February 24th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6136
  • Controller:
    • Address an issue with excessive log entries with S3 backup uploads in the CMON log. These are now only shown in debug mode. (CLUS-1930).
    • Address an issue with error messages when installing Prometheus exporters which are informative in nature and not truly errors (CLUS-1133, CLUS-1926).
    • Address an issue with importing a non-existing cluster successfully (Redis Sentinel) (CLUS-1799).

Maintenance Release: February 20th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6132
    • clustercontrol-1.9.5-8511
  • Controller:
    • Address an issue deleting old backups that were in failed status. Failed backups are now also deleted. (CLUS-1874).
    • Address an issue with the database growth chart showing duplicated days (CLUS-1813).
    • Address an issue when creating a maintenance job on a non-existing cluster (CLUS-1809).
    • Address an issue with the s9s CLI when creating a maintenance job with a timezone other than UTC. The scheduled start time was incorrectly set 1 hour in the future (CLUS-1808).
    • Address an issue when setting up a replica cluster with MySQL-based clusters using mysqldump PITR backups. Only xtrabackup/mariabackup made backups are supported moving forward (CLUS-1850, CLUS-1856).
  • Frontend (UI):
    • Address an issue when setting up a replica cluster with MySQL-based clusters. Only xtrabackup/mariabackup made backups are supported moving forward and mysqldump PITR backups are filtered out. (CLUS-1892, CLUS-1850, CLUS-1856).

Maintenance Release: February 13th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6119
    • clustercontrol-1.9.5-8507
  • Controller:
    • Address an issue with WSREP_CLUSTER_ADDRESS (Galera) where it was set to use the public addresses instead of the internal/local addresses (with AWS) (CLUS-1853).
    • Address an issue with locale setting C.UTF-8 when it is not available for some environments. It will now fall back to the C locale.
    • Address an issue with the systemd service for PostgreSQL on Centos and Oracle Linux 8. Wait instead of sending a Sigkill after the process timeouts.
    • Address an issue with installing the correct PostgreSQL version on RHEL 8 where the default package to install is v10 (CLUS-1857).
  • Frontend (UI):
    • Address an issue with maintenance status showing an incorrect timezone(CLUS-1810).

Maintenance Release: February 6th, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6102
    • clustercontrol-ssh-1.9.5-142
  • Controller:
    • Address an issue with Xtrabackup and partial backups on Percona/Oracle MySQL 8.0. Variable include depends on the Xtrabackup version used (CLUS-1853).
    • Address an issue with an incorrect job message when removing a Primary MS SQL Server after failover(CCV-595).
    • Address an issue with DB Users and MySQL 5.7 when the password is in the grants column (CLUS-1872).
    • Address an issue where adding a new replica did not enable/install the query monitoring agent on the new node with MariaDB&PostgreSQL (CLUS-1861).
    • Address an issue when importing a Galera cluster when the special character ‘£’ was used in the cmon user’s password (CLUS-1839).
    • Address an issue to automatically restart the cmon-ssh process on Centos 8 (CLUS-1854).

Maintenance Release: January 31st, 2023

  • Build:
    • clustercontrol-controller-1.9.5-6084
  • Controller:
    • Address an issue where the Query Monitoring agent failed to install when using no internet/offline repositories (CLUS-1853).
    • Address an issue where a storage alarm was not cleared even though the disk space was reclaimed (CLUS-1672).
    • Address an issue where synchronous replication with PostgreSQL failed to be properly set up (CLUS-1797).
    • Address an issue to show in the job log if compression has been enabled for MS SQL Server backups (CLUS-1812).

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