Course Details
Course duration: 5 days; Instructor-led
Audience
- Cloud Administrators
- Database Administrators
- Database Designers
- Web Administrators
Prerequisites
Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands.
Methodology
This course is highly interactive and uses diverse teaching methods (lectures, self-assessments, group discussions, activities, and videos) to accommodate different learning styles This training will also leverage on participant’s personal life and work experiences.
Course Objectives
- 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 and roles
- Protect your data from common security risks
- Troubleshoot server slowdowns and other common problems
- Identify and optimize poorly performing queries
- 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
- Configure and administer InnoDB Cluster
Outlines
Module 12: Configuring a Replication Topology
Accordion Content