Re: Handling of SET commands in R/W splitting
Yep, this problem is up for discussion and one of the reasons why I implemented this feature in lua-land.
There are some commands which are specific for a connection and should kept in sync with the server connection. As an example I injected the USE <db> when I jump in the slave connection. In the same way we can apply the SET options that are living in the client connection.
We could intercept all the SET commands the client sent and apply them before each command to reset the connection. Or we could implement a setting-map for each server connection and try to match the client against the server-connection-state and change what differs.
Ideas are welcome.
--
Jan Kneschke, MySQL Enterprise Tools
Subject
Views
Written By
Posted
3989
August 02, 2007 08:05AM
Re: Handling of SET commands in R/W splitting
2902
August 02, 2007 08:37AM
2689
August 02, 2007 08:53AM
2634
August 02, 2007 09:10AM
2675
August 03, 2007 01:42AM
2680
August 03, 2007 02:08AM
2681
August 03, 2007 02:59AM
2775
August 03, 2007 05:26PM
2785
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.