]]> ]]>

Developing High Performance, Scalable Applications

In a nutshell

What you will learn

  • How to optimize queries
  • How to design schema
  • Where scaling techniques like read/write splitting and sharding fit in best.

What you will not learn

  • How to write application code. This course is about how your application interfaces with MySQL, and as a result all examples are language neutral.
  • Are you building an Application on MySQL?
  • Are you worried that your architecture might not scale?
  • Are demands increasing, and you don't know what architectual decisions you need to take now will protect you in the future?

Our Developer's workshop may be just what you need!

Attendees of this workshop will be able to:

  • Be systematic about instrumentation, and how to measure performance of an application running in production.
  • Identify the successful patterns behind MySQL Applications, and what design decisions don't fit MySQL very well.
  • Learn at which point certain architectual changes make the most sense, including using replication for splitting reads/writes, caching, message queuing systems and database sharding.
  • Optimize Database Schema and Indexes so that efficient queries can be written.
  • Learn by case study how to solve some common application performance problems like paginating results, finding users near me and storing hierarchal data.
  • Understand if and when you should be leveraging newer MySQL features such as Stored Procedures, Triggers and Events.

Who should attend:

Application Developers

Prerequisites:

This is an advanced course, and recommends an understanding of SQL, and basic database concepts. Examples contained in the course will not be specific to any scripting language, but to be able to apply context to the examples we recommend you understand at least one web-scripting language.

Format:

This course is delivered as a one day intensive. Attendees will be provided with Linux PCs, but given the time restrictions hands on exercises will be limited. Slides will be provided for students wishing to apply additional study after the course is complete.

Applies to MySQL Versions:

5.0, 5.1, 5.1-Percona Server

Upcoming Sessions:

]]> ]]>