Re: Handling of SET commands in R/W splitting
Ok, you want to tie 2 connection to each client connection.
1. client -> [proxy] -> master
2. client -> [proxy] -> slave
and as long as the client has the connection open, the master and slave connections are used exclusively by the client.
It will get interesting to see how we can grow the connection pool fast enough that we have enough open connections.
This should be possible to implement already. It only gets interesting how to write the backend-selector that it knows about bound connections.
--
Jan Kneschke, MySQL Enterprise Tools
Subject
Views
Written By
Posted
4152
August 02, 2007 08:05AM
2946
August 02, 2007 08:37AM
2724
August 02, 2007 08:53AM
2666
August 02, 2007 09:10AM
2717
August 03, 2007 01:42AM
Re: Handling of SET commands in R/W splitting
2719
August 03, 2007 02:08AM
2721
August 03, 2007 02:59AM
2814
August 03, 2007 05:26PM
2824
August 03, 2007 07:31PM
2733
August 04, 2007 04:23PM
2682
August 05, 2007 05:14PM
2638
January 18, 2008 08:16AM
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.