Changes in v1.9.4

Maintenance Release: November 30^th, 2022

• Build:
  • clustercontrol-controller-1.9.4-5956
• Controller:
  • Address an issue with stopping failed master when >1 writeable node is found (CLUS-1527).
  • Address an issue to restore an encrypted backup from another cluster (CLUS-1612).
  • Address an improvement to stop a replica if the replication has a failure instead of keeping the replica running. A new CMON configuration parameter replication_stage_failure_stop_node=true|false can be used to set the behavior (CLUS-1532).
  • Address an issue with HAProxy when a PgBouncer node is removed from the cluster so that HAProxy redirects to an existing node in the cluster, i.e., not the previously removed PgBouncer node (CLUS-1614).
  • Address an issue where we could end up with multiple primaries after failover (PostgreSQL) (CLUS-1602).
  • Address an issue where CMON keeps overwriting the mysql-server_version variable for ProxySQL. It now sets it once at deployment (CLUS-1638).
  • Address an issue with recovery jobs stuck in a running state (CLUS-1681).
  • Address an issue with email alerts where the date header was off with 2h (CLUS-1682).

Maintenance Release: October 10^th, 2022

• Build:
  • clustercontrol-controller-1.9.4-5826
• Controller:
  • Address an issue installing MySQL 5.7 on Debian 11 (CLUS-1604).
  • Address calculating DB growth where the number of tables to include was limited to 25. It’s now a configurable variable cmon_max_table_on_db_size_calc and set to 100 by default (CLUS-1561).
  • Address an issue where a deleted user’s sessions were automatically terminated (CCV2-542).
  • Address an issue using a local mirrored repository when adding new nodes. The vendor repo was used instead of the local repository (CLUS-1600).
  • Address and issue to include cluster_id in the cluster list result set (CCV2-516).
  • Address a segfault issue with MongoDB and DB growth calculation (CLUS-1516).
  • Address an improvement to pass controller-id and MySQL-DB to cmon at start (CLUS-1588).

Maintenance Release: September 27^th, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5809
• Controller:
  • Address an issue rebuilding a PostgreSQL replica node on Centos if the postgresql.conf is stored in the data directory. (CLUS-1569).
  • Address and issue where Invalid Security Configuration error alarm was sent even though cluster_ssl_enforce was set to false on MariaDB 10.2 (CLUS-1550).

Maintenance Release: August 31^st, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5750
• Controller:
  • Address an issue with unregistering HAProxy nodes (CLUS-1518)
  • Upgrade of the my.cnf template file for MariaDB Galera Cluster 10.6+

Maintenance Release: August 29^th, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5742
• Controller:
  • Address an issue to still show FQDN for MS SQL Server when short names are used to set up Availability Groups (CCV2-502).
  • Address an issue with Oracle MySQL and Percona 8.x to use caching_sha2_password as the default authentication plugin.
  • Address an issue with ProxySQL when importing MySQL users with caching_sha2_password. A ‘plaintext password’ is required otherwise the user will be skipped during import (CLUS-1342).

Maintenance Release: August 23^rd, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5730
• Controller:
  • Address an issue to set the correct backend mysql-server_version in ProxySQL (CLUS-1473).
  • Address an issue where root@localhost was still used (testing the connection) when adding a new replication slave (CLUS-1455).
  • Address an issue for MaxScale where static changes to /etc/maxscale.cnf had no effect new load_persisted_configs=false is now the default which makes changes to /etc/maxscale.cnf priority rather than dynamic changes which are saved to /var/lib/maxscale/maxscale.cnf.d (CLUS-1476).

Maintenance Release: August 17^th, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5720
  • clustercontrol-1.9.4-8407
• Controller:
  • Address an issue where HAProxy admin user and password in the advanced settings were not properly set (CLUS-1409).
  • Address an issue with PostgreSQL primary failover failure. All cluster nodes are now granted in all pg_hba.conf files at cluster deployment. (CLUS-1459).
  • Address an issue to drop cmon_host_log table since it no longer is in use.
  • Address an issue with MS SQL Server deployments using FQDN (CCV2-485, CCV2-473 Note: Additional improvements are in progress).
• Frontend (UI):
  • Address an issue with MongoDB Replicaset deployment to support arbitrator nodes (CLUS-1458).
  • Address an issue to show a link to the T&C on the login page (CLUS-1464).

Maintenance Release: August 8^th, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5695
  • clustercontrol-notifications-1.9.4-321
  • clustercontrol-1.9.4-8402
• Controller:
  • Address an issue where ProxySQL deployment fails on MariaDB 10.6 (CLUS-1460).
  • Address an issue where DB user/account creation fails on MariaDB 10.6 (CLUS-1431, CLUS-1449, CLUS-1456).
  • Address an issue to include Controller/CMON and cluster name for notifications (CLUS-1416).
  • Address an issue removing keepalived nodes (CLUS-1462).
• Frontend (UI):
  • Address an issue where the cluster load graph was stuck on loading (CLUS-1451).

Maintenance Release: July 29^th, 2022

• Build:
  • clustercontrol-controller- 1.9.4-5669
  • clustercontrol-1.9.4-8396
• Controller:
  • Address an issue with backward compatibility on MongoDB where the role detection using the isMaster command was removed for older versions (CLUS-1446)
  • Address an issue where the deployment job for HAProxy with PostgreSQL got stuck (CLUS-1450)
  • Address an issue with ProxySQL synchronization where using a user other than ‘proxysql-monitor’ failed to migrate to the new instance (CLUS-1367)
  • Address further improvements to support ProxySQL users with sha2 passwords (CLUS-1342)
• Frontend (UI):
  • Address an issue adding MongoDB arbiter which failed because the incorrect type was used (regular router/mongos) (CLUS-1444)
  • Address an issue with the PgBouncer deploy/import page not showing up properly (CLUS-1437)

Maintenance Release: July 22^nd, 2022

• Build:
  • clustercontrol-1.9.4-5638
• Controller:
  • Address an issue where a stopped cluster changed state to failure instead of stopped (CLUS-1425)
  • Address an issue where the ProxySQL synchronization job failed but showed up as successful (CLUS-1426)
  • Address an issue where deleting a ProxySQL user only deleted it from the backend and not the frontend (CLUS-1428)
  • Address an issue when updating the ProxySQL frontend user entry which did not update the backend entry (CLUS-1430)
  • Address an issue with minor upgrades with MariaDB where packages to upgrade failed to match (CLUS-1362)

Initial Release: July 18^th, 2022

• Build:
  • clustercontrol-1.9.4-8386
  • clustercontrol-controller-1.9.4-5624
  • clustercontrol-notifications-1.9.4-312
  • clustercontrol-ssh-1.9.4-127
  • clustercontrol-cloud-1.9.4-353
  • clustercontrol-clud-1.9.4-353

A: Yes, you can separate the master and data nodes to be on different hosts.

Q: What are the minimum requirements for a clustered Elasticsearch deployment?

A: Yes, you can separate the master and data nodes to be on different hosts.

You need:

• At least three nodes in the master role
• At least two nodes in the data role
• At least two nodes of each role; master and data

Q: Can I rebuild an Elasticsearch node?

A: No there is no need, the Elasticsearch cluster automatically partitions the dataset across all available data nodes. You can remove and add a data node if you need to for example terminate and relaunch the VM the node runs on.

Q: Can I deploy other load balancers like ProxSQL with ClusterControl v2’s web application?

A: Not yet with this release, unfortunately. We are working on adding the remaining supported load balancers and connection pooling. Expect it to be available in an upcoming release of the ClusterControl v2’s user interface.

• ProxySQL
• MaxScale
• Garbd
• PgBouncer (coming soon)

ProxySQL has some limited functionality which will be available in upcoming releases. Currently, these node pages are ready:

• Rules
• Servers

Work In Progress (coming soon)

• Monitor
• Top Queries
• Users
• Variables
• Schedules scripts
• Node performance
• Process list