Certified MySQL DB Administrator

MySQL Architecture

• Client/Server basics and communication protocols
• The SQL parser and storage engine tiers
• Disk space and memory requirements
• Installation

Data Definition

• Databases and tables
• Data types
• Constraints, indexes and views
• Data types for character columns

Data Manipulation

• Search, add, remove and update data
• Grouping and aggregate functions
• Expressions and joining

MySQL Service

• MySQL distributions
• Start and stop MySQL server and runtime configuration
• Log and status files
• Security-related configuration
• INFORMATION_SCHEMA

Client Programs

• mysql, mysqladmin, mysqlimport and mysqldump

Locking

• Locking overview
• Explicit table and advisory locking

Storage Engines

• MySQL storage engines
• MyISAM, merge, innodb, memory, federated, cluster storage and other storage engines

Integrity and Repair

• Table maintenance
• Repairing tables and auto-repair

Backup and Recovery

• Binary and textual backups
• Log and status files
• Replication, data recovery and mysql cluster

Security

• User account management and client access control
• File system, operating system, log files, network and federated table security
• Using stored routines and triggers

Optimization

• Optimizing queries by explain, show warnings and index caching
• Normalization and storage engine specific optimization for schema optimization
• Server optimization by tuning memory parameters, using the query cache and stored routines

Error Handling

• Error Log and Slow Query Log
• Hardware, disk and network issues

Scaling

• Multiple Servers
• Replication