MySQL 5.6 Database Administrator
MySQL 5.6 Database Administrator
Exam Material
You need to register for free or login to access certification guide and references:
- Mysql 5.6 Reference Manual.
Exam Info
MySQL Architecture
- Use MySQL client programs to interface with the MySQL Server interactively and in batch
- Describe how MySQL uses disk and memory resources
- List and describe key characteristics of standard MySQL storage engines including InnoDB, NDB, MyISAM, MEMORY, FEDERATED
MySQL Security
- Describe appropriate steps to secure a MySQL deployment at the operating system, filesystem and network levels.
- Create and maintain user accounts with appropriate privileges and configuration.
- Deploy and configure MySQL Enterprise Audit
Optimizing MySQL Performance
- Demonstrate ability to diagnose and optimize poorly-performing queries.
- Tune MySQL Server configuration for best performance.
- Apply best practices in optimizing schema objects
- Demonstrate understanding of locking concepts as applied to MySQL Server and storage engines.
- Create and utilize table PARTITIONING
High Availability Techniques for MySQL
- Describe, configure, deploy and troubleshoot MySQL replication
- Describe and contrast characteristics of common MySQL high availability solutions (MySQL Cluster, DRBD, Windows Failover Clustering, Solaris Cluster, OVM Template for MySQL Enterprise)
MySQL Server Installation, Configuration and Maintenance
- Select, deploy, start and stop MySQL using appropriate binary packages for Windows and Linux platforms
- Configure MySQL Server deployments using options files, command-line options and server variables.
- Identify, configure, locate and describe appropriate use cases for MySQL the error, binary, general query and slow query log.
Diagnostic Data and Metadata Sources in MySQL
- Configure and leverage PERFORMANCE_SCHEMA tables to identify and diagnose performance problems.
- Obtain MySQL metadata from INFORMATION_SCHEMA tables
Backups and Recovery in MySQL
- Create and restore logical backups using mysqldump
- Create and restore binary backups
- Use backups for data recovery
Exam Skills
Certification Exam: MySQL 5.6 Database Administrator
| Exam Type | Certification |
|---|---|
| Exam Code | 1Z0-883 |
| Duration | 2 hours, 30 minutes |
| Number Of Question | 100 |
| Success Score | 60% |
| Price | 200$ |
Evaluation Exam: MySQL 5.6 Database Administrator
| Exam Type | Evaluation |
|---|---|
| Exam Code | 1Z0-883-eval |
| Duration | 1 hour |
| Number Of Question | 40 |
| Success Score | 60% |
| Price | 50$ |