[Sqlrelay-discussion] MySQL proxy
Brought to you by:
mused
|
From: Bertrand L. <ber...@li...> - 2007-02-13 23:45:41
|
Hello,
I'm just trying to set up a simple MySQL proxy: all the request to
the local machine is to be forwarded to a remote one,
authentification should be done on the remote MySQL server.
The configuration i'm trying to set up is the following (0.38):
----8<----8<----8<----8<----
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<instance id="mysqltest" port="3306" socket="/var/run/mysqld/
mysqld.sock" dbase="mysql" connections="3" maxconnections="5"
maxqueuelength="0" growby="1" ttl="60" endofsession="commit"
sessiontimeout="600" runasuser="" runasgroup="" cursors="5"
authtier="database" handoff="pass">
<router>
<route host="my.remote.mysql.server" port="3306">
<query pattern=".*"/>
</route>
</router>
</instance>
</instances>
---->8---->8---->8---->8----
That's not correct, since users and connections elements are required
by the dtd.
I'd just like to forward all the local connections to a remote host,
without dealing with users (i don't know all the login/passwords for
all users). Is that possible?
Greetings,
--
Bertrand LUPART
Linkeo.com | http://www.linkeo.com/
+33 1 72 71 71 84 | 17, rue de la Banque - F75002 Paris
http://www.linkeo.com/signatures/bertrand-lupart/
|