Re: MySQL Proxy: Scenarios, Use Cases

[Reinis Rozitis]

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.