What is MySQL Proxy?
MySQL Proxy is an easy plan that sits between your client and MySQL server(s) that can supervise, examine or translate their communication. Its flexibility allows for limitless uses; popular ones include: burden balancing; failover; question analysis; question filtering and alteration; and many much.
Coming Soon!
MySQL Proxy is released under a GPL Licence; in addition, MySQL Enterprise will include several products based on the MySQL Proxy heart engineering. More data coming shortly.
Getting started with MySQL Proxy.
The launching of MySQL Proxy has caused rather a ruckus in the community. And with reason. For characteristic thirsty folk, this is undeniably the almost interesting addition to MySQL lot of tools. If the last assertion has left you baffled, because you wear't view the added value, wear't concern. This clause aims at giving you the feel of what the Proxy can make. Get willing for a fantastic journey to Proxyland.
MySQL Proxy overview.
mysql-proxy is a lightweight binary application standing between one or much MySQL clients and a waiter. The clients link to the proxy with the customary credential, instead of connecting to the waiter. 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.
In computer networks, a proxy server is a server (a computer system or an application program) which services the requests of its clients by forwarding requests to other servers. A client connects to the proxy server, requesting some service, such as a file, connection, web page, or other resource, available from a different server. The proxy server provides the resource by connecting to the specified server and requesting the service on behalf of the client. A proxy server may optionally alter the client's request or the server's response, and sometimes it may serve the request without contacting the specified server. In this case, it would 'cache' the first request to the remote server, so it could save the information for later, and make everything as fast as possible.
A proxy server that passes all requests and replies unmodified is usually called a gateway or sometimes tunneling proxy.
A proxy server can be placed in the user's local computer or at specific key points between the user and the destination servers or the Internet.
06 February 2008
MySQL Proxy
Subscribe to:
Posts (Atom)
