Monty Program along with various guests and our friends at the recently founded SkySQL recently wrapped up a meeting in Istanbul Turkey. Sadly it rained most days but we had a good time and got a lot done.

Besides learning how to say “Şerefe” which is “Cheers” in Turkish, we discussed the future of MariaDB, our companies goals, the MariaDB knowledge base and many other topics. Since I am the web guy, I lead the presentation / talk on the KB and thought I would share some highpoints of it with you.

If you don’t know, the KB is located at http://kb.askmonty.org. The goal is to provide one location for MariaDB and MySQL documentation along with a place to ask questions (and have developers actually answer them). To start we have both information licensed under the GPL about …

Mea Culpa, Mea Culpa, Mea Maxima Culpa!
My fault, my fault, it’s all my fault! Why? Well because new versions = new bugs :) = wait till they are fixed, then use it!

As an ubuntu fan I just had to install 10.10 GA … and as a MySQL DBA I can’t run apt-get install mysql …. not even in my nightmares can I do that. Why? Well because if you are a car mechanic you don’t take your car for repairs to another mechanic and not ask what was done on it do you? You do it yourself right? That is what I did, I installed mysql 5.1.50, the same binaries I had downloaded and used on my 10.04 machine and loaded a dump. Woops, mysql crashed big time. I figured, lets install 5.1.51, load and … boom, again crashed.

The same dump, is loading fine on my 10.04 ubuntu server running both 5.1.50 and 5.1.51.


101018 12:48:26 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that …

I swear, my intention was to go for a break. A year taking pictures, sharing them over the web, writing texts, running, kayaking, just being social. Honestly, ask my family and friends!

But this was not to be, in spite of what I said when I announced my resignation just days ago. Instead, I am joining SkySQL Ab, the startup that aims to become a new centre for the MySQL universe. My role will span Marketing and Engineering, and is like the title “EVP Products” inspired by Zack Urlocker’s role at MySQL AB.

I would have preferred the company to have been called KajSQL, but have come to terms with the company having an extra phonetic “s” in the beginning. Quite a while ago, having eaten my favourite fish “ …

For more than nine years, I worked for MySQL AB and its successors, Sun Microsystems and Oracle. I handed in my resignation late June, two days before Sun’s German legal entity ceased to exist. Germany isn’t a country where you quit HP one day and join Oracle the next, so I had a long summer with plenty of so-called Garden Leave. Last Thursday was my last day, and I’m now outside MySQL AB, outside Sun Microsystems, outside Oracle.

Like all the many former colleagues who resigned before me, I did so with mixed feelings. Leaving the colleagues, finding freedom, I think you follow. The topmost feeling I have, the one I want to highlight right now, is gratitude. I’m very grateful for what MySQL AB has meant for my career, my personal development, my life experiences, my social life. Let me mention a small subset of the people that made my life at MySQL AB, and later Sun Microsystems, a truly memorable …

There are a few things to note RIGHT NOW for those of us in the world of open databases.

The MySQL User Conference has opened their call for proposals and the IOUG Collaborate11 call for proposals closes tomorrow 10/1!  Get your proposals in.

OpenSQLCamp is 10/15 -> 17 and BG is sending Patrick as I mentioned earlier this week.  If you’re in the area, I can’t urge you strongly enough to go listen, present what you’re working on, learn and get help from some amazing people doing really cool things on and in open databases.  It’s an un-conference format that has always had incredibly informative sessions.  I’ve attended the conference a few times, and came away with new ideas and solution each time.  …

There’s a new version of the dbbenchmark tool available. Now we’re creating the MySQL connection pool thread count based on automatic reporting of core quantity. There is still the same method to set the thread count manually if you are interested in finding your system’s thread limits. Download the MySQL benchmarking script now and add your server performance to the community database of results!

“and go on till you come to the end of Oracle OpenWorld: then soak your feet and start sorting through the piles of material in your conference bag.”

Congratulations to everyone who made it through their first OOW event, as well as the returning champions!

If you’ve still got any strength in your legs, or if you did not have a chance to go, come join us for MySQL in the Windy City on September 28!

I’ve just pushed the last batch of changes into 5.2 tree. The most important change was renaming Maria engine to Aria (with old maria* compatibility variables). Other — smaller — changes included adding all plugins to the windows .zip distribution (sphinx and oqgraph too), building mysqld.exe with federatedx, not old federated engine, refactoring of mysql-test-run suite to support pluggable per-suite extensions, print the plugin configuration in the ./configure script, and other even smaller changes. Together with all bug fixes that 5.2 has accumulated over time it made the tree ready for the next release – 5.2.2!

A few SQL queries are worth a thousands words:

mysql> SELECT VERSION();
+----------------+
| VERSION()      |
+----------------+
| 5.5.6-rc-debug |
+----------------+

mysql> SELECT @@global.storage_engine;
+-------------------------+
| @@global.storage_engine |
+-------------------------+
| InnoDB                  |
+-------------------------+

(Note: the above is without using the default storage engine option)

Scary! Excitement! MySQL!

MySQL has a well-earned reputation for being easy-to-use and delivering performance and scalability. In previous versions, MyISAM was the default storage engine. In our experience, most users never changed the default settings. With MySQL 5.5, InnoDB becomes the default storage engine. Again, we expect most users will not change the default settings. But, because of InnoDB, the default settings deliver the benefits users expect from their RDBMS — ACID Transactions, Referential Integrity, and Crash Recovery. Lets explore how using InnoDB tables improves your life as a MySQL user, DBA, or developer.

Background

In the first years of MySQL growth, early web-based applications didn’t push the limits of concurrency and availability. In 2010, hard drive and memory capacity and the performance/price ratio have all gone through the roof. Users pushing the performance boundaries of MySQL care a lot about reliability and …