Re: Switching backend depending on the default_db
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).
Subject
Views
Written By
Posted
4300
October 03, 2007 07:16AM
2395
October 08, 2007 09:44AM
2483
October 08, 2007 12:43PM
2437
October 08, 2007 07:40PM
2548
October 09, 2007 02:41PM
Re: Switching backend depending on the default_db
2891
October 15, 2007 03:37PM
2396
October 22, 2007 04:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.