Changes in v1.8.1

Maintenance Release: March 16^th, 2021

• Build:
  • clustercontrol-controller-1.8.1-4419
• Controller:
  • PostgreSQL: Improved the PostgreSQL connection error handling as it could connect to a non-existing schema.
  • PostgreSQL: Fixed an issue where the database name was lowercased causing the Query Statistics tab in the frontend to fail.

Maintenance Release: March 10^th, 2021

• Build:
  • clustercontrol-1.8.1-7691
  • clustercontrol-controller-1.8.1-4400
• Frontend (UI):
  • ProxySQL: Fixed an issue where the ProxySQL UI was not working correctly when creating a new query rule from top queries.
  • Logs Viewer: Fixed an issue where the log viewer (Logs → System Logs) would show an incorrect amount of logs.
• Controller:
  • PostgreSQL: Fixed a bug preventing users from killing a query in the Running Queries view.

Maintenance Release: March 2^nd, 2021

• Build:
  • clustercontrol-1.8.1-7660
  • clustercontrol-controller-1.8.1-4392
• Frontend (UI):
  • Topology View: Added maintenance mode visualization support in the topology view.
  • LDAP: Fixed an issue where the default user’s timezone has changed after upgrading to ClusterControl 1.8.1.
• Controller:
  • MaxScale: Fixed a dependency issue with libcurl3 for older Ubuntu servers.
  • PgBackrest: Fixed an issue where installing PgBackrest failed with check command requires option: pg1-path.

Maintenance Release: February 23^rd, 2021

• Build:
  • clustercontrol-1.8.1-7639
  • clustercontrol-controller-1.8.1-4383
• Frontend (UI):
  • Backup: Improved field validation for the cron settings.
  • Jobs: A scheduled backups job displayed the current time instead of schedule time in the job title.
  • MySQL: Kill connection did not function due to an issue with host ids.
• Controller:
  • MaxScale: Updated to version 2.5.7.
  • MySQL: Kill connection did not function due to an issue with host ids.
  • Percona XtraDB Cluster: Fixed an issue preventing deployment of 8.0 on Debian 10 (Buster).
  • Logging: Improved logging of dead connections.

Maintenance Release: February 11^th, 2021

• Build:
  • clustercontrol-1.8.1-7621
  • clustercontrol-controller-1.8.1-436​9
• Frontend (UI):
  • Security: Fixed an issue to redirect the user to the login page when a request was blackholed after a session timeout.
• Controller:
  • MySQL 8.0: Added support for new privileges added in MySQL 8.0.23.
  • Systemd scripts for CMON.

Maintenance Release: February 8^th, 2021

• Build:
  • clustercontrol-1.8.1-7605
  • clustercontrol-controller-1.8.1-4362
• Frontend (UI):
  • Query Monitor: Show the time on the Running Queries page in a more user-friendly format.
• Controller:
  • MySQL 8.0: Fixed a bug where an ALTER USER command to change the database user password was issued when using the caching_sha2_password plugin.
  • ProxySQL: Updating the admin user/password did not update the cluster admin/password when ProxySQL Clustering is enabled.
  • Logging: Fixed a bug regarding the log message. A log message from the watchdog thread was printed out using the wrong timezone.
  • PostgreSQL & HAProxy: The PostgreSQL checker script was configured with the wrong password on the slave nodes.

Maintenance Release: January 22^nd, 2021

• Build:
  • clustercontrol-1.8.1-7559
• Frontend (UI):
  • Azure integration: Fixed an issue related to the selection of subnets.
  • Backup: Added an option to skip the md5sum check for a backup job. The md5sum checks may take a long time on large backup files.
  • Backup: Fixed an issue where the wrong warning was printed in the Restore Backup section when the option Restore To Standalone Node was selected.
  • Backup: Rerun failed scheduled backup jobs from the Jobs view.

Maintenance Release: January 21^st, 2021

• Build:
  • clustercontrol-controller-1.8.1-4343
• Controller:
  • Backup: Make it optional to skip the md5sum check for a backup job. The m5sum may take a long time to execute on large backups. This can be configured by setting backup_create_hash in the UI (Settings → Runtime Configuration, no restart needed), or set backup_create_hash in /etc/cmon.d/cmon_X.cnf (where X is the cluster id) and restart cmon.
  • Percona XtraDB Cluster 8.0: Failed deploy on Ubuntu 20.04 and fixes to certificate creation.

Maintenance Release: January 13^th, 2021

• Build:
  • clustercontrol-controller-1.8.1-7527
• Controller:
  • Fixed a bug where netcat_ports used by backup could collide with ports used by e.g Prometheus exporters and services.
  • MongoDB Backup: Check the free space on the storage host before starting back up.
  • CPU Usage Alarm: Made it configurable how long time CPU Usage should be above a Warning/Critical threshold before raising the alarm. This can be set in the cmon configuration file (host_stats_window_size) or from the CMON Settings in the frontend and S9S CLI.

Maintenance Release: January 7^th, 2021

• Build:
  • clustercontrol-1.8.1-7527
• Frontend (UI):
  • The MySQL root password is now correctly set when using the cloud deployment (wizard).
  • The MySQL verify backup job is now containing the entered PITR position or time.
  • The backups page was missing the ‘backed up tables info’ for MySQL partial backups with tables.

Maintenance Release: December 30^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4314
• Controller:
  • Percona Backup for MongoDB: The controller always reports the backup failed, but PBM says the backup completed and there are no error logs.

Maintenance Release: December 28^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4311
• Controller:
  • MySQL Replication: Fixed a bug regarding package dependencies when adding a replication slave using Oracle MySQL 8.0 on CentOS/RHEL 8.

Maintenance Release: December 23rd, 2020

• Build:
  • clustercontrol-controller-1.8.1-4304
• Controller:
  • MariaDB: Adding module_hotfixes=1 to repo files to overcome the MariaDB issue: https://jira.mariadb.org/browse/MDEV-20673.

Maintenance Release: December 18^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4299
• Controller:
  • Verify Backup: Fixed an issue where the Verify Backup would fail on MariaDB 10.2 and later if the MariaDB version of the restore host could not be determined. The error presented itself as /usr/bin/mariabackup: unknown option '--apply-log-only'.

Maintenance Release: December 14^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4294
• Controller:
  • ProxySQL: Deployment fails because of a weak proxydemo user password. Now the proxydemo user is not created at all.

Maintenance Release: December 11^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4292
• Controller:
  • Verify Backup: The Verify Backup job failed for MySQL based system because the Backup Verification Server was in read-only mode.
  • Verify Backup: When verifying mysqldump backups, the binary logs of the Backup Verification Server were not removed.

Maintenance Release: December 10^th, 2020

• Build:
  • clustercontrol-1.8.1-7500
• Frontend (UI):
  • Remove duplicate headers in Query Monitor.

Maintenance Release: December 9^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4285
• Controller:
  • PostgreSQL: Can’t remove PostgreSQL slave in case of co-location.
  • MariaDB: Fixed a bug with Backup Verification doesn’t work on MariaDB 10.2 and later.
  • MongoDB: mongodump logging improvement to add the last 50 lines of its output to the backup job log.

Maintenance Release: December 5^th, 2020

• Build:
  • clustercontrol-1.8.1-7491
• Frontend (UI):
  • Fix for ClusterControl user login. The login username was required to be an email address which prevented LDAP login with a plain username.

Maintenance Release: November 30^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4274
• Controller:
  • MongoDB Percona Backup: Fixed an issue when deleting a backup. The deletion was reported as successful, but it actually failed.
  • MySQL Replication: Fixed a bug where the read_only setting in my.cnf could be inconsistently set on the nodes. The my.cnf file must always have read_only=ON on all nodes.
  • MySQL Replication: Fixed an issue where if the auto_manage_readonly=1 , then a user could set read_only = OFF on a slave. Now the read_only flag will be set to read_only = ON as soon as it is detected.
  • Backups: Fixed the job title of backups executed from schedules. Before the title was set to Backup schedule #N'N, where NN is a number. Now the backup title is properly set to Create Backup.

Maintenance Release: November 23^rd, 2020

• Build:
  • clustercontrol-1.8.1-7473
• Frontend (UI):
  • Backup → Settings → Backup Settings: Customize/set netcat ports to use when streaming backups.
  • Cluster-to-Cluster: The second PostgreSQL slave cluster is now properly linked.
  • Delete Job: Add back support to delete pending jobs via the Activity Viewer.
  • Restore PITR backup: Correctly set/select the node to restore the backup (PITR).
  • Import Cluster: You no longer need to specify vendor or version – it’s automatically detected.
  • Cluster Overview: Setting the same time range sometimes resulted in showing a different range.
• Misc
  • Fix incorrect backup restore confirmation messages.
  • Fix modal and sidebar issues with the restore backup dialog – it now closes properly.
  • Fix broken backup scheduler icon for the jobs in the Activity Viewer.
  • Fix overlapping text in the Logs → Jobs page for smaller screen resolutions.
  • Empty role is now not being created when canceling the role creation.

Maintenance Release: November 18^th, 2020

• Build:
  • clustercontrol-controller-1.8.1-4258
• Controller:
  • MongoDB: Installing PBM on MongoDB release v4.2 failed.
  • MaxScale: Due to an SSH environment problem, a node transitioned between offline and online. Now there is better logging in this area.
  • Scheduled backups: Fixed a bug where the scheduled backup printed out the same ID number (#0) for all backups. It is only a printout/formatting issue.

Initial Release: November 13^th, 2020

• Build:
  • clustercontrol-1.8.1-7442
  • clustercontrol-controller-1.8.1-4249
  • clustercontrol-notifications-1.8.1-261
  • clustercontrol-ssh-1.8.1-99
  • clustercontrol-cloud-1.8.1-263

In this release, we introduce a new consistent backup method for MongoDB Replica Sets and Sharded Clusters, native ProxySQL Clustering support, version updates of supported databases, PITR improvements for MySQL, and last but not least security enhancements on the web UI.

Security is always a top priority, and as a part of the security enhancements, a number of vulnerabilities were fixed in the web UI.

MongoDB 3.6 and later can now use Percona Backup for MongoDB to create consistent backups of replica sets and sharded clusters.

ProxySQL Clustering offers a convenient way to keep a number of ProxySQL servers in sync. For example, if a user is created on a node, then the change is propagated to other clustered ProxySQL nodes.

Let us know what you think about these features and changes anytime!

Feature Details

• MongoDB Backup
  • Uses Percona Backup For MongoDB
  • Backup and Restore Replica sets and Sharded Clusters
• ProxySQL Clustering
  • Leverage the built-in clustering of ProxySQL to keep ProxySQL instances in sync
• Version Updates
  • Percona XtraDB Cluster 8.0
  • MariaDB and MariaDB Cluster 10.5
• Security Improvements
  • Prevent Clickjacking
  • Updated jQuery (3.5.0)
  • CGI Generic Cross-Site Request Forgery Detection
• MySQL PITR enhancements
  • Backup a node and perform PITR on any node in the Cluster