I feel like I just got back home from Oracle OpenWorld (check out my pictures) and some vacation, but I'll be on the road again next week to attend LinuxCon Europe in Barcelona. I'll be there from Monday (Nov. 5th) until Wednesday evening. Oracle is sponsoring the event and we'll have a booth at the exhibition area (booth #19), handing out free Oracle Linux and Oracle VM DVDs. I'll be at the booth every now and then and plan to give a short introduction and live demo of Ksplice rebootless updates on Monday evening (6:00pm).

Two …

Next week I’ll be visiting Moscow to talk at Highload++. The conference will take place during Monday 22nd and Tuesday 23rd at the Radisson hotel. I will be giving my personal version of an indexing talk that my colleagues have given in meetups and conferences in the US.

Highload++ conference is targeted to address the issues of complex high traffic web properties. Most of these sites depend on databases to deliver their content, record the traffic and report the application activities in real time. As I learned early in my career at MySQL, the database schema and in particular the indexing strategy, are critical to achieve the highest possible performance out of the database. I’ll be reviewing the basic strategies to define the right indexes. I will also cover TokuDB’s Fractal Tree® and Cluster …

I’ll be presenting “MongoDB and Fractal Tree Indexes” at MongoDB Boston 2012 on October 24th.  My presentation covers the basics of B-trees and Fractal Tree Indexes, the benchmarks we’ve run so far, and the development road map going forward.

I’ve been to this one day conference twice now and both times came away with a better understanding of MongoDB’s capabilities, use-cases, and many questions answered via their deep technical dives.  I highly recommend current MongoDB users and anyone considering a MongoDB project attend – it appears that seats are still available.

Bradley and I (Michael) gave the tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference last month.

The tutorial was organized as follows:

• Module 0: Tutorial overview and introductions. We describe an observed (but not necessary) tradeoff in ingestion, querying, and freshness in traditional database.
• Module 1: I/O model and cache-oblivious analysis.
• Module 2: Write-optimized data structures. We give the optimal trade-off between inserts and point queries. We show how to build data structures that lie on this tradeoff curve.
• Module 2 continued: Write-optimized …

It was a great experience to attend the MySQL Connect Conference for the first time ever. Personally I was very much enthralled to present about "How to make MySQL Backups" besides attending different sessions to absorb more knowledge about the technical prospects of MySQL. One of the agenda items in my presentation was "MySQL Enterprise Backup" functionality and features. There were total of 40 attendees in the session, who were very much interested about the MySQL Enterprise Backup product and gave positive feedback as well as areas of improvements on our product. Some of our features brought lot of excitement and smile amongst our customers including,
…

We've been fully operational for one year today. Time to take a quick breath and look back at a year that was among the most exciting in our lives, and time to look ahead to the next 12 months. In which things are likely to get even better.

read more

We've been fully operational for one year today. Time to take a quick breath and look back at a year that was among the most exciting in our lives, and time to look ahead to the next 12 months. In which things are likely to get even better.

<

p>

read more

Tokutek sponsored the Percona Live MySQL / New York 2012 Conference which took place this past Monday and Tuesday.  I spent much of the time at our booth discussing TokuDB with conference attendees but also managed to attend the following presentations:

• Understanding Performance through Measurement, Benchmarking and Profiling by Rene Cannao of PalominoDB.  Rene presented 3 hours of content covering his methodologies, toolbox, and tips & tricks to help identify performance bottlenecks. Rene has obviously been optimizing systems for some time as I’ve never seen such a comprehensive list of tools and techniques.  This …

Love Python? Dig MySQL? Want to meet Oracle’s MySQL Python Experts?

Come and join us at the MySQL Connect 2012 conference in San Fransisco next week, 29/30 September. My colleague Chuck and I are both giving 3 sessions in which we discuss MySQL Utilities and Connector/Python.

Overview of our session:

• Talk: Developing Python Applications with MySQL Utilities and MySQL Connector/Python
• Hands on Lab: MySQL Utilities
• BoF: …

At next week’s Strange Loop conference, I will give a talk on “Understanding Indexing”. The session is 10 am Monday, September 24th, and will be held in the Midland States Room.

Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase application performance is to optimize the indexes. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance.

This is a general discussion applicable to all databases using indexes and is not specific to any particular MySQL® storage engine (e.g., InnoDB, TokuDB®, etc.). …