Posts Categorized: Pythian Appearances
By now you know that there is a MySQL Track during next week’s ODTUG Kaleidoscope in Washington, DC. Ronald Bradford and I organized the schedule at the last minute (Ronald did a lot of the work!). It was difficult to fill a schedule with 19 sessions that are either 1 hour or 1.5 hours long, and to do it I ended up with three presentations. At each presentation I will be giving away a copy of The MySQL Administrator’s Bible, so be sure to show up! All MySQL track sessions are in Maryland C, and all times are Eastern.
NoCOUG Spring Conference 2010 is in just 10 days, I’ll be doing my two hour long presentation — Demystifying Oracle RAC Workload Management. If it’s your local conference, I hope you can attend and say hello. You might also want to download the whitepaper that I put together few years ago for Hotsos Symposium — Oracle RAC Workload Management.
We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle.
I want to post the slides of the two presentations I did. My first presentation was a double slot session about Oracle Clusterware internals. My second presentation was about how we designed and run 1TB MySQL database in high availability setup.
Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).
I’m looking forward to traveling to San Jose for this year’s MySQL Conference. If there’s anything that can trump the drama of conf two years ago, where we observed how Sun would handle its new property, and then the drama of last year, where we observed how Oracle would handle the pending acquisition, it’s going to be the drama around this one — the first MySQLConf since the Oracle/Sun merger has been finalized and approved.
Here are the slides from my presentation at RMOUG 2010. I am not sure how much sense all this will make without my comments. We may do it in a webinar if there is sufficient interest. Regardless I will probably be doing it again at some point in the future.
What should you expect coming to the Hotsos Symposium 2010? It’s 3 days packed with sessions on all aspects of Oracle performance optimization whether it’s design, troubleshooting, development, methodologies and processes. Legendary Tom Kyte — who else can you expect for the keynote?! If you take an optional training day with Tanel Poder then you are likely to learn at least as much about troubleshooting Oracle database performance as you do during the conference and probably even more. Every presentation by Tanel has been an eye opener for me. If you’ve seen his material, you’d know what I’m talking about. Now, imagine that it’s not a one-hour session but the whole day! It will fry your brains so this day is for the strongest! :)
Last month at the Boston MySQL User Group, I went through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. I also explained how to recognize when you want those types of joins, and best practices for the semantics of writing joins and design patterns. Subqueries were explained in this session, and some examples of how to think differently so that you end up writing JOINs instead of subqueries. The slides and video are posted here.
I’m so much looking forward to the next conference in my schedule — RMOUG Training Days 2010. It would be only my second time I’m presenting at the RMOUG but it was enough to go there once to understand that it’s one of the top rated Oracle User Group conferences in the world. Some of the great speakers are presenting and registration fees are very low compare to other events of comparable quality. If your conference budget is low this year — that’s the conference you don’t want to miss!