Re: Handling of SET commands in R/W splitting

[Gerry Reno]

Reverting Subject:

One of the limitations in the way that MySQL handles replication is that it makes the assumption that you are in a current context (eg: USE) and therefore does not like replicating statements that are qualified with dbname.tablename. Also there may be issues with charsets and other aspects related to a particular connection. To reuse such connections is playing russian roulette at times. MySQL-Proxy could possibly be used to setup a sane context or perhaps at least a default context for each client that reuses a connection from a pool of open connections. This would be an improvement from the current situation that exists today. In the case of each client it could keep a context table and use this information to place a connection into the last used context for that client prior to accepting new commands.

Gerry