Advanced application developers, administrators.

This course builds on the knowledge as described for the "Using MySQL" course. Experience with MySQL required. :

At completion of this course, you should be able to:

• Identify the various components of a MySQL Server and their function.
• Identify and navigate elements in the physical structure of a MySQL Server on disk and in memory.
• Understand the differences between MySQL RPM, binary and source distributions.
• Perform a custom installation on Windows or any standard Unix.
• Assess the various upgrade considerations and perform an upgrade.
• Know where to find/create configuration files and understand their structure.
• Set up appropriate logging and interpret log output.
• Understand the concepts of MySQL security, managing user privileges on different levels.
• Adequately and properly secure a default MySQL installation.
• List and describe the different (categories of) storage engines, their specific characteristics, choosing the appropriate type.
• Administer and maintain MyISAM and InnoDB tables on a live server.
• Create and restore backups, recovery of MyISAM and InnoDB tables.
• Understand transactions and concurrency control.
• Tune server settings for different storage engines and environments.
• Install and control replication and multiple servers.
• Describe how the MySQL server optimizes and processes queries, including index usage.
• Analyse query efficiency utilizing different tools and techniques.
• Compare different design decisions and work out the optimial solution.
• Optimize all relevant aspects of the server environment, prioritizing appropriately.

Products covered MySQL 4.0 and 4.1, Command-line and graphical clients/tools.

Applies to MySQL Version: 4.0, 4.1