Re: MySQL Proxy: Scenarios, Use Cases
Now that the Read/Write splitting works (read
http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting) you can also implement the two discussed scenarios.
Execute SHOW TABLEs at connection time and store it globally and us this information for routing. Or parse out the comment to safe the SHOW TABLEs.
Keeping it in the proxy makes it more dynamic and keeps the application logic clean. Pretty handy if you can't change the code.
--
Jan Kneschke, MySQL Enterprise Tools
Subject
Views
Written By
Posted
21470
July 09, 2007 11:35PM
7982
July 10, 2007 12:01AM
8100
July 10, 2007 11:21AM
5715
July 10, 2007 12:05PM
5807
July 10, 2007 12:17PM
5198
July 10, 2007 02:37PM
5186
July 10, 2007 04:07PM
4640
February 21, 2008 11:26PM
5032
July 10, 2007 11:55AM
8229
July 20, 2007 03:58AM
4948
July 30, 2007 01:21PM
5143
August 01, 2007 05:58AM
Re: MySQL Proxy: Scenarios, Use Cases
4667
August 01, 2007 06:03AM
4259
February 13, 2008 02:04PM
4217
April 08, 2008 04:25AM
5251
July 28, 2008 09:32PM
3843
September 24, 2008 02:44AM
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.