I will not bother to comment on Monty's keynote (but I did post the text to it so you can make up your own mind) and this brings us then back to the Tuesday and Oracle's opening keynote featuring Edward Screven.

read more

Somebody should teach me how to accept community contributions.
On Friday I looked at the second version of a community contributed patch. I.e. it was since then re-written. It's Bug#20837, and it again is an infrastructure issue that is identical in all our forks.

While looking at the patch, I encountered 7 issues, which I had to report:
Bug#53340, Bug#53341, Bug#53342, Bug#53343, Bug#53344, Bug#53345, Bug#53346.

(I won't go into the details how …

Recently (on April 19, 2010), Monty gave a Google Tech Talk, titled: MariaDB: The Backward Compatible Branch of the MySQL Database Server. The talk is under 47-minutes long, and the video is embedded below. Its a good introduction to what MariaDB has been up to for the last year+, aims, goals, and the future.

The Friday after the official MySQL conference was double booked. In parallel with the storage engine summit, Drizzle Developer Day 2010 was also happening. This event took the form of a hackathon, with free form discussions and hands on coding. I popped in, to experience the energy.

My conclusion both from Brian's keynote and the Developer Day is that:

read more

MySQL stored procedures are programs that are stored and can be executed on the MySQL server. Using MySQL Stored Procedure you can solve mysql related problem or task easily. Here I’m describing a stored procedure that I used to create some sample data. Read Full Article

Some days ago I was working in a vocabulary game and dictionary. The dictionary contains 1,10,000 words and meanings. I developed a vocabulary game where I had to randomly choose 10 words out of 1,10,000 dataset. Here I’m describing the possible solutions for retrieving 10 random words from 1,10,000…  Read Full Article

Forecasting Oracle Performance

Forecasting Oracle Performance. By Craig Shallahamer, Apress 2007. Page count: about 250 pages. (Here’s a link to the publisher’s site). Short version: buy it and read it, but make sure you don’t rely on it alone; deepen your knowledge through other sources.

I bought and read this book because I’m interested in performance, performance forecasting, and capacity planning. I’m not interested in forecasting Oracle performance per se. However, I have noticed that there is a lot of good literature in the Oracle arena that can apply to other databases (*cough* …

A big congratulations to Ubuntu for the release of 10.04 LTS. While I haven’t had the chance to upgrade, I see everyone on Twitter and in the blogosphere say they are really like the Lucid experience.

A couple of days ago, I made mention that there were VirtualBox images of MariaDB out there. Turns out there were so many downloads, Mark has had to upgrade his Internet connection!

Anyway, to the point: Mark has created Ubuntu 10.04 LTS VM’s with MariaDB 5.1.44 and MariaDB 5.2 BETA. Don’t hesitate to download them, and send feedback.

Have a good weekend …

While I was running around WordCamp San Francisco 2010 getting ready for the keynote, guest photographer Sheri Bigelow had my D3S and was snapping all around. Here are the photos from that day.

…

Another thing I find interesting about MongoDB is its approach to Durability, Data Consistency and Availability. It is very relaxed and will not work for some applications but for others it can be usable in current form. Let me explain some concepts and compare it to technologies in MySQL space.

First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, especially in newer versions which implement "sharding". Same as commit to NDB Storage engine does not normally mean commit to disk, but rather commit to network it does not mean commit to disk with MongoDB, furthermore MongoDB uses Asynchronous replication, meaning it may take some time before data will be at more than one node. You can also use getLastError() to ensure data is propagated to the slave. So you can see it as a hybrid between MySQL Cluster and innodb_flush_log_at_trx_commit=2 mode. The second difference of course the fact MongoDB is not crash safe - similar to …