Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

What is sticky_conn implemented in mysql_query_rules?

18 views
Skip to first unread message

Flavian

unread,
Sep 9, 2024, 2:27:54 PM9/9/24
to proxysql

Hi Team,

Requirement is when the query gets routed to the desired server the continuation of connection with or without transaction should be on the new server.


Eg. query rule is on  
use db_${uuid} to shard5

All following query from that connection thread should be to shard5.

We have disabled multiplexing on query rule level, but want to check if there is sticky_conn which can do this use case.

Also, proxysql doc didn't have much information on sticky_conn.














Reply all
Reply to author
Forward
0 new messages