General
The top 20 design tips for MySQL Enterprise data architects
The slides from my 2008 MySQL Conference Presentation can be downloaded from here .
Read moreMy ‘hourly’ MySQL monitor script Version 0.03
I realized when I released my very crappy version of My ‘hourly’ MySQL monitor script I really should have included my standard logging. So I did that the night I wrote my original blog, but never published it.
Read moreReading the MySQL Manual
I was asked the question today, “How do I show the details of a Stored Procedure in MySQL. The SHOW PROCEDURE ‘name’ didn’t work.”. The obvious answer was SELECT ROUTINE_NAME,ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.
Read moreMySQL Cluster Certified
Jonathon Coombes recently blogged in MySQL Cluster Certified that he passed the MySQL Cluster DBA Certification as was the first Australian. Lucky for him I passed the exam after my presentation on the second day of the conference.
Read moreMySQL Conference – YouTube
MySQL Conference 2007 Day 4 rolled quickly into the second keynote Scaling MySQL at YouTube by Paul Tuckfield. The introduction by Paul Tuckfield was; “What do I know about anything, I was just the DBA at PayPal, now I’m just the DBA at youTube.
Read moreMySQL Conference – Get Behind Dorsal Source
In a community session yesterday at MySQL Conference 2007, I first heard about [Dorsal Source][1]. A collaboration between [Solid DB][2] and [Proven Scaling][3] that allows for community people to upload patches to [MySQL][4], get it compiled across multiple platforms, and have a downloadable distribution available on H/W individual contributors will never have access to.
Read moreMySQL Conference – PHP on Hormones
MySQL Conference 2007 Day 4 started early again at 8:20 am with PHP on Hormones by the father of PHP Ramus Lerdorf. A very funny man, one of the best insightful talks of the conference (rather scary actually).
Read moreMySQL Conference – Google
MySQL: The Real Grid Database Introduction Can’t work on performance problems until we solve the availability We want MySQL to fix our problems first. The problem Deploy a DBMS for a workload with too many queries to many transactions to much data A well known solution
Read moreMySQL Roadmap
Here are some notes from the MySQL Server Roadmap session at the MySQL Conference 2007. MySQL: Past and Future 2001: 3:23 2003: 4.0 UNION query Cache Embedded 2004: 41. Subqueries 2005: 5.
Read moreMySQL Conference – For Oracle DBAs and Developers
I have just completed my presentation at the MySQL Conference 2007 on [MySQL for Oracle DBAs and Developers][1]. Not mentioned in my slides, but referenced during the presentation was what I consider the most important page to document from the MySQL Manual — 5.
Read moreMySQL Conference – Building a Vertical Search Engine in a Day
Moving into the user sessions on the first day at MySQL Conference 2007, I attended Building a Vertical Search Engine in a Day . Some of my notes for reference.
Read moreMySQL Conference – RedHat Keynote – One Laptop Per Child
Our third keynote at MySQL Conference 2007 was titled Building the Ultimate Database Container with RHEL, MySQL, and Virtualization by Michael Evans. The presentation was on Red Hat & One Laptop Per Child.
Read moreMySQL Conference – The next keynote with Guy Kawasaki
Without missing a beat at MySQL Conference 2007, we moved from Marten’s keynote to The Art of Innovation by Guy Kawasaki. Extremely fun and entertaining. His 10 points. 1. Make Meaning
Read moreMySQL Conference – PBXT Recognized
As I mentioned in MySQL Conference – Rewarding the Community , Paul McCullagh, the creator of the Community Transactional Storage Engine PBXT won the Community Code Contributor of the Year award.
Read more