Table of Contents
Maintenance Release: June 12th, 2019
- Build:
- clustercontrol-controller-1.7.2-3142
- Controller:
- Fixed a CmonDB schema issue on older MySQL server versions manifesting itself as
Specified key was too long; max key length is 767 bytes
. - MaxScale: A fix for imported MaxScale. When importing MaxScale, the utility
maxctrl
is used and works currently only with socket communication on the MaxScale host itself. - Jobs: Log files contain job spec with sensitive data.
- MariaDB: Fixed an issue with the deployment of MariaDB 10.0 on Centos 6 failed.
- Postgres: Fixed a bug that could crash cmon in case wal log retention was disabled and fixed a printout in PITR job output.
- Fixed a CmonDB schema issue on older MySQL server versions manifesting itself as
Maintenance Release: May 24th, 2019
- Build:
- clustercontrol-1.7.2-6137
- Frontend (UI):
- Memory leak fixes when leaving the web application open for extended periods of time (days).
Fixes to the database software upgrades form to show correct versions supported.
Note: Only upgrades within minor versions are supported.
- Memory leak fixes when leaving the web application open for extended periods of time (days).
Maintenance Release: May 24th, 2019
- Build:
- clustercontrol-1.7.2-6069
- clustercontrol-controller-1.7.2-3199
- Frontend (UI):
- Deployments: Custom configuration templates can now be selected at deployment.
- Cluster Overview:
- Server Load graphs were not properly displayed (PostgreSQL).
- Changing the ‘Server Load’ graph would not accurately show only one metric (PostgreSQL).
- Disk Reads/Writes and Uptime were set to 0 (PostgreSQL).
- Disk bytes read/written were not calculated with the correct sector value of 512 bytes.
- Switching between dashboards with a specific set of steps could cause the overview page to render an empty page.
- Controller:
- Deadlock detection temporarily disabled for MySQL/Percona 8.0. It will be supported in the next major release.
- mysqldump failed with MySQL/Percona 8.0 because of
missing show_compatibility_56=ON
the setting. It is now on for versions >= 5.7.6. - Agent Based Monitoring (Prometheus):
- Uptime were set to 0.
- Disk stats for the controller is now also available.
node_disk_written_bytes_total
|node_disk_read_bytes_total
are now also collected.
- Reverting to nc instead of socat on Ubuntu 16.04 due to a bug with socat’s server name resolve when it starts with a number.
- Manual failover with MariaDB 10.1 for MySQL Replication cluster is now correctly flushing logs before switchover.
- Restore backup on Mongos (routers) failed to copy the data
dir.
Maintenance Release: May 16th, 2019
- Build:
- clustercontrol-controller-1.7.2-3185
- clustercontrol-1.7.2-6032
- Frontend (UI):
- Nodes Page: Fixed an issue with y-axis scaling on the Disk Utilization chart.
- Nodes Page: Selecting the menu ‘Add Replication Slave’ and start adding slave was impossible when a Node recovery job was running.
- MongoDB: Fixed an issue where the Restore backup dialog would not close after pressing Finish
- .Controller:
- Monitoring/SCUMM: PostgreSQL exporter and MySQL exporter URL password encoding fix which could cause a No data points in Dashboards →Postgres Overview.
- Monitoring/SCUMM: A fix for disk stats to be properly shown when using LVM volumes in the Nodes →Disk charts.
Maintenance Release: May 7th, 2019
- Build:
- clustercontrol-controller-1.7.2-3167
- Controller:
- MySQL 8.0: Updated imperative language files to support the previous release build issue: Fixed an issue preventing db users from being created on MySQL 8.0.
Maintenance Release: May 6th, 2019
- Build:
- clustercontrol-1.7.2-5997
- clustercontrol-controller-1.7.2-3163
- Frontend (UI):
- Filtering out incomplete/failed backups from restoring backup dialogs.
- MySQL Single (standalone servers): Fixed filtration logic to show the Master Nodes for MySQL Single clusters.
- Controller:
- MySQL 8.0: Fixed an issue preventing db users from being created on MySQL 8.0.
- Config file handling fix for docker (we mount
/etc/cmon.d
there and/etc/cmon.d/cmon.cnf
is the main config)
Maintenance Release: April 30th, 2019
- Build:
- clustercontrol-1.7.2-5989
- clustercontrol-controller-1.7.2-3155
- Frontend (UI):
- Query Monitor → Query Outliers: Fixed an issue related to date range.
- Performance → Innodb Status: Fixed an issue when the InnoDB Status was not always shown.
- Controller:
- ProxySQL: Fixed an issue with importing users on MariaDB 10.2 and later.
- Galera: Fixed an issue when the recovery job was closed prematurely. This had the effect that Create Cluster could fail.
- SCUMM: Preserve the exporters of other clusters in Prometheus configuration during (re)deployment. (Note: Users with multiple clusters and wrong Prometheus configuration may need to re-deploy the Prometheus on the affected [No data point] clusters).
- Query Monitor: Fixed an issue where queries were dropped following a schema update when upgrading clustercontrol-controller.
Maintenance Release: April 19th, 2019
- Build:
- clustercontrol-1.7.2-5959
- clustercontrol-controller-1.7.2-3141
- Frontend (UI):
- Query Monitor: Selecting/clicking on a query didn’t show the query details.
- Query Monitor: Top queries page was empty for a single node Galera cluster.
- MongoDB:
- Restore the backup menu item was missing.
- The restore backup dialog form was empty for single node replica sets.
- Spotlight: Performance improvements when you have several clusters/nodes.
- Cloud deployments now use the same package versions as the on-premise deployments.
- Controller:
- MySQL Replication: Fixed an issue with slave promotion causing an errant transaction to appear.
- Security: Fixed permissions on all cmon generated config files to be 0600.
- Galera (MariaDb): Increased start timeout for a longer SST in the
mariadb.service
override systemd file.
Initial Release: April 4th, 2019
- Build:
- clustercontrol-1.7.2-5926
- clustercontrol-controller-1.7.2-3117
- clustercontrol-cmonapi-1.7.2-342
- clustercontrol-notifications-1.7.2-176
- clustercontrol-ssh-1.7.2-73
- clustercontrol-cloud-1.7.2-196
We are proud to announce an expansion of the databases we support to include TimescaleDB, a revolutionary new time-series that leverages the stability, maturity and power of PostgreSQL. TimescaleDB can ingest large amounts of data and then measure how it changes over time. This ability is crucial to analyzing any data-intensive, time-series data. For ClusterControl, this marks the first time for supporting time-series data; strengthening our mission to provide complete life cycle support for the best open source databases and expanding our ability to support applications like IoT, Fintech and smart technology.
In this release you can now deploy a TimescaleDB and also turn an existing PostgreSQL server to a TimescaleDB server. PostgreSQL clusters also support a new backup method pgBackRest, database growth charts and improvements to manage your configuration files.
MySQL users can start to deploy and import MySQL 8.0 servers with Percona and Oracle MySQL and our new Spotlight search helps you navigate through pages, find nodes, and perform actions faster.
Finally, we are also providing a beta version to setup CMON / Controller High Availability using several ClusterControl instances wired with a consensus protocol (raft) between them.
Feature Details
- TimescaleDB – optimized for time-series data using SQL – more documentation coming soon!
- Deploy a TimescaleDB server with PostgreSQL (v9.6, v10.x and v11.x).
- Turn an existing PostgresQL server (v9.6, v10.x and v11.x) into a TimescaleDB server.
- PostgreSQL
- Database growth graphs. Track the dataset growth on your databases.
- Support for
pgBackRest
as a backup tool:- Create full, differential, and incremental backups.
- Restore full, differential, incremental backups.
- PITR – Point In Time Recovery is supported.
- Enable compression and specify compression level.
- MySQL 8.0 Support
- Cluster deployment and import of ‘replication’ type clusters available with:
- Percona Server for MySQL 8.0.
- Oracle MySQL 8.0 Server.
- Support for
caching_sha2_password
.
- Cluster deployment and import of ‘replication’ type clusters available with:
- CC Spotlight
- Use our new spotlight search to quickly open pages, find nodes/hosts, and perform cluster and node actions.
- Click on the search icon or use the keyboard shortcut CTRL+SPACE to bring up the spotlight.
- CMON / Controller High Availability (BETA)
- CMON HA is using a consensus protocol (raft) to provide a high availability setup with more than one cmon process.
- Setup a ‘leader’ CMON process and a set of ‘followers’ which share storage and state using a MySQL Galera cluster.
- Misc
- Support the use of private IPs when you deploy a cluster to AWS.
- MaxScale – improved support for v 2.2 and later using maxctrl.
- Automatic vendor/version detection for importing MariaDb/MySQL based clusters.