Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Here are my slides from past conferences. They were generated from Org Mode and Beamer. You can read more about it here.
You can get more info on the talks on their respective pages(linked).
Talk at FOSDEM 2013:
Feed me more: MySQL Memory analysed from Raghavendra Prabhu Talk at PLMCE 2013:
…
[Read more]5 years of MySQL
People often write a blog post when they reach some nice anniversary since they joined MySQL community. Well, for those old enough it usually means when they joined MySQL AB as employee. For me this was January 2008. Because I didn't remember the month correctly, I haven't blogged anything then, but decided to save it for a better opportunity - now.
TL;DR Starting this week I will be working for 10gen, selling MongoDB to the Nordics. This blog post is really long - even then it doesn't contain the most interesting stories, I'm not sure if they can ever be published. Sorry for the length, but remember you don't need to read all at once. This is my last MySQL post so save some of it for cold winter days!
2008 - Sun acquisition
Below are the slides from my last talk at this Percona Live Worldwide MySQL Conference. The idea for this talk was proposed by my co-presenter Massimo Brignoli and goes back to a debate on this topic that went through the MySQL blogosphere during last Autumn - which in itself was sparked by an outstanding retrospective published about a MySQL failure at Github.
MySQL Community Awards 2013 were announced earlier today at the MySQL Conference & Expo...
***
It's time again to award persons, applications and companies in the MySQL Community. This is an annual tradition to highlight and give appreciation to some of the things that make MySQL so great.
The first awards were given out in 2005, and since 2010 the winners have been chosen by a community panel of which myself and Shlomi Noach are the co-secretaries. There has been a public nomination period in January and the final voting is done by a panel who are themselves former winners of the award.
The first category is
MySQL Community Awards: Community Contributor of the Year 2013
The first winner is...
Jeremy Cole
Good morning Percona Live visitors! Attached to this post you can find a spreadsheet (both LibreOffice or Excel, as you prefer) that you can use towards the end of my tutorial. I've also attached the slides so you can download a copy of them.
I recently wrote about Where are they now: MySQL Storage Engines and The MERGE storage engine: not dead, just resting…. or forgotten. Today, it’s the turn of the MEMORY storage engine – otherwise known as HEAP.
This is yet another piece of the MySQL server that sits largely unmaintained and unloved. The MySQL Manual even claims that it supports encryption… with the caveat of having to use the SQL functions for encryption/decryption rather than in the engine itself (so, basically, it supports encryption about as much as every other engine does).
The only …
[Read more]I don’t get to say this often, but “I’m hiring” (at Percona):
I’ve been with Percona for about 5 years, so I can tell you: it’s probably the best company to work at: great pay, great benefits, great people, and truly driven by a desire to do right by customers and do good work. What more can you ask for? Of course, all these jobs are MySQL-related: Perl + MySQL, PHP + MySQL–maybe the UI/UX job less so, but still close enough.
This morning, this Percona XtraBackup bug came to my attention: https://bugs.launchpad.net/bugs/1170340 - basically, it’s now really quite tricky to determine if a MySQL server you’re connected to supports partitioning or not.
If you’re connected to anything less than MySQL 5.6, you can use have_partitioning variable. But since that’s gone in 5.6, you’re going to get a false negative if you’re connected to 5.6. You could use INFORMATION_SCHEMA.PLUGINS table, but that’s not there in 5.0, so you have some added workarounds to add there too.
A simple version check could be the solution… but what if you compiled the server without partitioning support?
I’ll be on a whistle-stop tour of California next week, including two presentations at the Percona Live MySQL Conference and Expo.
On day one at 1:20pm I’ll be presenting CAP Theorem: Two out of three ain’t right, in which I will be challenging the popular ‘two out of three’ explanation of CAP Theorem, examining the evidence from a variety of experts, including Dr Eric Brewer.
Then on day three at 9:00am I’m very honoured to be providing a keynote presentation, The State of the MySQL Ecosystem.
Here’s an overview of the presentation:
It is now over three years since Oracle …
[Read more]I’m planning my calendar and thought I’d share what talks I’d be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013.