Linux Today: Linux News On Internet Time.

Intro to MySQL Proxy

Jan 15, 2009, 19:04 (0 Talkback[s])
(Other stories by Sean Hull)

"There are many applications for this technology, and once you start dabbling, your mind will surely run wild with ideas. For instance, the default MySQL server's slow query log provides only single second granularity. If you want microsecond control, you'll have to add the Google patches to get it. That requires a recompile of the MySQL source, which many administrators would resist. Enter the MySQL-Proxy, which comes with a lua script to do just that. You can get the subsecond granularity, and log queries accordingly. What's great is that you can install it on a running system, without any big changes. Instead of having your app connect to port 3306, you'll point it to port 4040 of the proxy. But what about without changing any application code at all? One way would be to run mysql on a different port, and restart it. Then run the proxy on port 3306. However, an even better way is to you Linux's iptables to reroute all incoming connections on port 3306. Take a look at this link for code snippets to do that:"

Complete Story

Related Stories: