where can i download mysql-proxy 0.7 for windows

Hi weijh,

>> where can i download mysql-proxy 0.7 for windows?

We do not have windows (or linux) binaries available right now, but we are working on them.

>> Can i use postgresql or legacy socket program as backend ?

MySQL Proxy only supports MySQL as the backend

Regards,

Diego

Thanks.

In the article "Getting started with MySQL Proxy"
[[ http://dev.mysql.com/tech-resources/articles/proxy-gettingstarted.html ]]
"Shell commands from MySQL client" section
I can use my-proxy to run shell commands.

If I can use lua connect to Postgresql then return result to mysql client?
Same as lua use socket connect some legacy applications and return responsion to mysql client?

weijh,

you sure could use e.g. http://www.keplerproject.org/luasql/ to connect to a Postgres database and rewrite the results into MySQL packets.
However, this would not take care of the SQL dialect differences (and other more subtle behavioral differences) between MySQL and Postgres, making this of only limited use.
A much cleaner approach would be to use some generic connector in the application (e.g. ODBC or JDBC depending on what your application is written in).
MySQL does not understand the Postgres protocol, which is what Diego meant.

Weijh,
you can definitely do that, although MySQL Proxy, being built around the
MySQL protocol, is not the best tool for this task.
I did something similar, using a different proxy, built in Perl. You can see
an example in this article, where I join one SQLite and one PostgreSQL
tables from a MySQL client.
http://dev.mysql.com/tech-resources/articles/dbixmyserver.html

Cheers

Giuseppe

On Sun, Feb 15, 2009 at 3:48 PM, Kay Roepke <
<email address hidden>> wrote:

> Question #60968 on MySQL Proxy changed:
> https://answers.launchpad.net/mysql-proxy/+question/60968
>
> Status: Open => Answered
>
> Kay Roepke proposed the following answer:
> weijh,
>
> you sure could use e.g. http://www.keplerproject.org/luasql/ to connect to
> a Postgres database and rewrite the results into MySQL packets.
> However, this would not take care of the SQL dialect differences (and other
> more subtle behavioral differences) between MySQL and Postgres, making this
> of only limited use.
> A much cleaner approach would be to use some generic connector in the
> application (e.g. ODBC or JDBC depending on what your application is written
> in).
> MySQL does not understand the Postgres protocol, which is what Diego meant.
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
The Data Charmer
http://datacharmer.org/

thanks

Thanks Giuseppe Maxia, that solved my question.

Thanks Kay Roepke too, that solved my question. :)

One more question:
Can I use mysql-proxy without a backend mysql server ?
How the client is authenticated ?

I wish give php developer a unify interface,
All use mysql protocol,
All thing is like mysql.

Please open a new thread for a new question.
Or use the mailing list https://edge.launchpad.net/~mysql-proxy-discuss
This one has been abused enough.

Thanks

i need to know how to install mysql proxy
iknow steps but the package that i download for suse dows not install corretly

eman, please open a new ticket. This thread is about MySQL Proxy 0.7 on _windows_.