[MXS-755] FR: Hint filters for stored procedures Created: 2016-06-03  Updated: 2017-12-01  Resolved: 2016-07-19

Status: Closed
Project: MariaDB MaxScale
Component/s: hintfilter
Affects Version/s: 1.4.3
Fix Version/s: 2.1.0

Type: New Feature Priority: Major
Reporter: Guillaume Lefranc Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7


Sprint: 2016-14

 Description   

This is a feature request to have hint filters working with stored procedures.
Our Customer C******* uses Stored Procedure as a practice, 90% of them are SELECTs only and are always routed by MaxScale to the server.

Please modify hints so SPs can be routed to the slave on request.



 Comments   
Comment by markus makela [ 2016-06-03 ]

Allowing hints to take priority over the router's decisions is easy to implement but should perhaps only be enabled via some option.

Comment by markus makela [ 2016-07-19 ]

Routing hints now have the highest priority when routing decision are being made. The fact that an extra filter needs to be added is a sign that the user knows what they are doing and the routing decisions made by MaxScale are not optimal. Although it is possible to cause inconsistencies with this, the user should acknowledge this when they enable the functionality.

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