Training

Our LAMP training team includes proven experts on all of the aspects of the LAMP stack. These experts have in-depth knowledge amd experience of the operations and fine-tuning associated with the various components of LAMP.

Backed by the resounding success of these experts in the field of corporate training and development, our LAMP training team offers and conducts quality training classes linked to optimization, design, audits, migration, clustering, higher uptime control, version upgrades and much more.

We offer a consolidated LAMP training workshop consisting of ten modules over fourteen days, where each day consists of eight hours of training. These wide coverage modules include a lot of subject material, in order to give the trainee a wide and thorough perspective of each topic.

These modules in brief are

1. Linux tweaking, optimization and management for MySQL (1-3 days)
   • Introduction, configuration, installation and administration of Linux
   • Patching, hot fixes, package management and cron jobs
   • Basic concepts behind 32 bits versus 64 bits (MySQL binary, H/W, OS)
   • File systems and storage media
   • Monitoring and optimization of CPU / IO
   • RAID configuration and optimization
   • Concurrency of threads, processes and connections
   • Detection of issues, debugging and resolutions related to the OS and network
     
     
2. Scalability & high availability of LAMP (2-3 days)
   • Horizontal Vs Vertical scaling & Scale out Vs Scale in
   • MySQL cluster technology, Disk clustering & DRBD
   • Sharding & application partitioning
   • MySQL replication, chaining & slave farming
   • Fail over & standby databases
   • Load balancing, MySQL proxy & VIP switchover
     
     
3. The load testing and benchmarking of LAMP components (1- day)
   • This includes hardware sizing, and planning for capacity as well as growth
     
     
4. MySQL performance tuning (2-3 days)
   • Use query optimization for performance optimization
   • Improve server performance using command line scripts and monitoring tools, and by comparing multiple environment options
   • Optimizing schemas (databases) by using multiple techniques
   • Lock detection and resolution
     
     
5. Backup and disaster recovery for MySQL (1 day)
   • Point-in-time MySQL database recovery
   • Multiple SQL tools for backup and restore operations
   • Hands-on exercises to perform full, incremental and partial recovery in multiple scenarios
     
     
6. Basics for MySQL developers and DBAs (2-3 days)
   • Introduction to MySQL and the basics of 32 bits vs 64 bits
   • Install and upgrade MySQL for common OSs like Linux
   • Perform start and shutdown operations
   • Configure server options
   • Usage of the administrator GUI to manage the MySQL server
   • Evaluation of data types and character sets for performance issues
   • Study of data locking concepts and different levels of locking
   • Usage of security protocols to maintain the integrity of the MySQL installation
   • Comparative study of available storage engines
   • Perform administrative tasks using triggers and stored procedures
   • Manage and understand views, MySQL Connectors and partitioning
     
     
7. Apache configuration, management and optimization for MySQL (1 day)
   • Basics of 32 bits vs 64 bits with an introduction to Apache, PHP and HTTP
   • Installation and configuration options from the command line and GUI
   • Apache modules and optimization for the MySQL server
   • Tutorial on Apache web server configuration
   • Content management on Apache server – caching and proxying with Apache
     
     
8. PHP code optimization, best practices and framework for MySQL (1 day)
   • Web-based application design overview
   • Installation, configuration & logging with PHP 5.3
   • The advanced features of PHP 5, and building applications with a precise flow
   • Include files to ease code maintenance
   • MySQL-based design schemas
   • Write composite queries and extract data from multiple tables using joins and subqueries
   • Authenticate users securely against a database
   • Handle errors gracefully and efficiently in PHP applications
   • Usage of the GROUP BY clause and the 5 aggregate functions
   • Efficient usage of indexing to manage large amounts of data
   • Building a complete application including authentication and session management
   • Writing applications with scalable components to meet increased demand
   • Learn how the Apache web server, MySQL and PHP work together to deliver dynamic web content
     
     
9. Discussions on the recent trends in open source technology, especially those linked to the LAMP stack and how these affect MySQL (1 day)
   
   
10. Case studies and analysis, followed by a presentation, post-mortem and Q&A session by the course participants (1 day)