[MXS-3615] Clarify session_track_system_variables requirement for readwritesplit's causal_reads parameter Created: 2021-06-16  Updated: 2021-06-16  Resolved: 2021-06-16

Status: Closed
Project: MariaDB MaxScale
Component/s: Documentation, readwritesplit
Affects Version/s: 2.5
Fix Version/s: 2.5.14

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

The documentation for the causal_reads parameter for readwritesplit has the following note:

Note: This feature requires MariaDB 10.2.16 or newer to function. In addition to this, the session_track_system_variables parameter must be set to last_gtid.

https://mariadb.com/kb/en/mariadb-maxscale-25-readwritesplit/#causal_reads

This seems to imply that you should do something like this:

SET GLOBAL session_track_system_variables='last_gtid';

and:

[mariadb]
session_track_system_variables=last_gtid

However, in 10.3 and later, this system variable has a non-empty default value that some users may want to keep: autocommit,character_set_client,character_set_connection,character_set_results,time_zone.

Therefore, it may be more appropriate for users to set it like this:

SET GLOBAL session_track_system_variables=CONCAT(@@global.session_track_system_variables, ',last_gtid');

and:

[mariadb]
session_track_system_variables=autocommit,character_set_client,character_set_connection,character_set_results,time_zone,last_gtid

Maybe it would be more appropriate for the documentation to say something like this?:

Note: This feature requires MariaDB 10.2.16 or newer to function. In addition to this, the session_track_system_variables parameter must include last_gtid in its list of tracked system variables.


Generated at Thu Feb 08 04:22:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.