An intensive 10-hour course delivered over 5-days for MySQL application developers seeking to build scalable high-performance applications. The sessions are 2-hours of live virtual lecture per day followed by remote lab exercises. The workshop covers:
- How to be systematic about instrumentation, and how to measure performance of an application running in production.
- Identifying successful patterns behind MySQL Applications, and what design decisions don't fit MySQL very well.
- Learning when architectural changes make the most sense, including using replication for splitting reads/writes, caching, message queuing systems and database sharding.
- Optimizing MySQL schema and indexes so that efficient queries can be written.
- Learning by case study how to solve some common application performance problems like paginating results and finding users near you.
- Understanding when to leverage newer MySQL features such as stored procedures, triggers and events.
Who should attend:
Application Developers, Database Administrators
You will learn:
- MySQL query optimization
- MySQL sharding use cases
- Read/write splitting
- Optimal architectures for MySQL
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.
Attendees will need to be able to access the virtual lecture via their computer's browser, and use a SSH session to access the remote labs.
Applies to MySQL Versions:
MySQL and Percona Server 5.1 and newer
No comments:
Post a Comment