MySQL 5.7 OCP考试大纲

     目录

1 Installing MySQL

2 Configuring MySQL

3 User Management

4 Maintaining a Stable System

5 Backup Strategies

6 MySQL Architecture

7 Monitoring MySQL

8 MySQL Security

9 Optimizing Query Performance

10 Configuring a Replication Topology

---

       MySQL DBA的认证截至当前（2019.8.10）已推出5.7版本的OCP，可点击此处跳转到Oracle education进行查看，网页截图如下。

       MySQL 5.7 OCP的考试代号是1Z0-888，120分钟的考试时间需做完75选择题，考题形式为单选和多选，正确率达到58%可通过考试。考试费目前为人民币1077元。如果了解甲骨文认证，一定知道考试内容是纯英文的。

       值得一提的是目前MySQL认证不要求有培训经历，相关的训练课程标注了“可选”，见下图，也就是说可以花费一千出头的费用直接参加考试，相对比其他的Oracle认证，这个价格确实是比较便宜。

 

       目前网络上5.7 OCP相关的资料还比较少，在备考上相对Oracle OCP难度稍高，更考验个人的基本功，下面我将考试介绍中大纲部分的内容粘贴如下，共涉及10个主题。

1 Installing MySQL

• Install MySQL
• Identify installed Files and Directories
• Understand Initial Configuration
• Start and Stop MySQL

2 Configuring MySQL

• Understand Server Options, Variables, and the Command Line
• Define Option Files
• Use System Variables

3 User Management

• Identify MySQL Privilege System
• Create and Modify User Accounts
• Configure Passwords and Account Expiration
• Understand Authentication Plug-Ins
• Grant Permissions
• Reset a Forgotten Root Password

4 Maintaining a Stable System

• Define Stability
• Use Capacity Planning
• Troubleshoot
• Identify the Causes of Server Slowdowns
• Describe InnoDB Recovery

5 Backup Strategies

• Understand Backups
• Create a Backup Strategy
• Use MySQL Backup Tools
• Define Raw Backup Methods
• Explain Techniques that Use the Binary Log

6 MySQL Architecture

• Understand How MySQL Processes Requests
• Explain How MySQL Stores Data
• Use Tablespaces
• Identify Redo and Undo Logs
• Define How MySQL Uses Memory

7 Monitoring MySQL

• Monitor MySQL with Log Files
• Monitor MySQL with Status Variables
• Monitor MySQL with Performance Schema

8 MySQL Security

• Identify Security Risks
• Understand Network security
• Use Password Security
• Explain Operating System Security
• Protect Against SQL Injections

9 Optimizing Query Performance

• Identify Slow Queries
• Understand the EXPLAIN statement
• Work with Indexes
• Use Index Statistics

10 Configuring a Replication Topology

• Replicate Conflicts
• Explain Replication
• Configure Replication
• Use MySQL Utilities
• Identify Replication Threads
• Monitor Replication
• Troubleshoot Replication

       为了方便阅读，我使用了Google浏览器的翻译功能将翻译后的中文页面截图如下，机器翻译仅供参考。

 

       在目前考试资料比较少的情况下，从以上10个主题中出75道考题，对于专职的MySQL DBA来讲也是有一定难度的，关键是纯英文考试。

       证书有没有必要考仍然得一分为二的看，根据自身情况，银子够并、精力够就趁早拿下，某些机会的出现不会看技术具体有多好，毕竟靠纯技术流走在技能金字塔顶端的人还是占少数的。

相关链接

       https://education.oracle.com/mysql-57-database-administrator/pexam_1Z0-888

 

 

Tank

2019.8.10