Database Support
Unless stated, MySQL refers to the following variants:
MySQL Community Edition
MySQL Enterprise Edition
Percona MySQL
Version Support Matrix
| Database | MySQL Version | Tungsten Version | Notes |
|---|---|---|---|
| MySQL | 5.7 | All non-EOL Versions | Full Support |
| MySQL | 8.0.0-8.0.34 | 6.1.0-6.1.3 | Supported, but does not support Partitioned Tables or the use of binlog-transaction-compression=ON introduced in 8.0.20 |
| MySQL | 8.0.0-8.0.34 | 6.1.4 onwards | Fully Supported. |
| MySQL | 8.4 | 7.2.0 onwards | Fully Supported. |
| MariaDB | 10.0, 10.1 | All non-EOL Versions | Full Support |
| MariaDB | 10.2, 10.3 | 6.1.13-6.1.20 | Partial Support. See note below. |
| MariaDB | Up to, and including, 10.11 | 7.x | Full Support |
| MariaDB | 11.4 | 7.2.1 onwards | Full Support. |
Affecting versions 11.14.
When working with MariaDB 11.4 and greater with SSL setup, tpm might fail to properly connect to the MariaDB server because of the new default for ssl-verify-server-cert (now true)
REF: https://jira.mariadb.org/browse/MDEV-31857
tpm will not return any error at install time but some utility scripts might not work correctly.
Adding ssl-verify-server-cert=false to your MySQL configuration will workaround the problem.
Affecting versions 8.0.21+.
In MySQL release 8.0.21 the behavior of CREATE TABLE ... AS SELECT ... has changed, resulting in
the transactions being logged differently in the binary log. This change in behavior will cause the replicators to fail
in versions up to and including v6.1.21
If you are using MySQL 8.0.21 and later it is recommended that you upgrade to v6.1.22 or later
Alternatively, the workaround for this will be to split the action into separate
CREATE TABLE ... followed by INSERT INTO ... SELECT FROM... statements.
If this is not possible, then you will need to manually create the table on all nodes, and then skip the resulting error in the replicator, allowing the subsequent loading of the data to continue.
Full support for MariaDB version 10.3 has been certified in v7.0.0 onwards of the Tungsten products.
Version 6.1.13 onwards of Tungsten will also work, however should you choose to deploy these versions, you do so at your own risk. There are a number of issues noted below that are all resolved from v7.0.0 onwards, therefore if you choose to use an earlier release, you should do so with the following limitations acknowledged:
tungsten_find_orphanedmay fail, introducing the risk of data loss (Fixed in v6.1.13 onwards)- SSL from Tungsten Components TO the MariaDB is not supported.
- Geometry data type is not supported.
- Tungsten backup tools will fail as they rely on xtrabackup, which will not work with newer release of MariaDB.
tpmmight fail to find correct mysql configuration file. (Fixed in 6.1.13 onwards)- MariaDB specific event types trigger lots of warnings in the replicator log file.
MySQL "Innovation" Releases
In 2023, Oracle announced a new MySQL version schema that introduced "Innovation" releases. From this point on, patch releases would only contain bug fixes and these would be, for example, the various 8.0.x releases, whereas new features would only be introduced in the "Innovation" releases, such as 8.1, 8.2 etc (Along with Bug Fixes)
"Innovation" releases will be released quarterly, and Oracle aim to make an LTS release every two years which will bundle all of the new features, behavior changes and bug fixes from all the previous "Innovation" releases.
Oracle do not advise the use of the "Innovation" releases in a production environment where a known behavior is expected to ensure system stability. We have chosen to follow this advice and as such we do not certify any release of Tungsten against "Innovation" releases for use in Production. We will naturally test against these releases in our QA environment so that we are able to certify and support the LTS release as soon as is practical. Any modifications needed to support an LTS release will not be backported to older Tungsten releases.
For more information on Oracles release policy, please read their blogpost