I am following this doc on implementing data shards in mysql cluster using proxysql: https://proxysql.com/documentation/how-to-setup-proxysql-sharding/.
But my application generates prepared statements which are being captured in proxysql like
SELECT * FROM mytable WHERE id=?
I want to shard on value of id like even values goes to node-1 and odd goes to node-2.
How to set query routing rules in proxysql for this case? Is it achievable?
