2. Home
  4. Docs
  6. ClusterControl
  8. Changelogs
  10. Changes in v1.7.1

Changes in v1.7.1

Maintenance Release: March 25th, 2019

  • Build:
    • clustercontrol-controller-1.7.1-3085
  • Controller:
    • Resolve hostnames (to IPv4) when checking a host if it exists already in other clusters.
    • MongoDB: adding missing sharding:cluster role:shardsrv value in mongod.conf when add node job is used.
    • MaxScale: connection not authorized after the deploy with CC. More fixes to improve 2.3 and later support.
    • Backup: Do not fail backup if wsrep desync can’t be turned off, and we must set the retention on the backup report even if it was marked as failed.
    • Monitoring/SCUMM: haproxy_exporter: Don’t append --haproxy.scrape-uri if it is already set.
    • Replication: Can’t add replication slave to an existing slave. Let’s be stricter and do not tolerate >1 writable when setting up.
    • s9s_error_reporter: make sure cmon is started, also print out the service status.
    • PostgreSQL: Fixing an issue when a system file protection method denied the proxy-disable file removal
      Package handling/YUM: Fix for a situation when package update gets stuck on user input (to accept some GPG signature).
    • SSH: A fix/workaround to handle the ‘forced user password change’ situation if the user password expires (passwd --expire USERNAME) and is prompted to change upon successful authentication.
      SSH: Limit the number of sent newline chars.
    • Updated Oracle repository key due to expiration.

Maintenance Release: March 18th, 2019

  • Build:
    • clustercontrol-1.7.1-5812
  • Frontend:
    • Allow empty SMTP username and SMTP password for the SMTP configuration.
    • Fix an issue for failing to stop MySQL slave threads (IO and SQL).

Maintenance Release: March 5th, 2019

  • Build:
    • clustercontrol-controller-1.7.1-3056
  • Controller:
    • Advisors: Fixed an issue with the wsrep_cluster_address.js were an internalHostName method was missing.
    • MongoDb: Use the mongodb OS user depending on the OS and package when setting up SSL.
    • PostgreSQL: Fixed a PostgreSQL grant failure because of client locale setting.
    • PostgreSQL: Workaround a PostgreSQL service initdb bug. Now we call directly the initdb binary. The relevant original bug report: https://www.postgresql.org/message-id/[email protected]

Maintenance Release: February 27th, 2019

  • Build:
    • clustercontrol-notifications-1.7.1-173
  • Notifications:
    • Fix for cmon-events to prevent Avast to report it as a malware (Telegram API).
    • Fix for cmon-events to start even if the MySQL server has not started first.

Maintenance Release: February 20th, 2019

  • Build:
    • clustercontrol-1.7.1-5720
  • Frontend (UI):
    • Keepalived: Fixed an issue importing Keepalived.
    • HAProxy: Dashboard fixes (SCUMM).
    • Nodes Page: Removed the tab Logs as it is deprecated and found in Logs → System Logs instead.

Maintenance Release: February 18th, 2019

  • Build:
    • clustercontrol-controller-1.7.1-3032
  • Controller:
    • Maria Backup: Fixed an issue parsing LSN in mariabackup >= 10.2.22.
    • Prometheus: Fixed an issue when restarting a failed exporter.

Maintenance Release: February 13th, 2019

  • Build:
    • clustercontrol-controller-1.7.1-3027
    • clustercontrol-1.7.1-5700
  • Frontend (UI):
    • ProxySQL: Fixed an issue in the pagination structure in ProxySQL sync making it impossible to Import/Export/Sync ProxySQL Configurations.
    • Fixed an issue regarding REPLICATION LAG where the lag was presented as a derived value instead of an absolute when viewing the individual servers.
    • Fixed an issue with rebuild replication slave from the incremental backup dialog.
  • Controller:
    • Fixed an issue regarding stats aggregation. This could manifest itself as spikes in particularly the REPLICATION_LAG.
    • Keepalived: Small update for registering keepalived; the service port must be corrected to 112.
    • Process Management: A fix for a file descriptor leak when an internal object was reused.
    • MongoDb 4.0: A fix for creating mongodb replica sets by checking executed mongodb commands for more error messages.
    • Galera: A fix to the wsrep_cluster_address.js advisor to also check the internal/private hostname/IP-addresses.
    • MySQL: skip missing grant alarms on backup-verification nodes.

Maintenance Release: February 6th, 2019

  • Build
    • clustercontrol-controller-1.7.1-3016
    • clustercontrol-1.7.1-5673
  • Frontend (UI):
    • Deploy HAProxy on PostgreSQL: Fixed an issue where the dialog was stripped and did not load completely.
    • Performance →DB Variables: Variables with different values are not marked in red
    • Dashboards: System Overview, improved the readability of the CPU Usage chart.
    • PostgreSQL Query Monitor: Removed tuning advice and the option to purge queries as it is not possible at all.
  • Controller:
    • Configuration Changes: Fixed an issue where the owner and privileges of a config file were not preserved.
    • Deploy/Create Cluster From Backup: A fix to prevent the restore backup from running in another job.
    • ProxySQL: Replaced old galera_checker script for proxysql to a new 2.0 version one
    • ProxySQL: Improved s9s CLI and cmon such that making a proxysql configuration backup can be performed using the s9s CLI.
    • Advisors: A new script to check prepared statement exec limits. The advisor script must be manually scheduled by the administrator.
    • Alarm Notifications: The Memory Utilisation alarm was not showing all processes in the included top view.

Maintenance Release: January 22nd, 2019

  • Build:
    • clustercontrol-controller-1.7.1-2294
    • clustercontrol-notifications-1.7.1-168
  • Backend:
    • MySQL/Galera: Fixed a bug in related to the loading of Disk/CPU/Net stats on the Cluster Overview page.
    • HAProxy/ProxySQL/Garbd: Disable firewall/selinux (if requested by the job, default is true for both values).
    • Replication: Added a small hint about --report-host the argument being required to add existing slaves.
    • MongoDB: Fixed an issue when a rolling restart was attempted, but a stop/start of the cluster is required when setting up SSL.
    • MongoDB: Added a server_selection_try_once, server_selection_timeout_ms to allow the user to fine-tune connection settings when e.g the network is slow. Run cmon --help-config to see the complete description.
  • ClusterControl notifications:
    • Fixes to logging.
    • The license check failed due to the wrong field name, preventing e.g notification plugins from receiving alarm events.

Maintenance Release: January 13th, 2019

  • Build:
    • clustercontrol-controller-1.7.1-2985
  • Backend:
    • Bugfix for SSH connection negotiation failure on compression methods.
    • HAProxy: A configuration error could occur when adding a new node, a none word was wrongly added to the HAProxy configuration.
    • HAProxy: Deploying HaProxy fails when it builds from the source. Missing zlib1g-dev and zlib dependency.
    • HAProxy: xinetd port was missing a default value. It now defaults to port 9200.
    • Point-in-time Recovery (MySQL): Binary logs could be applied in the wrong order.
    • MySQL Replication: Switchover hooks do not work (replication_pre_switchover_script and replication_post_switchover_script are now executed to Promote Slave).
    • ProxySQL: Importing a user from MySQL fails to duplicate the grants.
    • Prometheus: A fix to collect the log file from the Prometheus host, instead of the exporter host.
    • Create a cluster job fails on permissions of ssh user when the username contained \.
    • NDB Cluster: Updated to use MySQL Cluster 7.5.12 binaries.
    • Operational Reports: A fix to avoid repetition of node information in the ‘System Report’.
    • Cloud: A fix to improve the auto registration of the cmon-cloud binary and improved logging. This also requires a new version of cmon-cloud (new build coming soon).

Maintenance Release: December 29th, 2018

  • Build:
    • clustercontrol-1.7.1-5622
    • clustercontrol-notifications-1.7.1-159
  • Frontend (UI):
    • MySQL Galera: Fix Add Node regression where the template file was not set in the job specification.
    • Prevent cmon-events to crash if cmon is not running.

Initial Release: December 21st, 2018

  • Build:
    • clustercontrol-controller-1.7.1-2854
    • clustercontrol-1.7.1-5617
    • clustercontrol-cloud-1.7.1-163
    • clustercontrol-notifications-1.7.1-157
    • clustercontrol-ssh-1.7.1-70
    • clustercontrol-cmonapi-1.7.1-338

In this release, we have primarily continued to add improvements to our agent-based monitoring dashboards and PostgreSQL.

Feature Details

  • Agent-Based Monitoring:
    • Install/enable Prometheus exporters on your nodes and hosts with MySQL, PostgreSQL and MongoDB based clusters.
    • Customize collector flags for the exporters (Prometheus). This allows you for example to disable collecting from MySQL’s performance schema if you experience load issues on your server.
    • Supported Exporters:
      • Node/host metrics.
      • Process – /proc metrics.
      • MySQL server metrics.
      • PostgreSQL metrics.
      • ProxySQL metrics.
      • HAProxy metrics.
      • MongoDB metrics
    • Dashboards:
      • System Overview.
      • Cluster Overview.
      • MySQL Server – General.
      • MySQL Server – Caches.
      • MySQL InnoDB Metrics.
      • Galera Cluster Overview.
      • Galera Server Overview
      • PostgreSQL Overview.
      • ProxySQL Overview.
      • HAProxy Overview.
      • MongoDB Cluster Overview.
      • MongoDB ReplicaSet.
      • MongoDB Server.
  • Backup:
    • Create a cluster from an existing backup with MySQL Galera or PostgreSQL.
  • PostgreSQL:
    • Query Monitoring improvements – View query statistics:
      • Access by sequential or index scans.
      • Table I/O statistics.
      • Index I/O statistics.
      • Database Wide Statistics.
      • Table Bloat And Index Bloat.
      • Top 10 largest tables.
      • Database Sizes.
      • Last analyzed or vacuumed.
      • Unused indexes.
      • Duplicate indexes.
      • Exclusive lock waits.
    • Verify/restore the backup on a standalone host
    • Create a cluster from an existing backup.
    • Support for PostgreSQL 11. Deploy and import clusters.
  • MongoDB:
    • Support to deploy/import and manage MongoDB Inc v4.0
  • Misc:
    • New license format. Please contact [email protected] for a new license.
    • Continuing moving ExtJS pages to AngularJS. This time the load balancer and nodes page.
    • UI logging for troubleshooting web application issues.
    • ClusterControl Backup/Restore – This feature can be used to migrate a setup from one controller to another controller. Backup the metadata of an entire controller or individual clusters from the s9s CLI. The backup can then be restored on a new controller with a new hostname/IP and the restore process will automatically recreate database access privileges.
Was this article helpful to you? Yes No