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
3654
August 02, 2007 08:05AM
2721
August 02, 2007 08:37AM
2572
August 02, 2007 08:53AM
2487
August 02, 2007 09:10AM
2546
August 03, 2007 01:42AM
Re: Handling of SET commands in R/W splitting
2560
August 03, 2007 02:08AM
2529
August 03, 2007 02:59AM
2637
August 03, 2007 05:26PM
2648
August 03, 2007 07:31PM
2554
August 04, 2007 04:23PM
2510
August 05, 2007 05:14PM
2453
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.