Plans for funneling through MySQL Proxy?

Hi all,

I'm pretty new to MySQL and even more to the MySQL Proxy. I've been playing with it for a while to see if it can fulfill our testing needs.

After diving into forums/documentation/source I think the proxy creates different connections (and maybe different threads) when different clients try connect to the same database. Can you please confirm that?

The use case I have in mind is to make a set of SQL queries go through the same connection within the scope of a single transaction, thus being able to revert quickly (almost) any change made to the DB from several different clients. I think "funneling" is the right term to describe that.

Do you think it's possible to achieve the mentioned behavior with a Lua script? How? If not, are there any plans to allow funneling through a single connection to a backend server?

Any help will be more than welcome.

Thanks
--Rafa