Re: Switching backend depending on the default_db

[Reinis Rozitis]

Travis Reeder Wrote:
-------------------------------------------------------
> Actually, after thinking a bit more about this, it
> would be great if you could swap connections at
> any stage, even at the read_query stage so you
> could implement sharding/partitioning using MySQL
> Proxy.


IMHO this is one of the feature requests from first MySQL-proxy day :)

It's kinda possible now but in my opinion a bit unflexible as you have to make/create a pool of connections (connect to all backends) before the query stage and if the backend decides to drop the connection (for example wait_timeout) then we are in trouble.

It would be awesome if MySQL-proxy could create a new connection in query stage in case the pool has no connections available (but still keeping in mind maximum connection limit).