MySQL Forums
Forum List  »  Router & Proxy

Re: MySQL Proxy: Scenarios, Use Cases
Posted by: Reinis Rozitis
Date: August 01, 2007 05:58AM

Jonathon Suggs Wrote:
-------------------------------------------------------
> >example:
> >SELECT /*gallery*/ * FROM pictures WHERE ..
>
> Unless you have a pictures table in both your
> gallery and forum shards, then why not have the
> the -proxy take care of connecting to the
> appropriate database? Then you could just write
> syntactically correct queries inside your
> application (makes for MUCH easier debugging).
>

Because there is no way proxy would know where (on which logical pool/servers) the table actually resides.
It would be possible if proxy had perfomed SHOW TABLES on each of the attached server nodes but then again if you have pretty large table count (and changing) mantaining/refreshing makes much more pain. So the choice is on programmers/aplication side in which logical pool/shard drop the table and proxy has to hold only shard maping/naming.

Options: ReplyQuote


Subject
Views
Written By
Posted
21728
July 09, 2007 11:35PM
8091
July 10, 2007 12:01AM
8225
July 10, 2007 11:21AM
5836
July 10, 2007 12:05PM
5898
July 10, 2007 12:17PM
5284
July 10, 2007 02:37PM
5283
July 10, 2007 04:07PM
4736
February 21, 2008 11:26PM
5113
July 10, 2007 11:55AM
Re: MySQL Proxy: Scenarios, Use Cases
5245
August 01, 2007 05:58AM
4346
February 13, 2008 02:04PM
3936
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.