MySQL Connect is just around the corner and one of the most popular speakers in the MySQL Community is Yoshinori Matsunobu from Facebook. This year we are lucky to have him as a speaker.
What are your speaking about at your session?
MySQL 5.6 at Facebook
Who would benefit most from attending your session?
People considering to upgrade to 5.6. I have heard many people are waiting until
we (Facebook MySQL team) deploy 5.6 in production. I can tell you our story.
What other sessions would you recommend or are planning to attend?
MySQL at Twitter [CON8194]
InnoDB: Table and Index Data Structures Architecture [CON6897]
Unlocking MySQL: Dealing with Locking in MySQL [CON4038]
MySQL Replication: Deep Dive into GTIDs for Scaling and High Availability [CON2610]
MySQL @ Facebook: Lots and Lots of Small Data [CON7446]
What did you learn last year at MySQL Connect that really benefited you?
I missed MySQL Connect last year since I needed to take care of my baby on weekends. This year I can attend full days so I’m looking forward to seeing ex-colleagues at Oracle and outside experts.
Why should ‘Joe Average’ DBA or Developer attend MySQL Connect?
Network with many people in the MySQL community. Learn what features in 5.6 are useful, what features are (a bit) scary.
MySQL Connect Tutorials, Monday September 23
Join us for a full day of MySQL tutorials delivered by Oracle’s MySQL Engineers. Whether you are getting started with MySQL or an experienced user, you will have the opportunity to acquire in-depth knowledge, directly from the source.
MySQL Connect Tutorials are available to MySQL Connect registrants, as an add-on package. For more information, go to the MySQL Connect registration page.
Tutorials and Schedule:
10:15 a.m.–12:30 p.m.
Getting Started with MySQL: Learn the Essentials
“How do I…?” “What is…?”…: Whenever you start working with a new technology, you have a lot of questions. This tutorial is designed to answer many of the common questions and cover most of the highlights for starting out with MySQL and to help you get going. It covers the basics, including the background and features of MySQL, installing MySQL, “talking” to MySQL, MySQL’s architecture, storage engines, datatypes, and log files. In addition, it discusses security with MySQL, backups, and monitoring of the system.
Ligaya Turmelle, Principal Technical Support Engineer
How to Analyze and Tune SQL Queries for Better Performance?
Performance of SQL queries often plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning to increase performance. This tutorial covers query processing, optimization methods, and how the MySQL optimizer chooses a specific plan to execute SQL. It demonstrates how to use tools such as EXPLAIN and Optimizer Trace to analyze query plans the MySQL optimizer produces. Based on the analysis, the tutorial shows how to take the next steps for performance tuning. It might mean forcing a particular index, changing the schema, or modifying configuration parameters.
Øystein Grøvlen, Senior Principal Software Engineer
1:15 p.m.–3:30 p.m.
Enhancing Productivity with MySQL 5.6 New Features
This tutorial focuses on a selection of MySQL 5.6 new features that have a dramatic impact on productivity and agility for developers and DBAs :
NoSQL with the InnoDB memcached API
InnoDB FULLTEXT indexes
Major optimizer improvements
Enhanced EXPLAIN and tracing
Transportable table spaces and partitions
Table space management options
InnoDB online schema changes
Performance_schema in practice
Each subject is illustrated by sample code and bundled in a Web application demo.
Arnaud Adant, Principal Technical Support Engineer
MySQL 5.6 Replication Tips and Tricks
MySQL 5.6 is the best release ever of the world’s most popular open source database, with the most-significant enhancements to MySQL replication. This tutorial imparts in-depth knowledge directly from the engineers behind MySQL replication. You’ll learn how to get started with features such as GTIDs and autofailover or manual switch-over, multithreaded and crash-safe slaves, checksums, and DevOps utilities. Previous releases are also covered. This intense, high-energy session will extend your portfolio of tips and tricks for building highly scalable, available database services, with a deep dive into MySQL replication and tools.
Luis Soares, Senior Software Engineer
4:00 p.m.–6:15 p.m.
Getting Started with MySQL Cluster
This MySQL Cluster tutorial delivers an in-depth course on how to get started with MySQL Cluster. It guides you through all the steps needed to set up MySQL Cluster, either manually or in an automated manner, and provides an overview of its functionalities, with a focus on understanding how to size MySQL Cluster and its hardware resources. You will learn about typical gotchas and initial performance considerations. Finally, you will be guided through all design decisions, based on a real-world architecture.
Bernd Ocklin, Director, MySQL Cluster Engineering
MySQL 5.6 Performance Tuning and Best Practices
This tutorial is a deep dive into MySQL performance. There’s been spectacular progress over the past few years, and it’s hard to imagine that just five years ago, MySQL did not scale up well. MySQL 5.6 now may be able to use your 32-core server nearly to full power, but there’s no silver bullet and really high performance is rare out of the box. You must think, analyze, and tune your hardware, system, and MySQL configuration; learn your workload problematics; and be aware of MySQL internals, limitations, and workarounds. This session shows how to make MySQL fly! You’ll hear about the latest achievements and best practices.
Dimitri Kravtchuk, Performance Architect