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

Changes in v1.8.2

Maintenance Release: April 7th, 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 6th, 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 31st, 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 26th, 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 24th, 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 23rd, 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
Was this article helpful to you? Yes No