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.). …

It's that time of the year again — the summer holidays are over and the conference season starts!

I'm very excited to be at Oracle Open World in San Francisco again, where I will pretty busy. On Saturday and Sunday I will attend MySQL Connect, primarily to man the Oracle Linux booth in the exhibition area. But I hope to catch some of the talks as well (I shared my favourite sessions with Keith Larson from the MySQL team in this interview). During Open World, I will help out manning the Oracle Linux demo pods in the exhibition grounds in Moscone South, where we will showcase Oracle Linux with Ksplice and related technologies. I also have a joint presentation with two of our …

After a long pause in the speaking game, I am back.

It's since April that I haven't been on stage, and it is now time to resume my public duties.

• I will speak at MySQL Connect in San Francisco, just at the start of Oracle Open World, with a talk on MySQL High Availability: Power and Usability. It is about the cool technology that is keeping me busy here at Continuent, which can make life really easy for DBAs. This talk will be a demo fest. If you are attending MySQL Connect, you should see it!
• A happy return for me. On October 27th I will talk about open source databases and the pleasures of command line operations at …

Next week Michael and I (Bradley) will be travelling to Silicon Valley to present a tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference.

The tutorial, which is 4 hours on Monday afternoon, aims to cover the following topics (but it’s looking like we’ll have to drop several items for lack of time.)

This tutorial will explore data structures and algorithms for big databases. The topics include:

• Data structures including B-trees, Log Structured Merge Trees, and Streaming B-trees.
• Approximate Query Membership data structures including Bloom filters and cascade filters.
• Algorithms for join including hash joins and Graefe’s generalized join.
• Index design, including covering indexes. …

ConFoo is one of the most important web developer-oriented conferences. ConFoo 2013 will be held on February 25 through March 1 in Montreal, Canada.

We just opened call for papers and we are looking for the best PHP, Java, Ruby, DotNet,HTML5 experts who are willing to share their knowledge with the Canadian community. Candidates can submit proposals until September 23. Consult the call for papers page for details and to start submitting. That page also explains what expenses ConFoo can cover for speakers. You can also get advice on how to write proposals.

The call for papers is public, meaning that all proposals get published on the website for others to vote and comment on. This approach allows the organizers to pick subjects that have …

At the end of September, the MySQL Connect 2012 conference will be held as part of Oracle OpenWorld in San Francisco. MySQL Connect is a two day event that allows attendees to focus on MySQL at a technical depth with presentations and interaction with many of the MySQL developers, engineers and other knowledgeable staff. There is also a range a international speakers to give broader knowledge to the presentations.

I am presenting a Hands-On Lab on Sunday 30th September 16:15 - 17:15 entitled HOL10474 - MySQL Security: Authentication and Auditing. The sessions goes through an introduction to the plugin API and how it can help expand the capabilities of MySQL. Since it is a hands-on lab, …

Next week I (Bradley) will be traveling to FROSCON near Bonn, Germany, and then on to VLDB in Istanbul.

At FROSCON I’ll be talking about fast data structures for maintaining indexes. The talk will share some content with my upcoming MySQL Connect talk.

At VLDB, Dzejla Medjedovic will be presenting a talk on our paper on SSD-friendly Bloom-filter-like data structures. The paper is

Michael A. Bender, Martin Farach-Colton, Rob Johnson, Russell Kraner, Bradley C. Kuszmaul, Dzejla Medjedovic, Pablo Montes, Pradeep Shetty, Richard P. Spillane, and Erez Zadok.
Don’t Thrash: How to Cache Your Hash on Flash. PVLDB 5(11):1627-1637, 2012.

An earlier version of the paper appeared at …

If you haven't already registered for MySQL Connect, now is the time to do it.

Looking for the right reason to attend? Here are the TOP THREE REASONS...

• You'll get the chance to hear directly from users including PayPal, Verizon, Twitter, Facebook, Ticketmaster, Ning, Mozilla, CERN, Yahoo! and more, about best practices for deploying MySQL based solutions.
• Don't miss this unique opportunity to meet the engineers developing and supporting the MySQL products, all in a single location. You'll be able to ask them all your questions and provide them feedback.
• Acquire detailed knowledge about the latest …