 | 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. |
