Performance and System Administration (On-Demand)

View class schedule

Learning Objectives

This course is designed to improve the knowledge of Magento specific performance tuning of the UNIX systems hosting Magento. Learning objectives include:

  • Establish backup procedure
  • Propose optimal software & hardware
  • Install & tune PHP accelerator
  • Benchmark req/sec
  • Balance loads
  • Isolate performance bottlenecks
  • Adjust Magento caches
  • Adjust MySQL settings
  • Devise database server monitoring plan
  • Devise a plan for further system performance optimization
  • Understand the internals of how configuration works
  • Quickly diagnose data and full-page caching issues
  • Manage Magento index tables
  • Understand how import routines work
  • Work with the database, including managing backups and pruning stale data
  • Work with SOLR


Familiarity with working in a LAMP stack environment.

Course Description

This course provides an introduction to Magento performance tuning and best practices for configuring Magento in single and multi-server environments, MySQL tuning and PHP performance. Students will also have the opportunity to explore Open Source tools for benchmarking their Magento installation and for fine tuning a database server. Additionally, this course provides the framework for working with several core features in Magento from a system administrator’s perspective. Course is based on Magento Enterprise Edition v1.14

Course Outline

1. Overview
2. Infrastructure
  • Webserver
  • PHP
  • Load balancing
  • Configuration
  • Cache
    • Datacache
    • Full page cache
  • Cron jobs
  • Setting up SOLR
  • Monitoring
3. Database
  • Database configuration
  • Database server optimization
  • Mysql version notes
  • Import/export/dataflow
  • Indexing
4. Production Readiness
  • Marketing Functionality
    • Customer Segmentation
    • Promotions
  • Checkout
  • Testing and tooling
    • Tools overview: ab, siege, jmeter, tsung
    • Testing site performance (introduction)
    • Managing audit logs
  • Security
    • Infrastructure
    • Server
    • Application

Target Audience

System Administrators, Dev OPs, Developers that want to learn System Administration.