MySQL Master - de Avanzado a Experto

Unlock Advanced MySQL Expertise: Deep Dive into Performance & Reliability

This comprehensive course will elevate your MySQL skills to a whole new level. We go far beyond the basics, providing in-depth knowledge of MySQL's internal workings and how its components interact.

Here's what you'll master:

• MySQL Engine Architecture: Understand the internal structure of MySQL components and their relationships.
• Replication Mastery: Learn both basic and advanced replication techniques for robust data mirroring.
• Disaster Recovery Strategies: Develop practical disaster recovery techniques, specifically tailored for production systems.
• Performance Optimization: Deeply analyze slow queries using the powerful tools and consumers available in InnoDB's Performance Schema.
• MySQL Binlog Expertise: Explore the satellite tools provided by MySQL, with a focus on MySQL Binlog for comprehensive data management.

Key Topics Covered:

• SLA, SLO, and SLIR: Understand service level agreements, objectives, and indicators.
• Availability & Recovery: Explore concepts like RPO (Recovery Point Objective), RPI (Recovery Point Interval), and PIT (Point in Time Recovery).
• Logical Architecture: Gain a thorough understanding of MySQL's logical architecture.
• Connection Management & Security: Learn best practices for managing and securing MySQL connections.
• Data Files: Explore the structure and management of MySQL data files.
• InnoDB Architecture: Delve into the intricacies of the InnoDB storage engine.
• Transactions: A complete exploration of transactions, including:
  • Isolation Levels
  • Deadlocks
  • Transaction Logging
  • AutoCommit
  • MVCC (Multi-Version Concurrency Control)
  • Concurrency Control
  • Advanced Parameterization
  • Session Variables & Temporary States
  • Performance Schema Configuration Tables
• Performance Schema Tools: Utilize instruments, consumers, actors, and objects for detailed performance monitoring.
• Mutex System: Understand the internal workings of the MySQL mutex system.
• Core Tables: Master the main tables (Current, History, History Long) for performance analysis.
• Explain Plans: Effectively use EXPLAIN and EXPLAIN ANALYZE for query optimization.
• Real-time Replication: Implement real-time replication step-by-step using two virtual machines with Ubuntu.
• Professional Backups & Restores: Learn professional backup and restore techniques (Full, Differential, and Incremental) using MySQLDump and MySQLBinlog.
• Ready-to-Use Scripts: Access all backup and restore scripts for easy download.

Invest in your MySQL skills – you won't find a course with this level of detail and comprehensive coverage anywhere else!