Skip to content

Releases: canonical/mysql-operator

Revisions 366, 367

31 Mar 12:18
@github-actions github-actions
rev366
bb5a1d2
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revisions 366, 367 Latest
Latest

A new revision of Charmed MySQL has been published in the 8.0/stable channel on Charmhub.

See also: Releases overview page, How to perform an upgrade

What's Changed

This section outlines the most important features and bug fixes in this release.

Features

Bug fixes

Full Changelog: rev312...rev366

Technical details

This section contains some technical details about the charm's contents and dependencies.

If you are jumping over several stable revisions, check previous release notes before upgrading.

Requirements and compatibility

This charm revision features the following changes in dependencies:

  • (increased) MySQL version to v8.0.41
  • (increased) Snap revision 138/139

Important

This release of Charmed MySQL requires Juju v.3.4.3 or 3.5.2+. See the guide How to upgrade Juju for a new database revision.

Contributors

paulomach, shayancanonical, and sinclert-canonical
Assets 2
Loading

Revisions 312, 313

02 Dec 17:25
@github-actions github-actions
rev312
c9aae8b
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revisions 312, 313

A new revision of Charmed MySQL VM has been published in the 8.0/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Features

Bug fixes

Full Changelog: rev240...rev312

Technical details

This section contains some technical details about the charm's contents and dependencies.

If you are jumping over several stable revisions, check previous release notes before upgrading.

Requirements and compatibility

This charm revision features the following changes in dependencies:

  • (increased) MySQL version v8.0.39

Important

This release of Charmed MySQL requires Juju v.3.4.3 or 3.5.2+. See the guide How to upgrade Juju for a new database revision.

See the system requirements page for more details about software and hardware prerequisites.

Packaging

This charm is based on the charmed-mysql snap Revision 113/114. It packages:

Contact us

Charmed MySQL is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.

  • Raise software issues or feature requests on GitHub
  • Report security issues through Launchpad
  • Contact the Canonical Data Platform team through our Matrix channel.
Loading

Revision 240

26 Jun 20:53
@github-actions github-actions
rev240
858e07f
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 240

A new revision of Charmed MySQL VM has been published in the 8.0/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Important

The current charm revision requires Juju 3.4.3/3.5.2+!

If you are jumping over several stable revisions, make sure to check previous release notes before upgrading to this revision.

Features

Bug fixes

  • Fixed MAAS deployment [PR#444][DPE-3115]
  • Fixed single unit upgrade [PR#340][DPE-2662]
  • Fixed dateformat in logrotate config to avoid causing filename conflicts after 24hrs of uptime [PR#363][DPE-3063]
  • Stops logging FLUSH LOG statements to the MySQL binlog which is causing GTID conflicts and prevents the member from self-healing [PR#336]
  • Fixed rollback for unsupported MySQL datadir [DPE-3392]
  • Updated TLS test lib and test charm [PR#392][DPE-3403]
  • Fixed floor value for max_connections [PR#398]
  • Fixed max_connections calculation [#429]DPE-3706
  • Fixed KeyError when no ca-chain [PR#403][DPE-3688]
  • Fixed broken state (after the restart) [PR#381][DPE-2618]
  • Fixed error messaging when no bucket for backup [PR#350][DPE-2758]
  • Avoid setting secret upon TLS relation broken if using juju secrets [PR#360][DPE-2677]
  • Fixed logrotate file path [PR#374]
  • Started using labels for internal secrets [PR#348][DPE-2886]

Canonical Data issues are now public on both Jira and GitHub platforms.
GitHub Releases provide a detailed list of bugfixes, PRs, and commits for each revision.

Full Changelog: rev196...rev240

Inside the charms

  • Charmed MySQL ships the latest MySQL 8.0.36-0ubuntu0.22.04.1
  • mysql-shell CLI tool updated to 8.0.36+dfsg-0ubuntu0.22.04.1~ppa4
  • Backup tools xtrabackup/xbcloud updated to 8.0.35-30
  • The Prometheus mysqld-exporter is 0.14.0-0ubuntu0.22.04.1~ppa2
  • VM charms based on Charmed MySQL snap (Ubuntu LTS 22.04.4) revision 103
  • Principal charms supports Ubuntu LTS series 22.04 only

Technical notes

Contact us

Charmed MySQL is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.

  • Raise software issues or feature requests on GitHub
  • Report security issues through Launchpad
  • Contact the Canonical Data Platform team through our Matrix channel.
Loading

Revision 196

06 Oct 17:07
@github-actions github-actions
rev196
f0abc40
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 196

A new revision of Charmed MySQL VM has been published in the 8.0/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Features

Bug fixes

Canonical Data issues are now public on both Jira and GitHub platforms.
GitHub Releases provide a detailed list of bugfixes/PRs/Git commits for each revision.
Highlights for the current revision:

  • #209 Use special user for backups + miscellaneous backups fixes
  • #216 Fix/join units refactor by
  • #223 Add auto-tuning for max_connections
  • #224 Optimize mysqlsh calls on library by
  • #254 Miscellaneous improvements to the mysql legacy relation
  • #296 Fixed MySQL memory allocation, consider 'group_replication_message_cache_size'
  • DPE-1626 Add timeout kwarg to run_mysqlcli_script
  • DPE-2215 Fix wait timeout for shared-db
  • DPE-2089 Improve charm to add snap alias charmed-mysql.mysql -> mysql
  • DPE-2352 Restart mysql exporter upon monitoring password change
  • DPE-1979 Fixed machine deployments where hosts are not resolvable
  • DPE-1519 Stabilized integration with mysql-route
  • DPE-2455 Fix bug that caused unnecessary truncation of the mysql hosts cache
  • DPE-2214 Avoid resetting workload if recovery from unreachable state unsuccessful
  • DPE-2478 Use actual observer pid in databag + reduce volume of secrets related logs
  • DPE-2217 Preemptively switch primary on scale-down
  • DPE-2401 Hold snap revision by default
  • DPE-2485 Resolve race condition when restarting after configure_instance
  • DPE-988 Fixed standby units (9+ cluster members are waiting to join the cluster)
  • DPE-2177 Stop configuring mysql user root@% (removed as no longer necessary)

Full Changelog: rev151...rev196

What is inside the charms

  • Charmed MySQL ships the latest MySQL “8.0.34-0ubuntu0.22.04.1”
  • CLI mysql-shell updated to "8.0.34-0ubuntu0.22.04.1~ppa1"
  • Backup tools xtrabackup/xbcloud updated to "8.0.34-29"
  • The Prometheus mysqld-exporter is "0.14.0-0ubuntu0.22.04.1~ppa1"
  • VM charms based on Charmed MySQL SNAP (Ubuntu LTS “22.04” - ubuntu:22.04-based)
  • Principal charms supports the latest LTS series “22.04” only.
  • Subordinate charms support LTS “22.04” and “20.04” only.

Technical notes

How to reach us

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report.
Contribute to the project!

Note

Please check all the previous release notes if you are jumping over the several stable revisions!

Loading

Revision 151

20 Apr 12:59
@github-actions github-actions
rev151
7786741
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 151

A new revision of Charmed MySQL VM has been published in the 8.0/stable channel.

See also: Releases overview page, How to perform an upgrade

Features

  • Deploy on VM (tested with LXD, MAAS)
    • juju constraints are supported to limit CPU/RAM/Storage size
  • Scaling up/down in one simple juju command
  • HA using Innodb Group replication
  • Full backups and restores are supported when using any S3-compatible storage
  • TLS support (using “tls-certificates” operator)
  • DB access outside of Juju using “data-integrator”
  • Data import using standard tools e.g. mysqldump, etc.
  • Documentation:
Charm Version Charm channel Documentation License
MySQL 8.0.32 8.0/stable (r151) Tutorial, Readme, Contributing Apache 2.0

Full Changelog: https://github.com/canonical/mysql-operator/commits/rev151

What is inside the charms

  • Charmed MySQL charm ships the latest MySQL “8.0.32-0ubuntu0.22.04.2”
  • VM charms based on our SNAP (Ubuntu LTS “22.04” - core22-based)
  • Principal charms supports the latest LTS series “22.04” only.
  • Subordinate charms support LTS “22.04” and “20.04” only.

Technical notes

Compatibility with legacy charms:

  • New MySQL charm is a juju-interface compatible replacement for legacy charms such as “MariaDB”, “OSM MariaDB”, “Percona Cluster” and “Mysql Innodb Cluster” (using legacy interface “mysql”, via endpoints “mysql” and “mysql-root”). Other legacy interfaces such as “mysql-router” interface (“db-router” endpoint) and “mysql-shared” interface (“shared-db” endpoint) are also supported. However, it is highly recommended to migrate to the modern interface ‘mysql_client ’. It can be easily done using the charms library ‘data_interfaces’ from ‘data-platform-libs’.

Please contact us, see details below, if you are considering migrating from other “legacy” charms not mentioned above. Additionally:

  • Tracks description:
    • Charm MySQL charm follows the SNAP track “8.0”.
  • No “latest” track in use (no surprises in tracking “latest/stable”)!
    • Charmed MySQL charms provide legacy charm through “latest/stable”.
  • Charm lifecycle flowchart diagrams: MySQL.
  • Modern interfaces are well described in “Interfaces catalogue” and implemented by 'data-platform-libs'.

How to reach us

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report. Contribute to the project!

The document was originally posted here.

Loading