Release notes v1.6.1

Maintenance Release: July 4^th, 2018

• Build:
  • clustercontrol-1.6.1-4896
• UI:
  • Identical host charts fix for SQL and Data Nodes with MySQL Cluster (NDB).
  • ‘DB User Management’ fix with MySQL Cluster (NDB). Create and edit DB users works again.

Maintenance Release: June 28^th, 2018

• Build:
  • clustercontrol-controller-1.6.1-2621
• Controller:
  • MariaDB: Deployment fix caused by a mix up of authentication_string and password in the mysql.user table.
  • Restore slaves/Rebuild nodes (MySQL, PostgreSQL) – Making the directory of the datadir backup configurable. Specify datadir_backup_path in /etc/cmon.d/cmon_X.cnf. By default, the datadir will be copied (after the server has been shut down, but before restoring/rebuilding) using a filesystem copy to {datadir}_bak.
  • Error reporting: A fix to also include the include files of a database node configuration file.
  • Alarms: Fixed an issue when the measured value was a NaN or INF.
    MySQL: Add Node could fail due to a bug in version detection.
  • General: A fix allowing other jobs to run in parallel with remove cluster jobs.

Maintenance Release: June 26^th, 2018

• Build:
  • clustercontrol-1.6.1-4865
• UI:
  • Remove the default 0 sized cc-ldap.log files from the package overwriting the existing ldap log file.

Maintenance Release: June 15^th, 2018

• Build:
  • clustercontrol-1.6.1-4848
  • clustercontrol-controller-1.6.1-2605
  • clustercontrol-notifications-111
• UI:
  • Fix schedule backup verification with mysqldump.
  • Fix empty configuration template dropdown for add node (MySQL Galera).
  • Fix to allow controller host timezone when scheduling maintenance mode.
  • Fix for the schedule maintenance mode dialog closing immediately.
  • Fix stuck scrolling with the PostgreSQL advisor’s page.
  • Fix missing validation for the xtrabackup --use-memory option.
  • Add ‘Lock DDL per table’ option for xtrabackup.
  • Fixes to cmon-events to handle filtering correctly.
• Controller:
  • Alarms/Notifications: Fixed a bug refreshing alarm thresholds. This prevented user-specified thresholds in cmon_X.cnf from being applied.
  • Mongo: Adding numa node number check before installing or using numactl for mongo.
  • PostgreSQL host granting (pg_hba) fixed.
  • PostgreSQL: show error log when node failed to start.
  • PostgreSQL: Fixed an issue with pg_hba file error when using IPv6.
  • PostgreSQL/HAProxy: HAProxy did not refresh Postgres node state after rebuilding of a slave.
  • ProxySQL: Include more data in the error report.
  • ProxySQL: Adding sanity check on admin port for registering existing proxysql node.
  • ProxySQL: Updated ProxySQL galera checker script to use 1.4.8
  • Galera: Fixed a crashing bug in case of missing wsrep_sst_auth.
  • Maxscale: Fixed so that the software will not be installed if it is already installed on the node.
• Events/Notifications:
  • Fixed a bug that ignored the configured filter. This caused e.g a Warning alarm to create a notification when only Critical was configured.

Initial Release: May 25^th, 2018

• Build:
  • clustercontrol-1.6.1-4801
  • clustercontrol-controller-1.6.1-2572
  • clustercontrol-cmonapi-1.6.1-324
  • clustercontrol-notifications-1.6.1-94
  • clustercontrol-cloud-1.6.1-121
  • clustercontrol-ssh-1.6.1-53

Feature Details

• Backup:
  • Support for MariaDB Backup for MariaDB based clusters. MariaDB Server 10.1 introduced MariaDB Compression and Data-at-Rest Encryption which is supported by MariaDB Backup (a fork of Percona XtraBackup).
  • Support for Schema(--no-data) or Data(--no-create-info) only backups and skipping extended insert(--skip-extended-insert) with mysqldump.
  • Support for --use-memory with xtrabackup.
  • Support for custom backup subdirectory names:

Set the name of the backup subdirectory. This string may hold standard %X field separators, the %06I for example will be replaced by the numerical ID of the backup in 6 field-wide format that uses ‘0’ as leading fill characters. Default value: BACKUP-%I.

• Variable: B
• Description: The date and time when the backup creation was beginning.
• Variable: H
• Description: The name of the backup host, the host that created the backup.
• Variable: i
• Description: The numerical ID of the cluster.
• Variable: I
• Description: The numerical ID of the backup.
• Variable: J
• Description: The numerical ID of the job that created the backup.
• Variable: M
• Description: The backup method (e.g. mysqldump).
• Variable: O
• Description: The name of the user who initiated the backup job.
• Variable: S
• Description: The name of the storage host, the host that stores the backup files.
• Variable: %

• Description: The percent sign itself. Use two percent signs, %% the same way the standard printf() function interprets it as one percent sign.

• PostgreSQL:

  • Synchronous Replication Slaves.
  • Multiple NICs support:

Deploy DB nodes using management/public IPs for monitoring connections and data/private IPs for replication traffic.
Deploy HAProxy using management/public IPs and private IPs for configurations.

• Misc:
  • ServiceNow has been added as a new notifications integration.
  • Support for MaxScale 2.2.
  • Database User Management (MySQL) can now search/filter accounts on username, hostname, schema or table.
  • Node page graphs are now showing accurate time ranges and datapoint gaps.
  • Query Monitoring is using the CMON RPC API.
  • Database Growth is using the CMON RPC API.
  • Support for PHP 7.2 with an upgraded CakePHP version 2.10.9