CODEWITHSUNDEEP
mariadbmaxscale
Jack
Jack

Reputation: 81

Route prepared statements to the slaves

My setup is as the following: MaxScale 2.1.4 -> Master -> 2 slaves (both MariaDB 10.2). *CentOS 7

Most of my queries are prepared statements so the master basically handles 90% of the queries right now.

I've enabled the hintfilter and tried to add a hint to a query:

/* maxscale route to server server2 */

Unfortunately, it still ends up on the master.

I understood that MaxScale 2.2 should introduce some auto solution for prepared statements. However, I need some temp solution(I'll try to look into ProxySQL if none is found).

Any help would be highly appreciated.

Upvotes: 0

Views: 437

Answers (1)

markusjm
markusjm

Reputation: 2562

If you used the mysql command line client to test it, remember to enable SQL comments by using the -c flag.

Since MaxScale 2.0.1, the hint mechanism will override any decisions taken by the router itself if the router supports hints. The readwritesplit and schemarouter routers are currently the only routers that support routing hints so make sure you are using one of these routers.

Upvotes: 1

Related Questions