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.