Conferences

Slides for Configuring MySQL for Optimal Performance

On Sunday at Collaborate 11, I delivered a 6-hour presentaton on "Configuring MySQL for Optimal Performance".  While there was a lot of discussion and points made that are not captured in the slides and their notes, if you want to download the slides/notes there is a 1.0 Mb PDF at http://bit.ly/iiKjoJ.

Also, you may have noticed that PalominoDB's website features a new "Community" section, which includes a Presentations page where all our slides and videos can be found.

Experienced MySQL DBA Guide to Collaborate

So, you are going to Collaborate (or thinking of going) and you saw my blog post about what to go to if you are a beginner with MySQL. But what if you are more experienced with MySQL? There is plenty of content for you too! I have put together this list of what I would recommend to an experienced MySQL DBA at Collaborate. This is not a complete list of all the choices at Collaborate.

Note that several weeks ago Sarah Novotny and I did an OurSQL podcast about Collaborate, including information on how to get $200 off the registration price. The information there is very different from what is in this blog post, so I would recommend listening to the podcast and reading this post.

Collaborate has a Deep Dive Day on Sunday, April 10th from 9 am - 3 pm. There is one MySQL deep dive, which I am presenting, on Configuring MySQL for Optimal Performance. This is a day-long, intensive session, so it is perfect for those with experience with MySQL.

Whether or not you attend the Deep Dive, I would recommend that anyone interested in MySQL come to the MySQL Community Dinner East at Maggiano's Little Italy at Pointe Orlando on Sunday, April 10th at 5 pm. There is no fee for the event, but it is a pay-your-own-way dinner. We do ask that you RSVP at http://2011mysqlcommunitydinnereast.eventbrite.com/ so that we can give the restaurant a headcount.

I have found that the community dinner lets you meet colleagues in an informal manner, and it is great to be able to meet someone on Sunday that you will see later in the week. It is a way to start the conference off by getting rid of that "I do not really know anyone" feeling.

 

Monday, April 11th

Tomas Ulin, Oracle's Vice President of MySQL Engineering, gives a keynote on Monday morning from 9:15 am - 10:15 am about The State of MySQL. From the conference description, "Ulin discuss how MySQL fits into Oracle's ecosystem, specifically with Oracle database. He will highlight Oracle's continued investment in MySQL, and offer you a glimpse into product enhancements and focus areas for MySQL in the upcoming year. This session will set the tone for where MySQL product development is headed."

I think many MySQLers are extremely interested to hear what Ulin will say about where and how MySQL fits into Oracle's ecosystem. I only wish I could clone myself so that I could attend Tom Kyte's SQL Techniques, only some of which are Oracle-specific.

Next up on the schedule is the 10:30 - 11:30 session. The experienced MySQL DBA might want to learn about Galera - Synchronous Multi-Master Replication, or Understanding Indexing may be more your style.

During the quick tip session from 11:45 - 12:15, meet a MySQL guru and ask questions (or answer them!) during the "MySQL Office Hours". This has not yet been put on the schedule, but it will show up soon. Experienced folks may also want to learn about Boosting MySQL Replication Performance Through the Multi-threaded Slave, by three Oracle engineers, Andrei Elkin, Lars Thalmann and Luís Soares.

After lunch, go to the keynote by Kaj Arnö about MySQL: the Ecosystem, the Product, where Kaj explains the culture of the MySQL Ecosystem.

From 2:30 to 3:30 pm, the choices get more difficult. Replication is one of the cornerstones of MySQL architectures, and there are new features in MySQL 5.5, so I definitely recommend Oracle's own Mats Kindahl's presentation on MySQL 5.5 Replication. However, Tokutek's Bradley Kuszmaul explains How Fractal Trees Speed Up Trickle Loading While Maintaining Indexes, which is also a fascinating talk.

In the next session, if you are considering solid-state disks, Percona's Morgan Tocker gives An Overview of Flash Storage for MySQL. Or, learn about the strategies DBAs can use to make the database faster in Exploiting Fast Indexing in MySQL

Monday evening is the Welcome Reception in the Exhibitor Showcase from 6-8 pm.

 

Tuesday, April 12th

Sessions start bright and early on Tuesday morning, so if you are awake at 8 am I recommend Percona's Morgan Tocker speaking about Using Cacti to Graph MySQL's Metrics. Although for those who have not gotten a chance to learn about MySQL Cluster, the first session of the day should be Building Highly Available Scalable Real-Time Services with MySQL Cluster by Oracle's own Andrew Morgan.

At 9:15 go to the in-depth, technical Mysql Bootcamp: Day to Day MySQL administration given by Garmin's Ben Black and Mark Filipi. Continue the technical bootcamp learning with Mysql Bootcamp: The 7 (or So) Deadly MySQL Perfomance Sins by Percona's Matt Yonkovit.

During the quick tip session from 11:45 - 12:15, continue the bootcamp learning with Percona's Morgan Tocker as he delivers MySQL Bootcamp: Choosing hardware for your MySQL Server. Or, if three bootcamps in a row is too much, meet a MySQL guru and ask questions during the "MySQL Office Hours".

After lunch, there is over an hour dedicated to the Exhibitor Showcase, so there is no need to be worried about finding time to see the exhibitor booths. At 3:15 pm, experienced MySQL DBAs will have a hard time choosing between Alex Gorbachev explaining Monitoring MySQL with Oracle Grid Control and mySQL Bootcamp: Scalable Architecture and Design for MySQL by Percona's Bill Karwin.

For the last session of the day, experienced MySQL DBA's will likely want to attend MySQL Bootcamp: Server Performance Tuning, although learning about Scaling MySQL in the Cloud with ScaleDB's Shared Cache Storage Engine from Moshe Shadmon, founder and CTO of ScaleDB.

On Tuesday evening, the Exhibitor Showcase hosts the Happy Hour, which is a great place to continue conversations and unwind after a day of filling your brain. This also marks the halfway point of the conference, with 2 full days of sessions behind you and 2 days of sessions to go!

 

Wednesday, April 13th

Make sure you are awake at 8 am, because beginners will have to figure out if it would be better to learn about Toolkits for MySQL Users: Aspersa and Maatkit by Kenny Gryp of Percona or Sharding Techniques for MySQL by Oracle engineers Lars Thalmann, Luis Soares and Mats Kindahl. From there, experienced DBA's should head to Bill Karwin's Security Bootcamp: SQL Injection Myths and Fallacies.

At 10:30 am, I recommend either MySQL Enterprise Backup to learn about the official backup solution for MySQL, or Anatomy of a Database Attack by Josh Shaul of Application Security (aka AppSec).

During the quick tip session from 11:45 - 12:15, come to the MySQL Office Hours and hang out, asking or answering questions with other MySQL gurus.

After lunch, experienced DBAs have to choose whether missing Giuseppe Maxia's Dealing with Large Data with MySQL Partitioning and Replication is worth it to attend Calvin Sun of Oracle's InnoDB: Status Architecture and Latest Enhancements. I have no idea how I will choose which session to attend, so I certainly cannot give advice there!

You will not have time for a nap in the afternoon; the next session has great sessions too. For those who want to learn about the new ways to authenticate to MySQL, including how to develop their own plugins, Oracle's Georgi Kodinov explains it all in an Introduction to MySQL External Authentication. Or learn about Using MySQL Proxy to Perform Change Data Capture (CDC) by WebAssign's Roger Booth.

The last session of the day on Wednesday would be well-spent at my own Keeping a MySQL Slave in Sync Using mk-table-checksum and mk-table-sync or at Giuseppe Maxia's MySQL Sandbox : a toolkit for productive laziness.

Hopefully you have not been too tired out by a day of learning, because Wednesday evening is time to party it up at the COLLABORATE 11 Party at Universal Studios Islands of Adventure. I am looking forward to have the run of a huge theme park while it is closed to the public. I probably do not need to even explain my excitement about seeing The Wizarding World of Harry Potter™, but I am also excited to see Jurassic Park® and Marvel Super Hero Island® (I have special affinities for the Incredible Hulk and Spider-man). There are extra tickets available, so if you are bringing your children to this event, there is plenty of Dr. Seuss related fun.

 

Thursday, April 14th

Educational sessions start a bit later today, so it should be a bit easier to drag yourself out of bed. It is completely worth it to learn about Percona Server with XtraDB from Morgan Tocker. At 9:45, learn about Models for Hierarchical Data with SQL and PHP by Bill Karwin.

The last session for Thursday is before lunch, and I will be giving a talk about Nagios Plugins for Monitoring MySQL, because it is essential to monitor MySQL to be aware of problems. However, for those who are more focused on development, go see Bill Karwin's SQL Antipatterns: The Next Generation.

Again, please note that the list above is not comprehensive. It is simply a list I put together of the sessions I would recommend to a colleague who is an experienced MySQL DBA (whether or not he/she knows the Oracle base). There may be other choices I did not list which may be better for you and your organization's needs.

MySQL Beginner's Guide to Collaborate

So, you are going to Collaborate (or thinking of going) and you wonder if, as a MySQL beginner, there will be enough content for you. Or you wonder if there will be too much, and how you will ever decide on what to go to. I have put together this list of what I would recommend to a MySQL Beginner at Collaborate.  The schedule is still being tweaked at this point, so there may be great sessions being added or times may be changed, but I will try to re-post closer to the event.  The most up-to-date schedule is at the Agenda Builder - to see only MySQL content, choose MySQL in the "Product Lines" section.

Note that a few weeks ago Sarah Novotny and I did an OurSQL podcast about Collaborate, including information on how to get $200 off the registration price. The information there is very different from what is in this blog post, so I would recommend listening to the podcast and reading this post.

Collaborate has a Deep Dive Day on Sunday, April 10th from 9 am - 3 pm. There is one MySQL deep dive, which I am presenting, on Configuring MySQL for Optimal Performance. This is a day-long, intensive session, so it may not be appropriate for someone who has never used MySQL before, but a MySQL novice would certainly learn plenty.

Whether or not you attend the Deep Dive, I would recommend that anyone interested in MySQL come to the MySQL Community Dinner East at Maggiano's Little Italy at Pointe Orlando on Sunday, April 10th at 5 pm. There is no fee for the event, but it is a pay-your-own-way dinner. We do ask that you RSVP at http://2011mysqlcommunitydinnereast.eventbrite.com/ so that we can give the restaurant a headcount.

I have found that the community dinner lets you meet colleagues in an informal manner, and it is great to be able to meet someone on Sunday that you will see later in the week. It is a way to start the conference off by getting rid of that "I do not really know anyone" feeling.

Monday, April 11th

Tomas Ulin, Oracle's Vice President of MySQL Engineering, gives a keynote on Monday morning from 9:15 am - 10:15 am about The State of MySQL. From the conference description, "Ulin discuss how MySQL fits into Oracle's ecosystem, specifically with Oracle database. He will highlight Oracle's continued investment in MySQL, and offer you a glimpse into product enhancements and focus areas for MySQL in the upcoming year. This session will set the tone for where MySQL product development is headed."

Next up on the schedule is the 10:30 - 11:30 session. For a beginner interested in technical details, I recommend MySQL Performance Basics, given by Baron Schwartz.  For a beginner wondering about where to run MySQL, do not miss Jonah Harris of myYearbook.com speaking about Oracle or Open Source? Why not both?

During the quick tip session from 11:45 - 12:15, meet a MySQL guru and ask questions during the "MySQL Office Hours". This has not yet been put on the schedule, but it will show up soon.

After lunch, go to the keynote by Kaj Arnö about MySQL: the Ecosystem, the Product, where Kaj explains the culture of the MySQL Ecosystem.

From 2:30 to 3:30 pm, the choices get more difficult. Replication is one of the cornerstones of MySQL architectures, so I definitely recommend Oracle's own Mats Kindahl's presentation on MySQL 5.5 Replication. However, Percona's Matt Yonkovit is presenting Very Large Databases In MySQL: an Alterntive Energy Case Study, which is an excellent presentation showing how large amounts of data are collected from sensors and analyzed using MySQL.

MySQL is popular because it is fast; Oracle ACE Director Ronald Bradford gives his brilliant The most common MySQL scalability mistakes and how to avoid them so you can keep your database fast. However, beginners must know about backups and security, so I would also recommend seeing Lenz Grimmer speak about MySQL Backup and Security - Best practices.

Monday evening is the Welcome Reception in the Exhibitor Showcase from 6-8 pm.

 

Tuesday, April 12th

Sessions start bright and early on Tuesday morning, so if you are awake at 8 am I recommend seeing Morgan Tocker speak about Using Cacti to Graph MySQL's Metrics. At 9:15 continue to learn from Matt Yonkovit, who will give his 5 Minute MySQL DBA: Troubleshooting and Optimizations for UNDBAS where "un-DBA's" and beginners alike will learn how to laser focus on the pain points.

At 10:30, you will have had enough coffee to see Pythian's Alex Gorbachev explain the process of Building 2TB Highly Available MySQL Database. During the quick tip session from 11:45 - 12:15, meet a MySQL guru and ask questions during the "MySQL Office Hours".

After lunch, there is over an hour dedicated to the Exhibitor Showcase, so there is no need to be worried about finding time to see the exhibitor booths.

At 3:15 pm, MySQL beginners will have a hard time choosing between Alex Gorbachev explaining Monitoring MySQL with Oracle Grid Control and Oracle engineers Lars Thalmann, Luis Soares and Mats Kindahl giving an Introduction to MySQL Replication.

For the last session of the day, I recommend a change that has not yet gone into the online schedule - I will be doing a session on Converting tables from MyISAM to InnoDB.  I will put the link to the session here when it is available.

On Tuesday evening, the Exhibitor Showcase hosts the Happy Hour, which is a great place to continue conversations and unwind after a day of filling your brain. This also marks the halfway point of the conference, with 2 full days of sessions behind you and 2 days of sessions to go!

 

Wednesday, April 13th

Make sure you are awake at 8 am, because beginners will have to figure out if Sharding Techniques for MySQL by Oracle Engineers Charles Bell, Lars Thalmann and Mats Kindahl is more appropriate for them, or if it would be better to learn about Toolkits for MySQL Users: Aspersa and Maatkit by Kenny Gryp of Percona. From there, beginners should head to Morgan Tocker's MySQL Bootcamp on Optimizing MySQL Queries By Example.

At 10:30 am, I recommend either MySQL Enterprise Backup to learn about the official backup solution for MySQL, or MySQL Troubleshooting 101 by Garmin's Ben Black and Mark Filipi.

During the quick tip session from 11:45 - 12:15, do not miss the Introduction to the InnoDB Storage Engine for MySQL.

After lunch, a beginner who deals more with query writing/optimization should go to Peter Gulutzan and Trudy Pelzer's MySQL, Oracle and ANSI Syntax, which shows how MySQL's SQL syntax is different from Oracle and the ANSI SQL syntaxes. Those who are more on the administrative side of things should not miss Giuseppe Maxia's Dealing with Large Data with MySQL Partitioning and Replication.

You will not have time for a nap in the afternoon; for beginners in dual environments, Oacle's Luca Olivari explains Integrating MySQL and Oracle - The Journey of a Transaction. Of course, for those who want to learn about the new ways to authenticate to MySQL, including how to develop their own plugins, Oracle's Georgi Kodinov explains it all in an Introduction to MySQL External Authentication.

The last session of the day on Wednesday will be well-spent at Mark Riddoch of SkySQL AB's MySQL Bootcamp When to Choose MySQL - Real Examples of Database Platforms.

Hopefully you have not been too tired out by a day of learning, because Wednesday evening is time to party it up at the COLLABORATE 11 Party at Universal Studios Islands of Adventure. I am looking forward to have the run of a huge theme park while it is closed to the public. I probably do not need to even explain my excitement about seeing The Wizarding World of Harry Potter™, but I am also excited to see Jurassic Park® and Marvel Super Hero Island® (I have special affinities for the Incredible Hulk and Spider-man). There are extra tickets available and special children's prices --  if you are bringing your children to this event, there is plenty of Dr. Seuss related fun.

 

Thursday, April 14th

Educational sessions start a bit later today, so it should be a bit easier to drag yourself out of bed. It is completely worth it to learn about Running Multiple MySQL Instances on a Single Server. At 9:45, I expect beginners will fill Introduction to Using MySQL in Cloud Computing. The last session for Thursday is before lunch, and I will be giving a talk about Nagios Plugins for Monitoring MySQL, because it is essential to monitor MySQL to be aware of problems.

Again, please note that the list above is not comprehensive. It is simply a list I put together of the sessions I would recommend to a colleague who is a MySQL beginner (whether or not he/she knows the Oracle base). There may be other choices I did not list which may be better for you and your organization's needs.

Collaborate Speakers, Upload Presentations and White Papers by March 1st!

For those of us speaking at Collaborate, do not forget that for one-hour sessions, presentations and white papers must be uploaded by Tuesday March 1st - tomorrow!    As discussed in the speaker webinar, all one-hour presentations require a white paper in addition to a presentation, and neither are optional.  There are white paper and presentation templates.

If you have misplaced how to upload your paper and presentation, there was an e-mail about a week ago explaining how to do it.  I am pasting the contents of that e-mail here:

 

In order to upload your paper and/or presentation, follow the instructions below:

·         Go to:  http://www.call4abstracts.com/c4a/

·         Enter your login and password

·         Click on the ‘notifications’ box

·         Click on ‘review invitations’ on the left navigation bar

·         Choose the session in which you want to upload a file

·         Click ‘edit’

·         You will see the option to browse and upload your file

·         Click ‘save’ and then click ‘finish’ 

I spent a lot of time over the weekend creating and updating presentations and white papers for my sessions.  I was a bit worried because I have never written a technical white paper before (not many MySQL folks have), but I found that a well-written presentation has all the content needed.  Once I got over the initial fear of writing a  white paper, and downloaded a few samples, I got the hang of it pretty quickly.

If you have any questions, feel free to contact me, or the speaker mentor via the speakers@ioug.org e-mail address.

 

Pictures from OpenSQLCamp Boston 2010

I have not seen folks posting any pics they took at OpenSQLCamp here, so I will post the few I have -- I have a few pictures of the Indexing Panel on Saturday (the participants and some audience shots), and one picture of Matt and Monty during the Friday night social event.  You can see them here.

(The indexing panel included MySQL, Postgres, Cassandra, CouchDB and MongoDB folks)

Some Videos from 2010 OpenSQL Camp Boston

 

 

OpenSQLCamp Boston has only been over for a week, but I already have about 2/3 of the videos uploaded to YouTube.  I have updated the schedule page with all the videos and slides I knew about.  I welcome comments with more information (e.g. links to slides, or tag or description suggestions for the YouTube videos).

Here's the list of videos and slides so far (also linked at http://opensqlcamp.org/Events/Boston2010/Schedule):

Adventures in Alternative Energy "Data Monitoring" with MySQL -- architecture and design case study - Matt Yonkovit, Percona - video

Cassandra and Lucene - Jake Luciani, Riptano - video - slides(slideshare)

Common MySQL Performance Blunders - Matt Yonkovit, Percona - video

Databases of the Future (Discussion) - Josh Berkus, PostgreSQL Experts - video

Keeping MySQL slaves in sync using Maatkit tools (mk-table-checksum, mk-table-sync) - Sheeri Cabral, PalominoDB, with input from Matt Yonkovit, Percona - video - slides (PDF)

 

The MariaDB Server -- What do you want from it? (intro + discussion) - Colin Charles, Monty Program AB - video

MySQL replication and the quest for a global transaction ID - Giuseppe Maxia, MySQL - video

MySQL Tuner 2.0 - Sheeri Cabral, PalominoDB - video - slides (PDF)

 

MVCC Unmasked: Implementation and Issues in Postgres, Cassandra, MySQL and CouchDB - Bruce Momjian,EnterpriseDB; Jake Luciani, Riptano; Rob Wultsch, GoDaddy; Josh Berkus, PostgreSQL Experts - video

Serialization in distributed DBS - Josh Berkus, PostgreSQL Experts -video

 

 

SQL Meets NoSQL: Mapping relational semantics onto a true multi-master, eventually consistent database (SlackDB) - Eric Day,Rackspace - video - note that there were no slides, only a discussion, so really it's audio, but it's up on YouTube, so there is video.

Teaching Developers SQL (Discussion) - Led by Josh Berkus, PostgreSQL Experts - video

 

OpenSQLCamp Boston in Detail

In short:

Register / see who's coming

Schedule (will be filled in with presentations before Saturday noon)

Session ideas (45-minute sessions)

Friday, October 15th - 6-10 pm, WorkBar Boston, 711 Atlantic Ave, Boston, in the basement.  Socializing, swag, raffles, dinner, beer and soft drinks.  Take public transit (South Station on the Red Line subway or Silver Line bus if coming from the airport) or a cab; parking can be quite expensive in that area.

Saturday, October 16th - 8:30 am - 5 pm, MIT Stata Center 1st floor, 32 Vassar Street, Cambridge.  Breakfast, lunch, tech presentations.  A short walk from the Kendall Square subway stop on the Red Line, or drive an park in any MIT lot -- even if it says parking permit only, that does not apply on the weekends.   

Sunday, October 17th - same as Saturday

-----

The longer form:

As many of you know, OpenSQLCamp Boston kicks off tomorrow night with a social event at WorkBar Boston from 6-10 pm, and will include a buffet dinner from the Pulse Cafe.  Even though WorkBar Boston is more "work" than "bar" - it is a coworking space - there will be beer as well (special thanks to IOUG for sponsoring this event in particular).  Whether or not you are drinking, I strongly recommend taking public transit or a taxi -- the location is across the street from South Station, a major bus and train hub.  South Station is on the Red Line of the subway, and there is also a Silver Line bus directly from the airport terminals. The subway and Silver Line fare is $2.00.

Make sure to get sleep because Saturday starts at 8:30 am at the MIT Stata center, 32 Vassar Street.  We start with breakfast, and then after a few introductory remarks we start making the schedule at 9:30 am.  Then there are 3 45-minute sessions, with lunch at 1 pm, a panel on indexing from 2-3 pm, and from 3-5 is open time to ask questions, work on projects that were discussed during the day, and otherwise hack during the hackathon.

OpenSQLCamp does not provide dinner, but usually at the end of the day people figure out where they want to go next, and we all go over to a bar or restaurant (or go to a few different ones depending on people's preferences and tastes). 

Sunday is the same schedule as Saturday, except there is an extra session slot because we do not need opening remarks and the planning session. 

Here's the detail of food, for those who are wondering:

Friday night catered by Pulse Cafe

Vegan and vegetarian appetizers, wraps (incl. vegan), salad, vegetarian lasagna.  Beer, soda, water, iced tea.

Saturday and Sunday breakfast catered by Panera bread

Fruit, bagels, pastries, hot egg & cheese and ham, egg & cheese sandwiches, coffee, tea.

Saturday lunch catered by Greek Corner

Hummus, grape leaves, Pastitso, Falafel, Gyros, Greek Salad (feta on the side)

Sunday lunch catered by Pita Pit

Assorted pitas including meat, vegetarian and vegan options.

I am very excited, and can't wait to see you there!

Syndicate content
Website by Digital Loom