Changes in v1.7.6

Maintenance Release: September 10^th, 2020

• Build:
  • clustercontrol-1.7.6-7237
• Frontend (UI):
  • OpsGenie: Fixed a bug where the Integration could not be created due to Failed to parse request body:...
  • OpsGenie: Updated instructions. The API Key must be the API Key of the Team that may be used: https://docs.opsgenie.com/docs/api-key-management
  • HAProxy: Fixed a bug where disable HAProxy failed because UI didn’t send the hostname parameter to the job.
  • MariaBackup: Fixed an issue with partial backups. It was not possible to specify databases/tables.

Maintenance Release: September 8^th, 2020

• Build:
  • clustercontrol-contoller-1.7.6-4130
• Controller:
  • Oracle/MySQL 8.0 compatibility & testing fixes.

Maintenance Release: September 2^nd, 2020

• Build:
  • clustercontrol-1.7.6-7207
  • clustercontrol-contoller-1.7.6-4120
• Frontend (UI):
  • Topology View: Fixed an issue to avoid flickering on cluster update.
  • Topology View: Fixed an issue showing the topology for 3 or more multi-masters.
  • ProxySQL: The IP/Hostname Address column was truncated in ProxySQL Processlist.
• Controller:
  • MongoDB: Node menu does not appear for MongoDB ReplicaSet due to an internal error.
  • MongoDB: Fixed a bug causing Mongo shard recovery to fail and Mongos is started last.
  • Prometheus: Upgraded node_exporter to 1.0.1 (no incompatible changes) with some typo fixes.
  • Prometheus: Bump Prometheus version to 2.20.1.
  • [improvement] OS Support: Updated compatibility matrix to support Ubuntu 20.04.

Maintenance Release: August 27^th, 2020

• Build:
  • clustercontrol-contoller-1.7.6-4108
• Controller:
  • OS Detection: Fixed an error to be more tolerant to extra lines introduced by SSH login to a host. This caused an issue when detecting the operating system.
  • CMON Schema: Fixed an issue with the cmon_log_entries the table that has an invalid Foreign Key.
  • ProxySQL: Deploy fails on Debian 10 in combination with Percona or Oracle/MySQL 8.0.
  • Fixed an issue on MySQL based system where the rebuild replication slave would fail when using uppercased hostnames.

Maintenance Release: August 17^th, 2020

• Build:
  • clustercontrol-1.7.6-7158
  • clustercontrol-contoller-1.7.6-4083
• Frontend (UI):
  • Dashboards: Fixed an issue in the Replication dashboard where the Master Server ID was presented as a decimal value and not an integer.
• Controller:
  • ProxySQL: Fixed a bug with logs getting flooded with SAVE MYSQL SERVERS TO DISK and LOAD MYSQL ... commands if there was a MySQL server not present in the ProxySQL Server’s mysql_servers table.
  • Alarms: Fixed a timezone problem between the reported date in the Alarm Digest email and the triggered Alarm. Now the DateTime has the same timezone in both cases.

Maintenance Release: August 11^th, 2020

• Build:
  • clustercontrol-1.7.6-7146
  • clustercontrol-contoller-1.7.6-4077
• Frontend (UI):
  • Fixed an issue with retrieving roles where a non-super-admin LDAP users always end up at the first cluster in the list.
  • Fixed an issue editing an OpsGenie integration which prompted the user to enter information in a field, but it was not possible.
• Controller:
  • HAProxy: Fixed an issue using non-default ports as a user-specified value would be set to the default.
  • Mariabackup: A fix for Mariabackup 10.4.14 which has dropped support for some options.
  • Deployment: Fixed a bug deploying Percona on CentOS 8.

Maintenance Release: August 4^th, 2020

• Build:
  • clustercontrol-1.7.6-7124
  • clustercontrol-notifications-1.7.6-254
• Frontend (UI):
  • Galera: Fixed an issue that made it impossible to activate Galera SSL Encryption when SSL Encryption was enabled.
  • Galera: Server Load graphs were not properly initialized when there was no data to graph (e.g, because a server was down for a period of time).
  • ServiceNow integration: Fixed a layout issue, and improved the usability by adding an All Clusters to simplify when having many clusters. This fix also includes two new fields: Service and Configuration Item.
• Notifications service:
  • ServiceNow: Added support for Service and Configuration Item.

Maintenance Release: August 3^rd, 2020

• Build:
  • clustercontrol-controller-1.7.6-4068
• Controller:
  • Galera: Fixed a bug deploying Percona Server and XtraDB Cluster on CentOS 8.
  • PostgreSQL: Fixed an issue with PgBackRest using user-defined stanzas to prevent default configuration options defined by the controller from being set as command-line options. Thus, only the options set in the user-defined stanza will be used and nothing else.

Maintenance Release: July 27^th, 2020

• Build:
  • clustercontrol-1.7.6-7082
  • clustercontrol-controller-1.7.6-4059
• Frontend (UI):
  • Cloud Deployment: Fixed an issue where the wrong disk size unit (GB) was sent in the job instead of MB.
  • Backup/Restore (MySQL-based): Fixed a couple of UX issues. Restoring a backup using Point In-time Recovery (PITR) may only be executed on the cluster nodes where the backup was created. All other options are now disabled (Restore on standalone/create a cluster from backup).
  • Import MySQL Replication: The option Import as a standalone node has been removed as it did not have any purpose.
• Controller:
  • MySQL 8.0: Fixed an issue with parsing privileges in a GRANT statement (INNODB_REDO_LOG_ENABLE the privilege was missing).
  • Replication: Fixed an issue retrieving/creating user account information in case there was one server in the setup and it was not configured as a master. The error manifested itself as Server not found while trying to create an account.
  • Replication: Improved the behavior by not raising an alarm and disabling auto-recovery if the setting auto_manage_readonly=false is specified and the cluster has multiple writable masters.
  • Replication: Enable/Disable read-only job: Failed to run if auto_manage_readonly=false.
  • ProxySQL: Failed to sync instance in ProxySQL (GRANT option).

Maintenance Release: July 20^th, 2020

• Build:
  • clustercontrol-1.7.6-7059
  • clustercontrol-controller-1.7.6-4047
• Frontend(UI):
  • Integrations: Fixed a bug when adding cluster on integration channel if cluster name only 2 characters.
  • PostgreSQL: Enable TimescaleDB for PostgreSQL 12.
  • User Management: Fixed an issue preventing a SuperAdmin used logged in from LDAP to change a cluster team.
• Controller:
  • PostgreSQL: Fixed an issue where the controller failed to parse pg_hba.conf when a line ends up with empty space before a new line.
  • PostgreSQL: Ensure that directories created for PostgreSQL have the correct rights and even the newly created parent directories, such as /etc/postgres.
  • General: Extended OS compatibility matrix with Ubuntu Server 20.04 LTS (Focal Fossa).

Maintenance Release: July 10^th, 2020

• Build:
  • clustercontrol-controller-1.7.6-4036
• Controller:
  • A fix for a race condition when the SSH connection is lost for a moment when sampling processes. This could lead to the process (e.g HAProxy, Garbd, ProxySQL) to have the wrong state for a short period of time.
    MongoDB: Consistent backup failed because the Storage Host was not set.

Maintenance Release: July 5^th, 2020

• Build:
  • clustercontrol-controller-1.7.6-4026
• Controller:
  • Galera: Improved Cluster Split detection. Now, the cluster_size is measured over a three-second period, and the cluster will enter a failed state if the cluster_size is not the same on all nodes after this period of time.
  • PostgreSQL: Rebuilding a PostgreSQL node as a slave could make it appear with the role set to master (but non-writable, and streaming from the writable master).
  • ProxySQL: Removed unnecessary log messages when installing ProxySQL.

 Maintenance Release: June 28^th, 2020

• Build:
  • clustercontrol-1.7.6-6996
  • clustercontrol-controller-1.7.6-4013
• Frontend (UI):
  • Query Monitor: Running Queries did only appear on the last page when filtering on hosts.
  • User Management: The number of visible Teams/LDAP groups was limited and more than 33 groups could not be shown in the UI.
• Controller:
  • Query Monitor: Purge Query Monitor for MySQL did not purge the performance_schema.events_statements_summary_by_digest.
  • Ping time was set incorrectly (to a big value) when blocked by firewall or ICMP disabled in conf. Now it is set to -1 if blocked by the firewall or disabled.
  • HAProxy: It was possible to import a non-existing HAProxy.
  • ProxySQL: Fixed a bug syncing instances error when a database name contains backslash.
  • ProxySQL: Fixed an issue with MariaDB when importing users with a role in ProxySQL.
  • ProxySQL: Fixed an issue Installing ProxySQL 1.x failed on CentOS7.
  • ProxySQL: Could not install version 1 to two nodes in the same job.
    ProxySQL: Failed to stop the ProxySQL service while removing and uninstalling the node.

Maintenance Release: June 20^th, 2020

• Build:
  • clustercontrol-1.7.6-6976
  • clustercontrol-controller-1.7.6-3995
• Frontend (UI):
  • Query Monitor: Fixed a bug when purging data in the Query Monitor.
• Controller:
  • SSL Certificates: Fixed a bug that prevented self-signed certificates to be imported. The error manifested itself as: Error 'CA certificate: Empty PEM string'.
  • MaxScale: The MaxScale nodes could in some situations appear as not available or offline, but the process was actually running.
  • Backups: Fixed a bug where a backup could end up in the wrong backup directory if the backup was re-executed too soon after a failed backup.

Maintenance Release: June 16^th, 2020

• Build:
  • clustercontrol-1.7.6-6959
  • clustercontrol-controller-1.7.6-3985
• Controller:
  • Monitoring/disk: Skip monitoring NFS filesystem.
  • PostgreSQL: In case of an inconsistent view (master down, but load balancer or slave reports it is up) then performs double-check using SSH.
  • PostgreSQL: Log the replication failure alarm reasoning and server disconnected reason in the alarm text.
• Frontend (UI):
  • MongoDB: Dashboards metrics updated to support new mongodb_exporter. A re-install of the MongoDB exporter is needed, which is done from the Dashboards action menu.
  • Schema Analyzer: Showed no data for community edition.
  • Stop Node action must always be visible. Even if the node is down/unknown.
  • Backup Scheduling: An issue specifying the time when using advanced settings.
  • User management: A User with Admin role cannot open the mail notifications page
  • User management: Users are shown in the wrong group (fixed ‘All users’ logic).
    User management: LDAP users can’t see alarms or jobs.

Maintenance Release: June 8^th, 2020

• Build:
  • clustercontrol-controller-1.7.6-3972
• Controller:
  • ProxySQL: Supporting MariaDB roles when importing users to ProxySQL.
  • MongoDB: Upgraded mongodb_exporter to v0.11.0 to support newer MongoDB versions.
  • HAProxy: Fixed an issue where the node appears online but the VM is not even running.
  • Galera: Failed to create a slave cluster from backup for Galera.
  • PostgreSQL: Cluster-to-Cluster replication shows Cluster Failure in the slave cluster.
  • PostgreSQL: Failed to Create Slave Cluster on TimescaleDB.
  • Notifications: Extended the fallback email address query with, dcps.users with company_id=0, and the RPCv2 owner user of the cluster. This ensures that an admin that can see all clusters will get notifications from all clusters.

Maintenance Release: May 15^th, 2020

 

• Build
  • clustercontrol-1.7.6-6868
  • clustercontrol-controller-1.7.6-3940
• Frontend (UI):
  • CC Teams and Users management issue (removed the strict linking on the company for SuperAdmin).
• Controller:
  • PostgreSQL: Slave rebuild doesn’t work for PostgreSQL.
  • PostgreSQL: Failed create PostgreSQL cluster from pg_basebackup.
  • PostgreSQL: Remove slave (recovery/standby) signal files after restoring pg_basebackup.
  • Galera: Automatic failover is not working on MariaDB Cluster with slave nodes.
  • Galera: Create Galera Cluster From Backup fails.
  • Galera: Creating a Slave Cluster using PXC 5.6 failed. See note above.
  • Galera: Galera recovery fails repeatedly if automatic recovery is enabled (huge dataset) because of a systemd script timeout. Now CMON will patch the vendors’ broken systemd script.
  • Galera: PXC 5.7 failed to deploy on Centos 8.
  • MySQL/Galera: Added parser support for new MySQL 8.0 privileges.
  • ProxySQL: Fix for wildcard handling in MySQL grants (fixes a ProxySQL import users issue).
  • MongoDB: Deployment fails and fixed by preventing /var/run and /run from any owner/access changes, it makes the SSH connections failing.

Maintenance Release: May 6^th, 2020

• Build:
  • clustercontrol-1.7.6-6854
    clustercontrol-controller-1.7.6-3910
• Frontend (UI):
  • HAProxy: Auto-filling HAProxy socket, port, and credentials fields are not working in the import section (fixed template).
• Controller:
  • PostgreSQL: Fix a pg_hba.conf parsing error (whitespace in empty lines).
  • PostgreSQL: Bugfix for duplicated pg_hba.conf entries.
  • PostgreSQL: Bugfix for repetitive CREATE ROLE calls following a failover.
  • MongoDB: Backups created by s9s CLI did not contain the node name in the backup file.
  • MaxScale: Remove/Register fixes.
  • MySQL: A strong root password is now auto-created if not specified explicitly by the job.
    MySQL: Refresh variables after restarting a node so the node is up to date in the UI.
  • Prometheus: Make sure tar and gzip are installed to be able to deploy the packages.
  • cmon_upgrade.log: Add timestamp and filenames.

Maintenance Release: May 3^rd, 2020

• Build:
  • clustercontrol-1.7.6-6846
• Frontend (UI):
  • HAProxy: Import error, fixed the job spec.
  • Redundant nodes when Select Stream from Master in Create Slave Cluster dialog.
  • Backup: Got error Cannot set unknown key encrypt_backup on RecordType in the UI when configuring backup with verifying backup (added property to Verification model and fixed unit tests).
  • CSS fixes.

Maintenance Release: April 27^th, 2020

• Build:
  • clustercontrol-controller-1.7.6-3892
• Controller:
  • s9s_error_reporter is not working for Cluster ID 0 (fixed error-report fallback path).
  • PostgreSQL: Include the pgdg common repository for PgBackRest on CentOS/RHEL.
  • PostgreSQL: Fixes to failover in case of deleting/erasing the master’s datadir.
  • PostgreSQL: Ping lets do a disconnect first, so we can detect if no new connection can be made to the PostgreSQL server.
  • MySQL: Bugfix for parsing the role syntax of a MySQL database user, which could lead to the frontend failing to handle the request to show database users in Manage → Schema and Users.

Maintenance Release: April 22^nd, 2020

• Build:
  • clustercontrol-1.7.6-6830
  • clustercontrol-controller-1.7.6-3880
• Frontend (UI):
  • Backup Schedule: When changing a backup method (from non-PgBackRest) to PgBackRest it could cause the UI to become stuck.
  • Overview graph: The Cluster Overview graph was truncated in some cases to 30 minutes instead of 1 hour.
• Controller:
  • Verify Backup: A user will be notified by email if the verification fails.
  • PostgreSQL: Backup Verification made a backup of datadir before restoring the backup, which was unnecessary.
  • PostgreSQL: Fixed an issue with replication lag calculation and alarming.
  • PostgreSQL: Skip nodes from failover whose lagging more than MAX_REPLICATION_LAG setting.
    MySQL Replication: A fix for rebuilding replication slave where there was a race condition checking if MySQL is down.
  • Galera: Fixed an issue when manipulating the my.cnf files that could manifest themselves as Got error Could not read 'wsrep_provider_options' when enabling Galera SSL Encryption.
  • Galera: Add a Replication Slave in PXC 5.7 overwrote the my.cnf if it was a symlink.
  • Password Escaping: Fix a password escaping issue in cmon configuration, that could lead to e.g the Prometheus database exporters to fail to connect to the database.
  • LibSSH: Fixes to prevent zombie/defunct ssh proxy commands (such as sssd_ssh_known_hosts_proxy) processes due to a missing waitpid in libssh.

Initial Release: April 10^th, 2020

• Build:
  • clustercontrol-1.7.6-6815
  • clustercontrol-controller-1.7.6-3854
  • clustercontrol-notifications-1.7.6-251
  • clustercontrol-cloud-1.7.6-241
  • clustercontrol-ssh-1.7.6-92

Feature Details

• Cloud Deployment of HAProxy
  • Deploy a database stack containing your favorite SQL database and HAProxy load balancer.
• MySQL Freeze Frame (BETA)
  • Snapshot MySQL process list before cluster failure.
• Misc:
  • CMON Upgrade operations are logged in a log file.
  • Many improvements and fixes for PostgreSQL Backup, Restore, and Verify Backup.
  • A number of legacy ExtJS pages have been migrated to AngularJS.