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
4136
August 02, 2007 08:05AM
2935
August 02, 2007 08:37AM
2719
August 02, 2007 08:53AM
2660
August 02, 2007 09:10AM
2711
August 03, 2007 01:42AM
Re: Handling of SET commands in R/W splitting
2713
August 03, 2007 02:08AM
2715
August 03, 2007 02:59AM
2804
August 03, 2007 05:26PM
2814
August 03, 2007 07:31PM
2724
August 04, 2007 04:23PM
2676
August 05, 2007 05:14PM
2631
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.