BANGALORE, INDIA: We have been witnessing a phenomenal increase in the use of proxies in computer networks in recent times. Just to refresh, a proxy (a computer system or an application) is used to service the requests of clients by forwarding them to the server.

It not only provides users an access to the server but also monitors and analyses the client-server communication. For MySQL database users, there's a tool named MySQL Proxy which also functions in the same manner and provides additional functionality.

MySQL Proxy is a tool that sits between the MySQL clients and server, and monitors the client's queries to the server for modification and filtering. It also provides server failover support, load balancing and much more. It is a part of the MySQL Enterprise Tools project and is available as a binary package for Linux, Mac OS and Solaris platforms right now. The binary for Windows is expected anytime soon.

About MySQL Proxy
MySQL Proxy is a lightweight binary application that stands between MySQL clients and MySQL server. Using their credentials, the clients connect to the Proxy instead of server, while the Proxy acts as the redirector for client's requests to the server. MySQL Proxy doesn't just perform the pass-through of client's requests to the MySQL server, but is also capable of monitoring, analyzing and even altering the communication between the client and the server. The Proxy is shipped with embedded Lua interpreters.

Would you like to Comment on this Article?

Name
Email
Comment Here
Code Verification

Be first to comment on this article