[ODBC-368] Make the Connector more MaxScale friendly Created: 2022-07-14  Updated: 2023-01-24

Status: Open
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.16
Fix Version/s: 3.1

Type: Task Priority: Major
Reporter: Lawrin Novitsky Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-4205 MariaDB ODBC test suite fails when ru... Closed
relates to MXS-4487 Run C/ODBC test suite as a part of Ma... Closed

 Description   

Currently few catalog function calls result in error, if MaxScale stands in front of servers with default settings. The solution is to set use_sql_variables_in=master in the the readwritesplit service.
Another possible solution(besides complete rewriting of the functions to make the queries they send be "good" for maxscale), is to add to the queries maxscale hints, i.e. the comment with the text /* maxscale route to master */, that will cause the same effect as use_sql_variables_in=master But hintfilter should be turned on in MaxScale, and that is not the case by default


Generated at Thu Feb 08 03:28:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.