[MXS-1066] Query hint to route queries to last used server Created: 2016-12-19  Updated: 2018-07-31  Resolved: 2018-07-31

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: None
Fix Version/s: 2.3.0

Type: New Feature Priority: Minor
Reporter: Heinz Wiesinger Assignee: Marko Rajala (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Comparing maxscale's supported query hints to the ones from mysqlnd_ms, I noticed the latter has a switch to route queries to the last used server (http://php.net/manual/en/mysqlnd-ms.quickstart.sqlhints.php).

It would be nice to have such a hint in maxscale as well. It would enable usecases where you want to keep reading from the same master/slave, and also potentially a weaker variant of the Consistent Critical Read Filter.



 Comments   
Comment by markus makela [ 2017-10-30 ]

This should be easily doable in 2.2 since the router now tracks the previous target of each request. Adding a new hint type should also be quite easy.

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