Balancing based on shard key during query.

[Luca Olivari]

Hi all,

I need to create a pool of connection within proxy and then balance load between servers based on a shard key. For instance:

if query contains key=1 and is RW then send to server1
if query contains key=1 and is RO then send to server1ro
if query contains key=2 send to server2
.. etc ..

Is this possible?

Someone can help me with some examples (I've already looked at all the examples coming with 0.6.1 with no luck).

Many thanks,

Luca