Suspekt... " Blog Archive " MySQL-Proxy learning to block SQL-Injection

Tue, 19 Aug 2008 03:21:59 -0700

MySQL :: MySQL 5.0 Reference Manual :: 16.4.2 Internal Structures

Thu, 14 Aug 2008 17:09:18 -0700

lua-users wiki: Making Lua Like Php

Thu, 14 Aug 2008 17:09:18 -0700

Search :: Search the Forge

Thu, 14 Aug 2008 17:09:18 -0700

O'Reilly Network -- Getting Started with MySQL Proxy

Fri, 08 Aug 2008 09:07:59 -0700

~jk MySQL Proxy learns R/W Splitting

Wed, 18 Jun 2008 08:17:46 -0700

Most Commonly Sought-After Command in MySQL Proxy

Sat, 17 May 2008 09:14:48 -0700

One of the most frequently needed functionality in the MySQL Proxy is the need to know which server you are on. This is not given, on purpose, by the proxy, because the proxy is supposed to be transparent. It is not supposed to matter which back-end server you are on.

However, for testing purposes we often want to know which back-end server we’re on. Thus I developed functionality for SHOW PROXY BACKEND [INDEX ADDRESS OTHER].

SHOW PROXY BACKEND INDEX — gives the index of the server you’re on (backend_ndx, ie 1)

SHOW PROXY BACKEND ADDRESS — gives the address of the server you’re on (ie, foo.bar.com:3306)

SHOW PROXY BACKEND OTHER — gives the address of all the other servers except those you’re not on, in multiline format.

Note that I was pretty lazy and the commands are case-sensitive. But I figured that since this is supposed to be used mostly in testing circumstances, it did not really matter.

The code is on the MySQL Forge Wiki at http://forge.mysql.com/tools/tool.php?id=139

Interestingly enough, this script is actually being used in production — a site has a primary and failover server, and wants to check that when the primary server is in use, there are no connections on the failover. I wrote that check as well, but as the logic is somewhat particular, I am not sure it would be useful to many. The logic is:

Run SHOW PROXY BACKEND INDEX.
if it fails, I can’t connect to the proxy, log an error, exit.
if it !=1, I’m on the failover server, log a warning, exit.
if it =1, I’m on the primary server.
Run SHOW PROXY BACKEND OTHER.
if it is empty, either I can’t connect to the proxy or there are no failovers defined, log a warning, exit
For each OTHER address, connect to them and find what that connection’s host looks like (sometimes it looks like foo.bar.com:4325, other times it looks like 1.2.3.4:4573). Get the value of “my host” by stripping off the port.
Connect to the OTHER address again, killing off connections from “my host” except for the “system user” and a few other special accounts (replication slave being one of them). Log each kill with the thread number and a warning.
If there are no connections to be killed, log OK.

Let me know if you’d like to see that…it’s a shell script, and it requires the mysql client and bintools like grep and cut.

Fun with MySQL Proxy

Thu, 15 Nov 2007 11:47:53 -0800

~jk MySQL Proxy learns R/W Splitting

Wed, 17 Oct 2007 14:59:51 -0700

~jk MySQL Proxy learns R/W Splitting

Wed, 17 Oct 2007 13:31:24 -0700

MySQL Proxy learns R/W Splitting

~jk MySQL Proxy learns R/W Splitting

Sun, 12 Aug 2007 18:25:50 -0700

Using mysql-proxy and Lua to split read/writes between master/slave DB nodes.

MySQL Proxy - MySQLForge Wiki

Wed, 01 Aug 2007 23:26:28 -0700

MySQL Proxy - MySQLForge Wiki

Tue, 17 Jul 2007 22:29:35 -0700

A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication.

LuaSQL: Database connectivity for the Lua programming language

Wed, 27 Jun 2007 05:58:12 -0700

mysqlproxy on SWiK

Suspekt... " Blog Archive " MySQL-Proxy learning to block SQL-Injection

MySQL :: MySQL 5.0 Reference Manual :: 16.4.2 Internal Structures

lua-users wiki: Making Lua Like Php

Search :: Search the Forge

O'Reilly Network -- Getting Started with MySQL Proxy

~jk MySQL Proxy learns R/W Splitting

Most Commonly Sought-After Command in MySQL Proxy

Fun with MySQL Proxy

~jk MySQL Proxy learns R/W Splitting

~jk MySQL Proxy learns R/W Splitting

~jk MySQL Proxy learns R/W Splitting

MySQL Proxy - MySQLForge Wiki

MySQL Proxy - MySQLForge Wiki

LuaSQL: Database connectivity for the Lua programming language