[MXS-1088] Can't hint queries to slaves Created: 2017-01-25  Updated: 2017-12-01  Resolved: 2017-02-27

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

Type: New Feature Priority: Major
Reporter: markus makela Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-28

 Description   

You can hint queries to master but not to slave. This should be possible: SELECT 1; – maxscale route to slave



 Comments   
Comment by Esa Korhonen [ 2017-02-27 ]

According to tests, the hint is parsed and used by at least readwritesplit router.
Test:
// routes to master
SELECT LAST_INSERT_ID(), @@server_id;

// routes to slave
SELECT LAST_INSERT_ID(), @@server_id;
– maxscale route to slave

When using these commands in a client, make sure the hint is included in the same statement as the "SELECT". Some clients may automatically split them.

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