MySQL Training for Developers from Percona

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