Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

In ClustrixDB 9.1, the value for version is a concatenation of mysql_version and clustrix_version. The value for mysql_version should be set according to your compatibility needs. The clustrix_version global variable is updated automatically on upgrade. 

sql> set global mysql_version = '5.0.45';
sql> select @@version;
+---------------------+
| @@version           |
+---------------------+
| 5.0.45-clustrix-9.1 |
+---------------------+
1 row in set (0.00 sec)


Changing the value of mysql_version may cause your application’s behavior to change and even possibly fail, as it may not correctly identify supported features.

Global Variables

These are the global variables related to version.

NameDescriptionDefault Value
clustrix_version

Clustrix software version 

<auto populated>
mysql_version

The reported MySQL server version

5.0.45

format_versionA version string indicating the version of the software when the cluster was initial created.<auto populated>
version

Concatenation of mysql_version and clustrix_version.

<auto populated>

Caveats to Version Compatibility

Replication from ClustrixDB (Master) to MySQL (Slave) 

ClustrixDB can replicate to the following versions of MySQL with the using the specified  values set for mysql_version on the ClustrixDB master. 


MySQL version (slave)
ClustrixDB mysql_version (master)5.0.*5.55.65.7
5.0(tick)(tick)(tick)(tick)
5.5(tick)(tick)(tick)(tick)
5.6(error)(tick)(error)(error)
5.7(error)(error)(error)(error)

Replication from ClustrixDB to ClustrixDB is not affected by the value for mysql_version. See Using ClustrixDB as a Replication Master for instructions on configuration. 

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. ClustrixDB does not support the tx_read_only variable, which is used by JDBC when some specific MySQL values are set in version. The following chart outlines compatibility of Clustrix with different values for version and versions of JDBC:


JDBC
version
5.0.45
version
5.6.38
version
5.6.4
version
5.6.45
version
5.6.5
5.1.32(tick)Not Supported(tick)Not SupportedNot Supported
5.1.36(tick)Not Supported(tick)Not SupportedNot Supported
5.1.37(tick)(tick)(tick)(tick)(tick)
5.1.40(tick)(tick)(tick)(tick)(tick)
5.1.41(tick)(tick)(tick)(tick)(tick)
5.1.43(tick)(tick)(tick)(tick)(tick)
5.4.44(tick)(tick)(tick)(tick)(tick)
  • No labels