msyql proxy

[amirshr]

hi mflorell,
will there be any advantages if i use mysql proxy in vicidial or vicidialnow ?
Please advise.
Thanx

[gmcust3]

mysql proxy ?

Pl clarify more.

[amirshr]

Hi there,
mysql-proxy is a lightweight binary application standing between one or more MySQL clients and a server. The clients connect to the proxy with the usual credentials, instead of connecting to the server. The proxy acts as man-in-the-middle between client and server.

In its basic form, the proxy is just a redirector. It gets an empty bucket from the client (a query), takes it to the server, fills the bucket with data, and passes it back to the client.

If that was all, the proxy would just be useless overhead. There is a little more I haven't told you yet. The proxy ships with an embedded Lua interpreter. Using Lua, you can define what to do with a query or a result set before the proxy passes them along.

more info
http://dev.mysql.com/tech-resources/art ... arted.html

[mflorell]

With a real-time application like ViciDial I can only imagine that this would slow things down.