MySQL Administration and Performance Tuning

Description:

Naya College provides extensive overview about the world’s most popular open source database – MySQL RDBMS. The course will cover the fundamental concepts of MySQL as well as advanced features such as Performance Tuning, High Availability, Replication, Scaling and much more.

The students will acquire a skill set and tools to run, manage, tune and perform basic tasks such as backup and recovery to advanced elements such as identifying and dealing with bottlenecks. This course combines a strong and up to date theory knowledge over MySQL RDBMS as well as practical demonstrations and examples from real-world use cases.

Get a lecture on:

5 Tools Every MySql DBA Should Know

  • Understand MySQL Architecture
  • Understand The Use Of Storage Engines
  • Configure Network And Security Elements
  • Learn MySQL Management Concepts Regrading Users / System Variables
  • Learn Configuration File Best Practices (my.cnf)
  • Learn MySQL Administration Using MySQL Built-In Tools
  • Understand MySQL Locks Mechanism
  • Perform Backup And Restore Operations
  • Creating and Managing Master-Slave Replication Environment
  • Improve And Optimize database performance And Enhance Reliability
  • Perform Installations And Upgrades Tasks Step By Step
  • Practicing In MySQL Development Using SQL Code, Procedures, Built-In and User Defined Functions And Events (Optional)

DevOps, Database Administrators, System Administrators, Web Application Developers, Architecture Designers

  • Linux Basic Knowledge
  • ANSI SQL Basic Knowledge
  • RDBMS Basic Understanding

General Overview and Basic Elements

History and Introduction

  • Overview
  • Real Examples and Use Cases of Customers Using MySQL Database

Architecture Overview

  • Sever
  • Client

Storage Engines

  • Engines Types
  • Engines Characteristics
  • InnoDB and MyISAM Extensive Overview

Networking and Security

  • Operating System
  • File System Security
  • Network Security

MySQL with Linux Overview

  • Basic Commands

Installation (Linux Only)

  • Linux RPM Installation
  • Linux Binary Installation
  • Source Installation

Users Management

  • User Account Management
  • User Privileges
  • Administrative Privileges
  • Database Access Privileges

Database Management / Tables Maintenance / Backup & Recovery / High Availability Solutions

Database Management

  • System Variables
  • Altering Database Variables at Session / Global Level

Configuration File Best Practices (my.cnf)

  • InnoDB Memory Buffers
  • Log file size and log buffer
  • Memory Consumption
  • Memory Limitations

Using MySQL Built-In Tools

  • MySQLAdmin
  • MySQLBinlog
  • MySQLDump
  • MySQLImport

Table Maintenance

  • Analyze Table
  • Check Table
  • Checksum Table
  • Optimize Table
  • Repair Table
  • Moving Tables between Schemas / Servers / Tablespaces

Locking in MySQL

  • MySQL Locking Overview
  • Table Level Locking
  • Row Level Locking
  • Internal / External Locking
  • Dead Locks

Backup and Recovery

  • MySQL Backup
  • MySQL Backup Types
  • MySQL Backup and Recovery Tools
  • Load data infile & select into outfile

Basic Replication

  • Replication Architecture
  • Replication Basics
  • Replication Types
  • Master-Slave Replication Setup
  • Master-Slave Replication Filters

MariaDB and Galera Replication Architecture

  • Master-Master Replication

Upgrading

  • Pre Upgrade Steps
  • Upgrade Steps and Check List
  • Post Upgrade Commands

Database Monitoring / Performance Tuning Overview and Workshop

Monitoring Database Activity

  • Working with Information Schema and Performance Schema

Various Logs in MySQL

  • Error Log
  • Query Log
  • Slow Query Log
  • Binary Log
  • Relay Log
  • General Query Log

Identifying Slow Queries

  • Slow-Query-Log
  • ProcessList
  • InnoDB_TRX
  • Using Show Warnings

Optimizing Queries

  • Explaining the EXPLAIN
  • Server Variables Check

Development

  • Basic MySQL Queries
  • Join / Sub-Query / Union
  • Build-In Functions
  • User Defined Functions
  • Procedures
פבל זגרפבל הינו יועץ מוביל בחברת נאיה טכנולוגיות ומרצה בנאיה קולג'. פבל מוביל התחומים כגון: MongoDB, Linux, MySQL. פבל מעורב בפרויקטים רבים ומגוונים בתחומים אלה ועל בסיס הניסיון והרקע מעביר קורסים מקצועיים עם חומרי לימוד נלווים ומרצה בכנסים טכנולוגיים בנושאים כגון: Big Data, NoSQL, MySQL ואחרים.
  • על פי דרישה מועד פתיחה
  • 9:00-16:30daysימים ושעות
  • 32academic hours שעות אקדמיות
  • מתקדםcourse levelרמת הקורס
  • עברית/Englishlanguageשפת הדרכה
  • לבדיקת התאמה לקורס
  • [current_url]

    השאירו פרטים ונחזור אליכם בהקדם!