If you need to combine two scripts with MySQL Proxy you have three choices.

• You can manually rewrite the two scripts (good luck!)
• you can use the load-multi module to load scripts on demand;
• or you can use the proxy chaining technique.

To chain two proxies, you need to start one Proxy with the first Lua script, pointing at the real backend, listening to a non-standard port. Then you start the second Proxy with the second Lua script, having the first proxy as a backend, and listening to the standard proxy port.
It's a difficult and error prone procedure. You would forget about it, unless there were an easy workaround. And indeed you can have such a workaround. Just use the …

Since I've been doing most of my blogging lately over at InfoWorld, I thought I'd provide a short digest of some of the top posts in recent months. I share the blog with Savio Rodrigues from IBM, but other than some overlap at the occasional conference, we blog independently.  (Yes, it's an old photo.)  Enjoy!

• Matt Asay gets frustrated
• Summer tech conferences
• Why …

And here we are, my second post in which I mention twitter, and wonder aloud what open source software projects should be doing with twitter. I don’t have any well-formed thoughts to foist on you, but I’ll tell you about an experiment I’ve been doing. Last week I started using summize.com to search for conversations about bzr. I did the same thing for ubuntu and for git, but only really stuck with the bzr stream. It’s been interesting to see what people are talking about, I’ve tried chiming in with suggestions when I can or asking for further details when people complain. I think what is so fascinating to me about this is that I’m finding a whole lot of conversations that aren’t at the level of a ranting blog post but are encouraging or thought-provoking feedback nonetheless.

I also registered twitter.com/bzr, but I’m not sure what to do with it yet. Suggestions? …

MySQL is featured on the Google Open Source Blog
Just after leaving JavaOne, Leslie pinged me on IRC to inform me that the MySQL project was featured on the Google Open Source blog. Go on, read Moments of Inspiration.

In other news from mentors, Colin Charles, former mentor and 2008 organization administrator for MySQL dropped a note to let us know that their Community Bonding period is moving along swimmingly. So well, in fact, that their students are already delivering weekly status reports. Colin mentioned that …

The coolest aspect of all this project is the virtualization of single elements like a disk drive, a net port, a file system, without root privileges, and with no impact on other users.
…

Today I had a chance to explain Q4M in detail, and here are the slides I used.

It covers from what (generally) a message queue is, the internals of Q4M, how it should be used as a pluggable storage engine of MySQL, to a couple of usage senarios. I hope you will enjoy reading it.

| View | Upload your own

If you are working with MySQL as a DBA or developer, I'd like to encourage you to consider taking the MySQL Magazine Survey, which was compiled by Keith Murphy and Mark Schoonover.

The survey takes around 10-15 minutes to complete and runs until June 16th. The results will be published in the summer issue of MySQL Magazine, due on July 15th. The questions cover a broad range of topics, from details about your MySQL experience and job description over connectors and languages to operating systems and MySQL versions.

Thanks in advantage for your support and input! The results of this survey will be interesting for us as well.

Hey,

Today, I started off working with MySQL after a long break. I have tried it before too, using WAMPServer, which had phpMyAdmin to manage the database for website development. I was using it for the first time then, so never really went into much technicalities.

During the past 6 months, NetBeans 6.0 FCS and 6.1 FCS were released. I am glad to use both of them, as both made my work easier than ever before. Just because of the speed which 6.1 provides, I have started shifting from 6.0!

Also, Sun acquired MySQL during this time and I was happy to see this acquisition taking place, as NetBeans would support MySQL …

Recently I had to deal with one task which required to do two sets intersection. For example, if we have set A = {a, b, c} and set B = {b, c, d} the result should be set C = {b, c}. So the question was how do we do that with MySQL. My little investigation and few minutes of googling showed that there is no special command for set intersection in MySQL (like INTERSECT) or set difference, although there is one for set union (UNION. Now how come that there is one for union, bot none for other set operations. Unions are used more often?!). Instead, there is some tricky workaround using different kinds of JOINs.
Now for my task, I had one simple table words shown below:
-------------------------
word_field \\ link_field
-------------------------
a \\ link1 …

As some of you would have recently noticed, I’ve started playing around (I can’t really say using, seeing that its still not a daily basis kind of thing for me yet) with OpenSolaris and NetBeans. Now, Sun is encouraging students to use, review, and blog about these two great products - check out the student reviews contests.

If you’ve not tried OpenSolaris 2008.05, you should probably give it a twirl. Sure, I’ve not installed it on bare metal hardware yet (I’ve been travelling so much, I’m not anywhere near machines), but it works fine inside VirtualBox. NetBeans is great if you’re writing Java, Ruby, PHP, and are connecting to a database - Connector/J for MySQL …