Release notes v1.7.4

Maintenance Release: December 16^th, 2019

• Build:
  • clustercontrol-1.7.4-6594
  • clustercontrol-controller-1.7.4-3596
• Frontend (UI):
  • AWS: Updated region dropdown list.
• Controller:
  • PostgreSQL: Failed to start PostgreSQL after VM halt and reboot because of a missing socket directory.
  • HAProxy: Fixed a parser issue and add '^' also to supported string/regexp characters list.

Maintenance Release: December 1^st, 2019

• Build:
  • clustercontrol-controller-1.7.4-3565
• Controller:
  • Replication: Removing BVS server failed.
  • Deploy: Dropped ntp package dependency during deployment.

Maintenance Release: November 23^rd, 2019

• Build:
  • clustercontrol-1.7.4-6537
  • clustercontrol-controller-1.7.4-3556
• Frontend (UI):
  • Topology View: Show link to the remote cluster.
  • Rebuild Replication Slave: Wrong cluster-id was sent in the job.
• Controller:
  • ProxySQL 2.x: Setting writer_is_also_reader=2 in mysql_galera_hostgroups.
  • ProxySQL 1.x: Sync Instances fails with no such table: mysql_galera_hostgroups.
  • HAProxy: Fixed HAProxy parser (an extended string with the following chars: |[]).
  • MySQL: Backups can’t be taken with xtrabackup 2.4.12.

Maintenance Release: November 18^th, 2019

• Build:
  • clustercontrol-controller-1.7.4-3543
• Controller:
  • Crashing bug.

Maintenance Release: November 17^th, 2019

• Build:
  • clustercontrol-1.7.4-6513
  • clustercontrol-controller-1.7.4-3541
• Frontend (UI):
  • Rebuild Replication Slave: Wrong cluster-id was sent in the job.
• Controller:
  • Email/digest: Fixed an issue sending too many digest messages sent in certain cases.
  • Email/digest: Fixed an issue sending blank digest emails.
  • Host Discovery: Fixed a deadlock issue.
  • PostgreSQL: Rebuilding a slave failed as the master could not be found.

Maintenance Release: November 9^th, 2019

• Build:
  • clustercontrol-controller-1.7.4-3527
  • clustercontrol-1.7.4-6483
• Frontend:
  • Query Monitor → Running Queries: Refresh button and fixed an issue limiting the result set to 200 records.
  • Alarms: Fixed a bug with ignoring alarms.
• Controller:
  • ProxySQL: Failed to deploy with an import configuration option.
  • Cluster-to-Cluster Replication: Failed to locate master when creating slave cluster from backup.
  • Replication: Percona Server 8.0 replication cluster creation failed during repl_user user creation.

Maintenance Release: November 6^th, 2019

• Build
  • clustercontrol-controller-1.7.4-3519
• Controller:
  • Cluster to cluster replication: Check the master exists in the parent cluster before attempting to stage the cluster.

Maintenance Release: November 1^st, 2019

• Build:
  • clustercontrol-controller-1.7.4-3512
  • clustercontrol-1.7.4-6483
• Frontend (UI):
  • MySQL: Added an option to RESET SLAVE / RESET SLAVE ALL.
  • MongoDB: Removed MongoDB 3.2 as an option on Ubuntu 18.04.
  • Dashboard: Added Dashboards to the ACL list.
  • Query Monitor → Running Queries: Refresh button and fixed an issue limiting the result set to 200 records.
• Controller:
  • ProxySQL 2.0: The proxysql_galera_checker script is not needed any longer and instead ClusterControl uses the mysql_galera_hostgroups table.
  • PostgreSQL: Copy some mandatory values from the master’s config into the slave’s config when configuring replication (as per https://www.postgresql.org/docs/9.6/hot-standby.html#HOT-STANDBY-ADMIN ).
  • PostgreSQL: Database growth had an issue when detecting disk space.

Initial Release: October 28^th, 2019

• Build:
  • clustercontrol-1.7.4-6459
  • clustercontrol-controller-1.7.4-3503
  • clustercontrol-cloud-1.7.4-220
  • clustercontrol-ssh-1.7.4-84
  • clustercontrol-notifications-1.7.4-190

In this release, we now support cluster to cluster replication for MySQL Galera and PostgreSQL clusters. One primary use case is for disaster recovery by having a hot standby site/cluster which can take over when the main site/cluster has failed. We also added support for MariaDB 10.4/Galera 4.x, ProxySQL 2.0, and managing database users for PostgreSQL clusters.

Feature Details

• Cluster to Cluster Replication
  • Asynchronous MySQL replication between MySQL Galera clusters.
  • Streaming replication between PostgreSQL clusters.
  • Clusters can be rebuilt with a backup or by streaming from a master cluster.
• Misc
  • MariaDB 10.4/Galera 4.x support.
  • ProxySQL 2.0 support.
  • Database User Management for PostgreSQL clusters.