MariaDB Xpand and MySQL Version Compatibility
This page is part of MariaDB's Documentation.
The parent of this page is: Evaluate Compatibility and Performance of MariaDB Xpand
Topics on this page:
Overview
Xpand provides general compatibility with MySQL and MariaDB functionality, but does not guarantee compatibility with any particular version. For the purposes of third party tools, you can configure Xpand to display a specific version.
The value for the version variable will is a concatenation of mysql_
sql> select @@version;
+------------------+
| @@version |
+------------------+
| 5.0.45-Xpand-5.3 |
+------------------+
Note
Changing the value of mysql_
Global Variables
These are the global variables related to version.
Name | Description | Default Value |
---|---|---|
| Xpand software version | <auto populated> |
| The reported MySQL server version |
|
| A version string indicating the version of the software when the cluster was initial created. | <auto populated> |
| The reported server version | <auto populated> |
Caveats to Version Compatibility
Replication from Xpand (Master) to MySQL (Slave)
Xpand can replicate to the following versions of MySQL with the using the specified values set for mysql_
MySQL version (slave) | ||||
---|---|---|---|---|
Xpand mysql_ | 5.0.* | 5.5 | 5.6 | 5.7 |
5.0 | yes | yes | yes | yes |
5.5 | yes | yes | yes | yes |
5.6 | no | yes | no | no |
5.7 | no | no | no | no |
Replication from Xpand to Xpand is not affected by the value for mysql_
JDBC compatibility
Changing the MySQL value contained in version can have an impact on JDBC behavior, as JDBC will read the version and attempt to use features accordingly. Xpand does not support the tx_
JDBC | version
5.0.45
| version
5.6.38
| version
5.6.4
| version
5.6.45
| version
5.6.5
|
---|---|---|---|---|---|
5.1.32 | yes | Not Supported | yes | Not Supported | Not Supported |
5.1.36 | yes | Not Supported | yes | Not Supported | Not Supported |
5.1.37 | yes | yes | yes | yes | yes |
5.1.40 | yes | yes | yes | yes | yes |
5.1.41 | yes | yes | yes | yes | yes |
5.1.43 | yes | yes | yes | yes | yes |
5.4.44 | yes | yes | yes | yes | yes |