Percona's Kenny Gryp leads a recent MySQL workshop

Percona’s Kenny Gryp leads a recent MySQL workshop

Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops.

  • Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9
    • This MySQL workshop will cover:
      • Apply architecture scaling strategies that make the most sense, including caching, message queuing, database sharding, and replication.
      • Optimize MySQL schema and indexes to support efficient queries.
      • Instrument applications to measure performance.
      • Use successful patterns behind MySQL applications, and avoid design decisions that don’t fit MySQL very well.
      • Solve some common application performance problems like paginating results and full-text search.
      • Understand when to leverage MySQL features such as stored procedures, triggers and events.

     

  • Operating and Troubleshooting for MySQL on Wednesday & Thursday, April 10 & 11
    • This MySQL workshop will cover:
      • Understand MySQL versions and forks—including which versions and editions you should run.
      • Understand how various system components could be a bottleneck for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux.
      • Investigate database trends via the counters exposed in MySQL’s SHOW GLOBAL STATUS.
      • Backup & restore MySQL and InnoDB data, and describe the advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup).
      • Setup and administer MySQL replication.
      • Monitor MySQL servers in production.
      • Discuss security issues with MySQL.
      • Solve via case-study some real-life problems that Percona consultants faced in MySQL.
      • Understand the basic operation of InnoDB—including how data is stored on disk and in memory.
      • Understand what InnoDB does internally when data is written, and how features like the transaction log files and undo space work.
      • See how key features of InnoDB work, including clustered indexes, insert buffer, adaptive hash and double write buffer.
      • Learn to read diagnostic information from InnoDB and make informed decisions while changing configuration.
      • Discover how Percona Server with XtraDB can provide better diagnostics and performance

If you wish to speak to our Sales team about either of these MySQL Workshops, please contact us.