The latest from the MySQL community

Round 2. Question 2? From the MySQL Quiz Show. (you had to be there)

I spend the past week in florida. First visiting my parents and then spending time at php|tek where I was invited to give two talks. I was quite nervous about the first talk about "database schema deployment". My original intention was to create a working solution to handle scripting the necessary DDL and DML statements to manage schema updates. However while researching the topic I found that its even less trivial than I expected. So during my talk I was mainly giving some basic ideas along with a number of ideas to explore depending on the needs. For example if all you care about is generating DDL then things are quite simple. In the past MySQL indirectly benefited from the simplicity of the database but with foreign keys, views, stored procedures and triggers even generating DDL is not entirely …

Thursday’s Keynote speaker at the MySQL Conference was Mark Shuttleworth talking on The Ubuntu Project: Improving Collaboration in the Free Software World.

Ubuntu from Canonical Ltd is fastly becoming one of the most popular Linux Distributions, based on Debian. Here were some notes from his presentation. Mark had some really powerful one or two line slides that typified both his presentation intention and the goal of Ubuntu.

Delivering on the Promise of Free Software

• MySQL levelled the playing field, individuals could use MySQL to build applications that could now compete in the …

I heard Cory Doctorow about a week ago (yes, we have cool international speakers here in Melbourne all the time!), and if there was only one thing you’re really meant to take away from his talk, I think I found the gem.

Cory signs a book

We’re usually told content is king. He says thats a myth. Have you seen the six trillion dollar industry, that is telecommunications? (okay, I don’t know if that stat is remotely correct…) So the content is king idea is bollocks. What is really king is community and inter-personal communication. Getting people to talk about it. Humans are terribly social beings, so yeah, go community.

“Trying to kill MySQL by acquiring open source is like trying to kill
a dolphin by drinking the ocean.” — Marten Mickos

And yes, that quote ties in well with the …

I can relax now, My talk is done and I’ve been talkinq to people about more specific things. Several have congratulated me on it.

Looking forward to the BOF, although sleep would be nice.oh how I’m going to sleep on the plane

In having a discussion with Paul McCullagh (the creator of PBXT transactional storage engine) and Taneli Otala MySQL AB CTO after the keynote presentation at the MySQL User Conference, Taneli made the following comment (paraphrased and reproduced with permission).

“I talk about PBXT in discussions shamelessly. The development of PBXT was excellent timing in the MySQL community landscape”.

It was an excellent commendation that MySQL AB management considered so highly the contributions from the community. As mentioned in the opening keynote, MySQL with the Storage Engine API with MySQL 5.1 has great potential to expand what options are available to user of MySQL.

Good work Paul. I like many others wish you the best in your continued development and contribution. …

It just dawned on me as this topic was mentioned in a MySQL Conference presentation yesterday in a manual process. So my thought is, why can’t the following functionality be added to the MySQL server.

My request for two new extensions to the SHOW STATUS command.

SAVE STATUS - This enables the current SHOW STATUS to be saved (or more specifically cached), you can only keep one copy per server instance.

DIFF STATUS - This shows the difference between the current SHOW STATUS and the last saved show status from the SAVE STATUS command.

This would quickly, easily and interactively via a mysql prompt enable a DBA to see the state of change in a more condensed form. The syntax may need to cater for Session/Global scope, and of course would need to be appropiately named, my examples is just an idea.

Of course you can write an easy script that does the same, …

I’ve just attended Scott Ambler’s presentation on Agile Database Techniques: Data Doesn?t Have to be a Four-Letter Word Anymore at the MySQL Users Conference.

There is so much content on the topic, it’s impossible to present so much information in a short 45 minute session. I can speak with authority in regards to the same problem of condensing so much content given this issue with my own presentation MySQL for Oracle Developers.

I ask this question. Why is common sense considered such a radical approach? I state this because Agile Methodology approaches in so many ways are common sense, but …

I know how much I hate data entry. So do the MySQL folks a favor — if you’re at the Users conference, fill out an evaluation form for the conference at:

http://www.oreilly.com/go/confeval

and a speaker evaluation for each session at:

http://www.oreilly.com/go/spkreval

It took me a while to find the links, so I’m posting them here. I find myself writing down comments during the talk anyway, so having the browser open and writing comments directly into the eval form is useful for me.

And you have your laptop with you anyway (you’re reading this, aren’t you?). So pop open a browser and spend 2 minutes after each presentation giving feedback. Who knows, you might win something too!

Mike writes a good summary of the MySQL Conference opening keynote State of the Dolphin: Interview with Kaj, Monty and David of MySQL.

I’d like to add just two comments.

Firstly, it was great to see community awards to Giuseppe, Roland, Marcus and Rasmus. Well done!

Second, it was a great thing to see on the slides a reference to Paul’s PBXT Transactional Storage Engine. A MySQL storage engine from the community. I’ve had a chance to meet Paul and have a number of great discussions with him. I wish him all the best, and I’m happy to contribute what I can to see his engine make it into the MySQL product in the future.