The latest from the MySQL community

Innovation Everywhere! That’s the motto of the MySQL Conference & Expo 20-23 April 2009, in Santa Clara.

If April next year sounds like the distant future to you, then you’re evidently not planning to be a presenter. Since if you do plan to present, there’s a very close date relevant for you: 22 October 2008. That’s when the Call for Papers closes.

If you’re an innocent bystander and don’t plan on presenting, you may still enjoy lurking at the MySQL Conference Website, for instance looking at some of the full-length keynote videos already posted from the 2008 conference.

On the other hand, if you’re …

Still no official news on the rumour that Monty Widenius has left Sun, but Dave Rosenberg confirmed over the weekend that he is leaving MuleSource, the open source ESB vendor he founded in 2006 with Ross Mason, creator of the Mule project.

“After two and a half years I’ve decided to transition out of my operating role at MuleSource and will be devoting my full time efforts to a new company I have been working on,” he wrote on Friday. “I initiated a CEO search in June and we expect to have a new person in place by the end of the year at the latest.

“I started the search because I felt like a more …

Users, in the context of databases, especially open ones, means developers. Do you feel like hacking some database project? If your database of choice is open (MySQL, PostgreSQL, JavaDB, SQLite, Firebird), you may give the OpenSQLCamp a try!

Building MySQL on Windows - MySQL Forge Wiki

This one covers running mysqld in the VisualStudio debugger, which can be useful.

I have no special ndb_mgmd.exe or ndbd.exe in debugger instructions or wisdom (running them from mysql-test-run.pl at least). I’ve attached debugger to already running (started by mysql-test-run.pl) ndb processes, but haven’t made any changes to mtr to make it like the mysqld of “go and enter this”.

If you are security conscious and nowadays who isn’t?, you may have pondered over ways to make your external SSH connection safer.
Of course there’s always One-time Passwords and Public Keys, but if like me you watch the daily barrage of brute force attacks you may be thinking it’s only a matter of time…

That’s what I was thinking at about the same time an SMS arrived on my mobile….then it hit me….I take my mobile everywhere, if only my server could call me and ask if it is really me trying to log in.

My first instinct was to try and insert a Perl or Python script into the login process. After all …

It's been over a month (and three hurricanes in America) since I've posted a blog. More than a few of you've noticed - thanks for the prodding...

It's been a busy summer, on nearly every front. Customer activity hasn't slowed down, and the good news surrounding the (otherwise unfortunate) economic crisis embroiling many customers (especially those in the financial services industry, a heavy concentration for Sun) is that it's whipping up the winds of change. Customers facing spending pressure, or tiring of vendor price increases have new options, and there's a new appetite to explore those options (nothing like mandates from the CEO to reduce spending by 50%).

One of my more interesting recent meetings wasn't with a customer, though, it was with an equity analyst from a global financial institution. Equity analysts publish research that feeds the investment community - their (free) research and financial analysis accompanies …

I want a new command in MySQL/InnoDB to freeze all filesystem activity in InnoDB… until I unfreeze it?

Why? I want mysqlhotcopy semantics for InnoDB.

Right now you can run FLUSH TABLES WITH READ LOCK and then xfs_freeze but it’s not very efficient or easy to code, and it’s pretty fragile.

INNODB FREEZE should not require a connection to remain open and should require an INNODB UNFREEZE to return IO to its normal state.

Further, when you copy away an underlying InnoDB database to a new server, crash recovery should NOT be required.

What really bothers me about the recent desire for MySQL features (triggers, etc) is that these type of features mean a LOT more to me. Operational competence in MySQL is very important and it seem the MySQL developers often forge this…

Drizzle and the InnoDB plugin are starting to show the way though….

Update:

I …

I had a sad time this year when I missed the MySQL conference, since I had much fun last year in Santa Clara. I can’t miss it next year.

As a MySQL partner, and after almost 2 years doing MySQL training, I sure have interesting things to tell in the conference, but I’m not sure about what.

I will be thinking about this in the next weeks, but I’d appreciate some help. What topics are you interested in?

Well, I have started formatting the results from the survey. This will take a little while as the survey software doesn't make it easy to download and clean it up (without paying for a subscription). As soon as the data is cleaned up I will post the entire data set and a link for everyone to download.

However, while I work on the data, I will provide some summary results. Here is a list of countries who had respondents. If a country is not listed, it had 0 responses/