MySQL: Administration, Transactions, Optimization, Scaling, Backup, and Recovery
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
As an organization grows, so will its database requirements. In this course, you'll explore the core administrative tasks of managing and maintaining your MySQL databases as they grow and as performance demands increase. The course also covers the transactions in MySQL, storage engines and server optimization, and scaling and high availability. You'll also learn about partitioning, replication, import and export, and backup and recovery.
Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL
Prerequisites
None
Expected Duration (hours)
3.6
Lesson Objectives MySQL: Administration, Transactions, Optimization, Scaling, Backup, and Recovery
start the course
describe the concepts of autonomous, consistent, isolated, and durable (ACID) transactions
define and use explicit transactions in MySQL statements
recognize how transactions can be isolated from each other for greater stability
recognize how locks prevent update conflicts and what happens when deadlocks occur
resolve your database when transactions are interrupted or incomplete
identify which storage engine best supports the desired performance features
identify appropriate optimization strategies for InnoDB usage
identify the optimal hardware configuration for the servers running MySQL
configure OS settings to optimize MySQL performance
configure MySQL values for optimal performance
describe and use transactions and optimize the server using different methods
describe the concept of partitioning large objects into smaller ones for greater performance
recognize how tables are partitioned
configure a partitioned table
recognize the concept and use of replicated databases
identify the different types of replication and their appropriate uses
configure replication between MySQL servers
use the database export feature to move a copy of a database to another server or instance
use the import database feature to implement a received copy of a database
create separate configurations of MySQL on a single server to support different database configurations
identify the importance of protecting your databases
identify the appropriate backup types
describe various options for when and how often to backup your databases
recognize your options for recovering databases from backup
perform a full database backup
perform a database recovery
recognize the various types of disasters that can occur and the appropriate mitigation strategies
implement scaling, clustering, failover, partitioning, replication, importing and exporting, and perform backup and recovery tasks
Course Number: df_mysq_a07_it_enus
Expertise Level
Beginner