As of late I have been getting a lot of questions around "Where did the MySQL developers go?'".

The answer is "elsewhere and nowhere".

The vast majority are still at Oracle, some have left, but plenty are still there. This got me thinking about "who wrote what". Innodb is a sizable piece of code and it continues to be at Oracle. Without Innodb, you don't really have a database that is 24/7. Innodb has been there for years.

What about the other pieces?

The optimizer guys are almost gone. They left a while ago to MontyAB.

Replication? They are all there minus the guy who wrote the first version (which is still pretty much what is used today). Him? He does consulting for different companies, but he left MySQL in 2002 or so. The execution/trigger system is a bit of combination. The "pre-stored procedures" stuff was all written back in the day, and little of it has changed, …

As Oracle bolsters MySQL development community with engineering and support resources, MySQL may be better able to fend off competition from the NoSQL movement.

I attended a panel session at the South by Southwest Interactive conference recently on the topic of high-tech startups in Europe.  The panel included Marten Mickos (former CEO of MySQL, now at Eucalyptus), Resham Sohoni (CEO of Seedcamp), Peter Robinett (Bubble Foundry) and Felix Petersen (Nokia).  It was interesting to learn about some of the initiatives, like Seedcamp, which are investing in and promoting startup companies like Erply, and Codility coming out of eastern europe. These companies are small, but they have big ambition and are leveraging open source and cloud infrastructures to keep their costs low.

…

MySQl 5.5 is getting more and more solid, and one thing recently (at least I think so) pushed is the Audit plugin. Currently, this is only in the source repository (I tried from 5.5.4-m3). This prugin is actually quite useful, more useful than you might expect. Any event that would cause a write to the general query log will send a notification to a function in this API, and note that this will happen even if the general query log is enabled or not.

The stuff that gets passed to the notification function is a struct with similar data that gets written to an entry of the general query log, but don't let this limit you, also passed is a pointer to the THD class for the thread that caused the notification. And if you haven't looked a lot at the MySQL sourcecode, note that the THD class has MANY members, and contains all sorts of information.

If you wanted to create your own general log, that would allow filtering on, say, …

Last year Morgan Tocker published a graph of all MySQL forks when preparing course material on the topic. I've been preparing some material for Monty's keynote at the O'Reilly MySQL conference, and briefly touch the same topic so I have pictures too:

read more

I few of my friends (including Om) are crazy about the Sonos, but I’ve been a Squeezebox user for 6+ years now and have stuck with them through a few upgrades and the acquisition by Logitech. Some of their new products like the Squeezebox Radio are super-handy, I like that the whole thing works over my Wifi network, and it runs Open Source server software. (I used to run it on a Linux box, now on a Mac.) That said, the software has always felt clunky to me, the lack of a good iPhone client is annoying, and the multi-room sync is temperamental. They also seem to have stagnated under Logitech, for example the Radio is cool but the battery for it (which is half the sell) doesn’t come out until April, and costs another $50 — lame. Has anyone used both Squeeze devices and Sonos and have a preference?

There are times when what you have is a partially running database and a bunch of backup innodb tablespace files (the .ibd files). If you're using innodb_file_per_table, then you have a separate .ibd file for each InnoDB table.

Now, you have your running database with a bunch of tables, and you want to replace some of them with the backup .ibd files. According to the MySQL docs, you'd do this:

1. ALTER TABLE foo DISCARD TABLESPACE; (this deletes the current .ibd file)
2. copy the old .ibd file into your database directory
3. ALTER TABLE foo IMPORT TABLESPACE;
   

Assuming your .ibd file was from the same database and you did not drop the table and recreate it sometime between when you made the backup .ibd and now, this should work. Except... if …

I’m pleased to announce the first release of Kontrollcomm – “The Server Command Automation Interface” is a web-based application that automates remote command execution on linux and unix based servers. There are three main areas of the application: Hosts, Templates, and Commands. The use is very simple: all of your hosts are setup in the [...]

Its been a while anyone talked about Intel’s Hyper-Threading performance when it comes to databases. There were enough posts about disabling Hyper-Threading  completely when it comes to MySQL/InnoDB workloads way back when we had enough issues with scalability of InnoDB on multi-core systems. But things has changed quite a bit in the fast year or [...]

I finally got some free time to write up this new tech paper on how to migrate the parts of your MySQL databases that make sense to InfiniDB.  For those of you already familiar with InfiniDB, you can skip past the front 'why migrate' sections and go right to the "Migration Strategies" part that covers some general procedures and then goes on to give examples of various migration approaches.  And no, there is no registration on the site needed to get this paper.

If you find anRead More...