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
3989
August 02, 2007 08:05AM
2902
August 02, 2007 08:37AM
2689
August 02, 2007 08:53AM
2631
August 02, 2007 09:10AM
2675
August 03, 2007 01:42AM
Re: Handling of SET commands in R/W splitting
2679
August 03, 2007 02:08AM
2681
August 03, 2007 02:59AM
2774
August 03, 2007 05:26PM
2784
August 03, 2007 07:31PM
2699
August 04, 2007 04:23PM
2651
August 05, 2007 05:14PM
2597
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.