[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. |