MySQL Proxy

Can I use mysql-proxy without a backend mysql server ?

Asked by weijh

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.

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Proxy Edit question
Assignee:
No assignee Edit question
Solved by:
fmpwizard
Solved:
Last query:
Last reply:
Revision history for this message
Best fmpwizard (diego-fmpwizard) said : 		#1

Hi Weijh,

Yes you can, you can have a lua script that would handle the
connection and some queries, for an example please look at this file

tests/suite/base/t/resultset-mock.lua

It handles several queries without using a backend.

You can just start the proxy like this

$ ./bin/mysql-proxy
--proxy-lua-script=/mysql-gpl-proxy/trunk/tests/suite/base/t/resultset-mock.lua

and start a mysql client like this

$ mysql -h127.0.0.1 -P4040 -uroot

Regards,

Diego

On Sun, Feb 15, 2009 at 7:03 PM, weijh
<email address hidden> wrote:
> New question #61151 on MySQL Proxy:
> https://answers.edge.launchpad.net/mysql-proxy/+question/61151
>
> 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.
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
http://www.fmpwizard.com

Revision history for this message
weijh (weijinhong) said : 		#2

Thanks fmpwizard, that solved my question.