DatabaseAdministratorforDatabaseManagement는 DBA와 기타 데이터베이스 전문가가 MySQL클라우드 서비스를 사용할 때
조직 투자를 극대화하고 MySQL클라우드 서비스의 이점을 극대화하는 방법을 알려 줍니다.
MySQLServer를 구성하고, 복제 및 보안을 설정하고, 데이터베이스 백업을 수행하고,
쿼리 성능을 최적화하고, 고가용성을 보장하는 방법을 학습합니다.

○ Define and implement a backup strategy
○ Perform physical and logical backups of your data
○ Describe MySQL replication and its role in high availability and scalability
○ Configure simple and complex replication topologies
○ Administer a replication topology
○ Install the MySQL server and client programs
○ Upgrade MySQL on a running server
○ Describe MySQL architecture
○ Explain how MySQL processes, stores, and transmits data
○ Configure MySQL server and client programs
○ Use server logs and other tools to monitor database activity
○ Create and manage users
○ Protect your data from common security risks
○ Identify and optimize poorly-performing queries
○ Troubleshoot server slowdowns and other common problems
○ Gain an understanding of MySQL Cloud

Database Administrators / Database Developers / Technical Consultant

□ Course Topics

 

○ Introduction to MySQL

 

  - MySQL overview

  - MySQL Enterprise Edition

  - MySQL on the Web

  - MySQL in the Cloud

  - The MySQL community

 

○ Installing MySQL

  - Installing MySQL

  - Installed Files and Directories

  - Initial Configuration

  - Starting and Stopping MySQL

  - Upgrading MySQL

 

○ MySQL Architecture

  - Architectural Overview

  - How MySQL Transmits Data

  - How MySQL Processes Requests

  - How MySQL Stores Data

  - Tablespaces

  - Redo and Undo Logs

  - How MySQL Uses Memory

  - Plug-in Interface

 

○ Configuring MySQL

  - Server Options, Variables, and the Command Line

  - Option Files

  - System Variables

  - Launching Multiple Servers on the Same Host

 

○ Monitoring MySQL

  - Monitoring MySQL with Log Files

  - Monitoring MySQL with Status Variables

  - Monitoring MySQL with Performance Schema

  - MySQL Enterprise Audit

  - MySQL Enterprise Monitor

  - Monitoring User Activity

 

○ User Management

  - MySQL Privilege System 

  - Creating and Modifying User Accounts

  - Configuring Passwords and Account Expiration

  - Authentication Plug-Ins

  - Granting Permissions

  - Grant Tables

  - Resetting a Forgotten Root Password

 

○ MySQL Security

  - Security Risks

  - Network Security

  - Secure Connections

  - Password Security

  - Operating System Security

  - Protecting Against SQL Injections

  - MySQL Enterprise Firewall

 

○ Maintaining a Stable System

  - Stability

  - Why Databases Fail

  - Capacity Planning

  - Troubleshooting

  - Identifying the Causes of Server Slowdowns

  - InnoDB Recovery

 

○ Optimizing Query Performance

  - Identifying Slow Queries

  - The EXPLAIN statement

  - Working with Indexes

  - Index Statistics

 

○ Backup Strategies

  - Understanding Backups

  - Backup Techniques

  - Creating a Backup Strategy

 

○ Performing Backups

  - MySQL Backup Tools

  - Raw Backup Methods

  - Techniques that Use the Binary Log

 

○ Configuring a Replication Topology

  - Overview of Replication

  - Replication Conflicts

  - When to Use Replication

  - Configuring Replication

 

○ Administering a Replication Topology

  - Failover

  - MySQL Utilities

  - Replication Threads

  - Monitoring Replication

  - Troubleshooting Replication

 

○ Group Replication

  - Overview

  - Single-Primary and Multi-Primary Modes

  - Configuring Group Replication

  - Monitoring Group Replication

 

○ Conclusion

  - Course Overview

  - MySQL Curriculum

  - Course Evaluation

  - Thank You!

  - Q&A Session