Changes in v1.8.2

Maintenance Release: June 24^th, 2021

• Build:
  • clustercontrol-1.8.2-7950
• Frontend (UI):
  • The cluster name in the web application correctly reflects the name change when using the s9s command-line client.
  • The trial license with a new installation is properly activated.
  • Fixed an issue with webhooks integration not receiving alarm events. An incorrect cluster ID was used/saved.
  • Remove and add back the webhook and/or other integrations again to make sure the correct cluster ID is used/saved.

Maintenance Release: June 23^rd, 2021

• Build:
  • clustercontrol-controller-1.8.2-4631
• Controller:
  • MySQL Replication: Fixed a bug with Promote Slave on Percona Server. The issue was that the gtid_mode was not detected correctly.

Maintenance Release: June 16^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4612
• Controller:
  • Fixed an issue where all the properties were not always reset in the controller following a RESET SLAVE in MySQL/MariaDB.
  • Removed the installation of the MySQL X plugin during Percona XtraDb Cluster 5.7 and Percona Server 5.7 deployments.
  • Fixed an issue where CMON failed to correctly invoke the script specified in the option replication_pre_failover_script.
  • Improved logging for CRON JOB COLLECT_CONFIG errors.

Maintenance Release: June 8^th, 2021

• Build:
  • clustercontrol-1.8.2-7915
• Frontend (UI):
  • Fixed an issue with the backup scheduling. In some cases, only the last schedule would be shown.
  • Fixed an issue with an empty message in the Schedule maintenance window.
  • Fixed an error loading the ClusterControl UI, where it got stuck on Loading Cluster List....

Maintenance Release: June 7^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4596
• Controller:
  • Updated the s9s-tools APT GPG key (as the old one expired) which is used during post-install during package installation.
  • New Feature: Added support for custom init name support for MySQL Replication. The initd/systemctl script can be specified with init_service_name in the cmon_X.cnf file.
  • Fixed: The semi-sync plugin was installed unnecessarily during PXC deployment.
  • Fixed: Installing TimescaleDB on PostgreSQL 13.
  • Fixed: pgbackrest was failing after cmon upgrade due to su must be run from a terminal.
  • Fixed: HAProxy: If an add secondary/replica job failed, then the slave could still be added to the HAProxy load balancer configuration.
  • Fixed: ClusterControl would show that a failed PostgreSQL streaming replication link was actually working.

Maintenance Release: May 31^st, 2021

• Build:
  • clustercontrol-controller-1.8.2-4580
  • clustercontrol-1.8.2-7906
• Frontend (UI):
  • Added back a missing Manage → Processes page in 1.8.2.
  • Changed default repository to Use Vendor Repositories option for Clone Cluster dialog.
  • Fixed an issue where the Clone Cluster option was missing for users created with the new User Management system.
• Controller:
  • Fixed: Installing TimescaleDB on PG12 and on RHEL 8.3, which failed because of the absence of the timescaledb-2-postgresql-12 package.
  • Fixed: A bug restoring Percona Xtrabackup incremental backups using Percona Xtrabackup 8.0.
  • Fixed: Configuring Garbd using SSL on MariaDB 10.5.
  • Fixed: pgbackrest failed after upgrade the ClusterControl from 1.8.1 to 1.8.2.

Maintenance Release: May 26^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4570
• Controller:
  • Fixed a bug for ldaps:// connections coming from OpenLDAP option handling issues.
  • Fixed a bug when restoring a backup from the controller and the backup path or filename contained whitespace.
  • PostgreSQL: Fixed an issue with PgBackRest when the WAL level is different compared to the stanza name.

Maintenance Release: May 20^th, 2021

• Build:
  • clustercontrol-notifications-1.8.2-272
• Notifications:
  • Fixes an issue on the web client where the notifications setup dialog is always showing up at login.
  • Changed how cmon-events retrieves the initial RPC API token.

Maintenance Release: May 19^th, 2021

• Build:
  • clustercontrol-1.8.2-7892
  • clustercontrol-controller-1.8.2-4551
  • clustercontrol-cloud-1.8.2-301
• Frontend (UI):
  • Clone Cluster option is not present for PXC 5.7 on Debian 9.
• Controller:
  • Fixed a bug to prevent multiple recovery jobs from running on the same Prometheus host.
  • Fixed a grant/privilege parsing issue to handle DELETE VERSIONING ROWS in MariaDB 10.5.
  • Improved the cmon.service systemd script to automatically restart cmon after failure.
  • Fixed an issue deploying garbd on Ubuntu 20.0 using PXC 5.7 and PXC 8.0.
  • PostgreSQL: Added a correct recommendation when changing runtime configuration. E.g, changing work_mem is a session variable, but a server restart is required to change it globally.
  • Fixed an issue with Clone Cluster. It failed because of an SSL error. Also, Galera SSL Encryption is not yet supported when Cloning Clusters. In that case, create a new cluster from backup.
• Cmon Cloud:
  • Fixed an issue deploying Debian 10 clusters on AWS.

Maintenance Release: May 12^th, 2021

• Build:
  • clustercontrol-1.8.2-7878
  • clustercontrol-cloud-1.8.2-298
  • clustercontrol-clud-1.8.2-298
  • clustercontrol-controller-1.8.2-4531
• Frontend (UI) & Cloud:
  • Support for uploading backups to any cloud storage providers who provide an AWS S3 API compliant object storage API. You need to have both the latest ClusterControl web, CMON controller and the cloud packages.
  • PostgreSQL: Fix upgrades for single-node deployments.
  • Fixe an issue with opening the SSH Web console.
• Controller:
  • MariaDB: Failed to RESET MASTER when creating a slave cluster. The fix is to toggle only the wsrep_on session variable for MariaDB too, instead of the global one.
  • MongoDB: Fixed an issue with PBM rendering backup file size 0.
  • MySQL Deployment: Failed to create a cluster due to --super-read-only.

Maintenance Release: May 7^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4518
• Controller:
  • MySQL 5.7 and 8.0: Add replication slave from could fail due to --super-read-only.
  • PostgreSQL: Fixed an issue where the replication credentials are not used when you import an existing PostgreSQL slave node.
  • Fix for a crash situation by disabling the parsing of the global ssh known hosts file.

Maintenance Release: April 27^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4494
• Controller:
  • Database Growth: Added more log messages to assist in debugging.
  • PostgreSQL: ClusterControl could not detect that PostgreSQL replication is running and working fine. This was fixed by improving the primary_conninfo collection. Now we use data also from pg_stat_wal_receiver.

Maintenance Release: April 26^th, 2021

• Build:
  • clustercontrol-1.8.2-7862
  • clustercontrol-cloud-1.8.2-287
• Controller:
  • Create Slave Cluster: It now shows the backup time for the backups that can be used when staging a slave cluster.
  • Query Monitoring: Fix layout issues on the settings page.
  • Topology View: PgBouncer is now properly visualized/shown.
  • Backups: Fixes the backup page stuck on please wait for some users,
  • PHP 5.4 (RHEL/CentOS 6): Revert PHP array syntax to make the web application work with PHP 5.4.
  • Navigation: Fix an issue with re-directing to the cluster list page when opening the activity viewer.
  • Community License: Fix a login issue choosing to run ClusterControl with the community license.
  • Mail notifications: Fix an issue with loading a new team/group into the list view,
  • PostgreSQL: The Query Monitor → DB Connections now shows the ‘database’ and ‘user’.
  • Alarm Badge: Fix for an issue with the badge counts being different on the cluster list versus in the cluster overview page.
  • Users and Schemas: Prevent empty MySQL grant statements to be sent
• Cloud:
  • Cloud Deployment: Add options for Ubuntu 20.04, CentOS 8 and Debian 10. Debian 8 is no longer supported.

Maintenance Release: April 20^th, 2021

• Build:
  • clustercontrol-cloud-1.8.2-286
• Cloud:
  • Fixed an issue when deploying to CentOS 7 on AWS. Updated AMIs.

Maintenance Release: April 16^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4478
• Controller:
  • NDB Cluster: Updated version to 8.0.23.
  • PostgreSQL: Top Queries in PostgreSQL 13 was not working due to column name changes in pg_stat_statement table (the total_time changed to total_exec_time etc).
  • PostgreSQL: Cluster-to-cluster replication was not correctly shown properly when using PostgreSQL 13 due to a column name change in pg_stat_wal_receiver.

Maintenance Release: April 9^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4467
• Controller:
  • Alarms: Changed the redundant indexes alarm text where it was suggested to navigate to the Table Analyzer instead of the Schema Analyzer.
  • General: Improved stability by disabling code in release builds that in rare cases could cause crashes.

Maintenance Release: April 7^th, 2021

• Build:
  • clustercontrol-1.8.2-7804
• Frontend (UI):
  • DB Schema and Users: Fixes an issue with opening the individual tabs/pages like the Create Database page.
  • Create New Admin User: This shows a better error message and a possible fix to try if there is an issue creating a new admin user for the new user management system. Follow the instructions and try to reset the so-called ‘ccrpc’ user needed by the frontend for this specific case. The script to run is located at /var/www/html/clustercontrol/app/tools/reset-ccrpc.sh.

Maintenance Release: April 6^th, 2021

• Build:
  • clustercontrol-1.8.2-7788
• Frontend (UI):
  • The backup list is now showing also showing the backup job duration.
  • DB User Management: Fix for lower casing the table name when adding a grant in the form of <schema>.<tableName>.
  • Query Monitor: Fix a performance issue with Query Statistics – The result sets are now paginated properly.
  • Fix for a permission issue when importing Keepalived nodes.
  • Prometheus MySQL Dashboard (exporter): Collect and show MySQL server user stats.
  • PgBouncer: Prevent whitespace in PgBouncer pool names and fix for showing the wrong message when importing a PgBouncer node.

Maintenance Release: March 31^st, 2021

• Build
  • clustercontrol-1.8.2-7760
  • clustercontrol-controller-1.8.2-4453
• Frontend (UI):
  • Deploy: A help text regarding custom templates was missing in the tooltip for the Configuration Template.
  • PgBouncer: Added syntax highlighting in the configuration file editor.
  • ProxySQL: Hide blacklisted users from ProxySQL import users wizard.
  • New User management: Fixed a couple with access to Key Management and Email Notifications when logged in with a user of the new user management.
• Controller:
  • PgBouncer: Import PgBouncer fails: Pid not found, while PgBouncer is running and the PID file exists.
  • PgBouncer: Fixed an issue where the create pool dialog allows the User to enter pool name with spaces.
  • Reverting a change of disabling socat when it is used with a hostname starting with a number. In some older versions of socat, having a hostname starting with a number would cause socat to fail/hang.
  • Database Growth (PostgreSQL): Added more job messages making it easier to debug problems.
  • Error reports: More data collected, e.g runtime_mysql_galera_hostgroups from ProxySQL.

Maintenance Release: March 26^th, 2021

• Build:
  • clustercontrol-1.8.2-7748
  • clustercontrol-controller-1.8.2-4443
• Frontend (UI):
  • Prevent <webroot>/clustercontrol/app/webroot/build directory from being viewable.
  • Use a separate S9S_USER_CONFIG config file for the ‘ccrpc’ command line user.
• Controller:
  • MariaDB 10.5: Added support for new privileges (READONLY ADMIN)

Maintenance Release: March 24^th, 2021

• Build:
  • clustercontrol-controller-1.8.2-4436
• Controller:
  • MySQL: Rebuild replication slave failed because was super_read_only=ON.
  • MySQL: Cluster-to-Cluster Replication setup failed due to a secure connection requirement when the caching_sha2_password plugin was used.

Initial Release: March 23^rd, 2021

• Build:
  • clustercontrol-1.8.2-7732
  • clustercontrol-controller-1.8.2-4431
  • clustercontrol-notifications-1.8.2-267
  • clustercontrol-ssh-1.8.2-105
  • clustercontrol-controller-1.8.2-4431

Welcome to our first release of 2021! We have quite a few changes under the hood that will eventually require action to be taken by our users.

The ClusterControl web application is now able to use the improved and more secure RPC v2 API which has been used by our s9s command-line tool for quite some time. One of the key changes is that it allows us to provide a better User Management system to manage users, teams and access control.

This, unfortunately, requires a few steps to be taken on your part in order to switch to the new system:

• Existing ClusterControl users need to be re-created – Create a new ‘admin’ user in the new system with the ‘create admin user’ wizard, then login with that user and then create any remaining users and teams again.
• An existing LDAP server configuration needs to be re-created – Logon with your new ‘admin’ user and then create the LDAP configuration again. Please check for instructions here.

Beginning with this release our new features and UX/UI improvements are only accessible if you are logged in with the new User Management system!

We are planning to completely phase out the old User Management system from June 2022 until then both versions will be concurrently supported by the web application. Critical bug fixes and other minor cosmetic fixes are going to be maintained with both versions of the User Management systems until the old system is phased out.

Feature Details

• New User and LDAP Management – A new system to manage users via the ClusterControl controller with improved security, central user database, access control and LDAP support.
  Both the web application and the s9s command-line client will now use the same user database.
  • Create users, teams with access control for different roles
  • LDAP support for authenticating ClusterControl users with the most popular LDAP server options
  • Unified user database to keep web application users and command-line users in perfect unison
  • Underlying user management system based on the Unix/Linux filesystem permissions
• New Patch Management – A improved and redesigned patch management system to upgrade MySQL, PostgreSQL and ProxySQL nodes.
  • Show installed packages and versions
  • Check/update for new packages to upgrade
  • Selective upgrade of nodes
• PgBouncer – connection pooler for PostgreSQL
  • Pool/optimize connections to one or more databases.
  • Deploy PgBouncer on one or more nodes
  • Manage multiple pools per node
  • Pool modes
    • Session
    • Transaction
    • Statement
  • Prometheus exporter and dashboard
• PostgreSQL
  • Support for PostgreSQL v13 (deployment and import)
  • Enable pgaudit extension for audit logging
  • Class of statements that can be logged
    • READ: SELECT and COPY when the source is a relation or a query.
    • WRITE: INSERT, UPDATE, DELETE, TRUNCATE, and COPY when the destination is a relation.
    • FUNCTION: Function calls and DO blocks.
    • ROLE: Statements related to roles and privileges: GRANT, REVOKE, CREATE/ALTER/DROP ROLE.
    • DDL: All DDL that is not included in the ROLE class.
    • MISC: Miscellaneous commands, e.g. DISCARD, FETCH, CHECKPOINT, VACUUM, SET.
    • MISC_SET: Miscellaneous SET commands, e.g. SET ROLE.
    • ALL: Include all of the above.
• Tags / Labels – Tag clusters to quickly identify one or more clusters that are used for a specific reason
  • Add tags at cluster deployment
  • Add tags at cluster import
  • Search / filter out clusters that have specific tags
• Misc:
  • MySQL Cluster 8.0 (NDB) support
  • Percona MongoDB 4.x audit log support – only via s9s command line at the moment
  • Host/server connection check whenever an IP/hostname is entered with form wizards