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
3653
August 02, 2007 08:05AM
Re: Handling of SET commands in R/W splitting
2719
August 02, 2007 08:37AM
2571
August 02, 2007 08:53AM
2487
August 02, 2007 09:10AM
2546
August 03, 2007 01:42AM
2560
August 03, 2007 02:08AM
2528
August 03, 2007 02:59AM
2636
August 03, 2007 05:26PM
2648
August 03, 2007 07:31PM
2554
August 04, 2007 04:23PM
2509
August 05, 2007 05:14PM
2452
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.