]]> ]]>

MySQL Training for Developers from Percona

You will learn

  • MySQL query optimization
  • MySQL sharding use cases
  • Read/write splitting
  • Optimal architectures for MySQL

Not covered

  • How to write application code. This course is about how your application interfaces with MySQL, so examples are language-neutral.
  • InnoDB optimization (covered in InnoDB/XtraDB training).
  • Server administration (covered in DBA training).

An intensive one-day workshop for MySQL application developers seeking to build scalable high-performance applications.

  • Are you worried that your application's use of MySQL might not scale well?
  • Do you foresee increasing demands on MySQL, and you don't know what architecture decisions will protect you in the future?

Attendees of this workshop will be able to:

  • Be systematic about instrumentation, and how to measure performance of an application running in production.
  • Identify successful patterns behind MySQL Applications, and what design decisions don't fit MySQL very well.
  • Learn when architectural changes make the most sense, including using replication for splitting reads/writes, caching, message queuing systems and database sharding.
  • Optimize MySQL 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 and finding users near you.
  • Understand when to leverage newer MySQL features such as stored procedures, triggers and events.

Who should attend:

Application Developers, Database Administrators

Prerequisites:

This is an advanced course, and we recommend 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 architecture 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:

MySQL and Percona Server 5.1 and newer

Upcoming Sessions:

Subscribe to upcoming training events: RSS feed

]]> ]]>