MySQL 8.0 for Database Administrators

Asseco Academy » Training » MySQL 8.0 for Database Administrators

Training OR_MYSQL8_DBA_Z

MySQL 8.0 for Database Administrators

IT Solutions MySQL Oracle

Accreditation

Training description

MySQL 8.0 for Database Administrators

Course Description

The MySQL 8.0 for Database Administrators course is a comprehensive program for database administrators and IT professionals who want to fully utilize MySQL in their organizations. Participants will learn how to configure and manage MySQL Server, secure databases, implement high availability strategies, and manage backup and recovery processes.

During the course, attendees will explore best practices for user management, system configuration, and replication. Additionally, they will learn how to use fundamental diagnostic tools to monitor the stability and integrity of MySQL Server.

Benefits

After completing this course, participants will be able to:

Effectively configure and manage MySQL Server, adapting its settings to meet application and infrastructure requirements.
Implement advanced security mechanisms, controlling data access and minimizing the risk of unauthorized access.
Develop and optimize replication strategies, including asynchronous, semi-synchronous, and group replication, ensuring high availability and database scalability.
Manage backups and data recovery, minimizing the risk of data loss and ensuring business continuity.
Monitor key server performance indicators, diagnose errors, and respond to potential configuration issues.
Utilize tools such as system logs and essential MySQL mechanisms to analyze server operations and identify common administrative issues.

Target Audience

Database Administrators (DBA)
System Administrators
DevOps Specialists
Technical Support Engineers

Prerequisites

Basic knowledge of operating systems (Linux/Windows)
General understanding of databases and SQL (MySQL experience is not required)

Scope

Introduction to MySQL
- MySQL Powers the Web
- MySQL Market Share: DB-Engines 2019
- MySQL Enterprise Edition
- Oracle Premier Support for MySQL
- MySQL and Oracle Integration
- MySQL Websites
- Community Resources
- Oracle University: MySQL Training
- MySQL Certification
Installing and Upgrading MySQL
- Installation Sequence
- Installing MySQL from Downloaded Packages
- MySQL RPM Installation Files for Linux
- MySQL RPM Installation Process
- MySQL DEB Installation
- Linux Distribution–Specific Repositories
- Installing MySQL by Using a Package Manager
- Adding a Yum Repository
- Configuring Yum Repository Versions
- Adding an APT Repository
- Configuring Repository Versions
- Manually Configuring the APT Repositories
- Installing MySQL on Windows
- Installing on Windows: MySQL Installer
- Installing on Windows: Selecting Products and Features
- Installing on Windows: Product Configuration
- Installing MySQL as a Windows Service
- Installing MySQL from Source
- Installing MySQL from Binary Archive
- Deploying MySQL Server with Docker
- Linux MySQL Server Installation Directories
- Windows MySQL Server Installation Directory
- MySQL Programs
- mysqld: MySQL Server Process
- Installation Programs
- Utility Programs
- mysql_config_editor
- .mylogin.cnf Format
- Login Paths
- Command-Line Client Programs
- Launching Command-Line Client Programs
- Configuring Mandatory Access Control
- SELinux Example
- AppArmor: Example
- Changing the root Password
- Using mysqladmin to Change the root Password
- Starting and Stopping MySQL
- Stopping MySQL with mysqladmin
- MySQL Service Files
- Starting and Stopping MySQL on Windows
- Starting and Stopping MySQL on Windows: MySQL Notifier
- Upgrading MySQL
- Reading Release Notes
- MySQL Shell Upgrade Checker Utility
- Using In-Place Upgrade Method
- Using Logical Upgrade Method
- mysql_upgrade
Understanding MySQL Architecture
- Architecture
- Client/Server Connectivity
- MySQL Server Process
- Connection Layer
- Connection Protocols
- Local and Remote Connection Protocol: TCP/IP
- Local Connection Protocol in Linux: Socket
- MySQL and localhost
- Local Connection Protocols in Windows: Shared Memory and Named Pipes
- SSL by Default
- Connection Threads
- SQL Layer
- SQL Layer Components
- SQL Statement Processing
- Storage Layer
- Storage Engines Provided with MySQL
- InnoDB Storage Engine
- MyISAM Storage Engine
- MEMORY Storage Engine
- ARCHIVE Storage Engine
- NDBCluster Storage Engine
- BLACKHOLE Storage Engine
- Storage Engines Feature Summary
- How MySQL Uses Disk Space
- What Is a Data Dictionary?
- Transactional Data Dictionary in MySQL 8
- Serialization of the Data Dictionary
- Dictionary Object Cache
- InnoDB Tablespaces
- Redo Logs
- Undo Logs
- Undo Tablespaces
- Temporary Table Undo Log
- How MySQL Uses Memory
- Global Memory
- Session Memory
- Log Files and Buffers
- InnoDB Buffer Pool
- Configuring the Buffer Pool
- MySQL Plugin Interface
- MySQL Component Interface

Configuring MySQL
- MySQL Configuration Options
- Displaying Configured Server Options
- Using Command-Line Options
- Reasons to Use Option Files
- Option File Locations
- Option Files That Each Program Reads
- Standard Option Files
- Option File Groups
- Writing Option Files
- Option Precedence in Option Files
- Loading or Ignoring Option Files from the Command Line
- Displaying Options from Option Files
- Server System Variables
- Dynamic System Variables
- Changing Variable Values
- Persisting Global Variables
- Viewing Variables with Performance Schema
- Launching Multiple Servers on the Same Host
Monitoring MySQL
- Monitoring MySQL with Log Files
- Error Log
- Binary Log
- General Query Log
- Slow Query Log
- Filtering Slow Query Log Events
- Viewing the Slow Query Log with mysqldumpslow
- Log File Rotation
- Flushing Logs
- Status Variables
- Monitoring Status with mysqladmin
- Performance Schema
- Performance Schema Table Groups
- Configuring Performance Schema
- Performance Schema Setup Tables
- MySQL Enterprise Audit
- Installing MySQL Enterprise Audit
- Audit Log File Configuration
- Audit Log Filtering
- Audit Log File Format
- MySQL Enterprise Monitor
- Installing MySQL Enterprise Monitor
- SHOW PROCESSLIST
- Performance Schema Threads Table
- Limiting User Activity
Managing MySQL Users
- Authentication and Authorization
- Viewing User Account Settings
- Pluggable Authentication
- Creating a User Account
- Roles
- Manipulating User Accounts and Roles
- Setting the Account Password
- Dual Password Support
- Expiring Passwords Manually
- Configuring Password Expiration
- Changing Expired Passwords
- Granting Administrative Privileges
- Granting Roles to Users
- Displaying GRANT Privileges
- Revoking Account Privileges
- Activating Roles at Server Level
- Activating Roles at User Level
- Grant Tables
Securing MySQL
- Security Risks
- Preventing Network Security Risks
- Secure Connections
- Server Security Defaults
- Disabling SSL on MySQL Server
- Setting Client Options for Secure Connections
- Preventing MySQL Password Security Risks
- Password Validation Component
- Locking an Account
- Pluggable Authentication
- Preventing SQL Injection Attacks
- MySQL Enterprise Firewall
- Enabling Firewall Protection
- Monitoring the Firewall
Maintaining a Stable System
- Measuring What You Manage
- Establishing a Baseline
- Application Profiling
- Capacity Planning
- Identifying the Causes of Server Slowdowns
- Investigating Slowdowns
- How MySQL Locks Rows
- Identifying Lock Contention
- InnoDB Table Locks
- InnoDB Row Locks
- Monitoring Data Locks with Performance Schema
- InnoDB Recovery

Optimizing Query Performance
- Identifying Slow Queries
- Choosing What to Optimize
- Using EXPLAIN to See Optimizer’s Choice of Index
- EXPLAIN and Complex Queries
- EXPLAIN FORMAT: JSON Example
- EXPLAIN ANALYZE
- Index Types
- Creating Indexes to Improve Query Performance
- Maintaining InnoDB Index Statistics
- Using ANALYZE TABLE
- Histograms
- MySQL Query Analyzer
Choosing a Backup Strategy
- Reasons to Back Up
- Backup Types
- Hot Backups
- Cold Backups
- Warm Backups
- Backup Techniques
- Logical Backups
- Physical Backups
- Snapshot-Based Backups
- Replication-Based Backups
- Binary Log Backups
- Comparing Backup Methods
- Deciding a Backup Strategy
Performing Backups
- Backup Tools: Overview
- MySQL Enterprise Backup
- Full Backups
- Incremental Backups
- Differential Backups
- mysqldump and mysqlpump
- Ensuring Data Consistency with mysqldump
- Physical InnoDB Backups
- Using Transportable Tablespaces for Backup
- Replication as an Aid to Backup
- Processing Binary Log Contents
- Point-in-Time Recovery
Configuring a Replication Topology
- MySQL Replication
- Replication Masters and Slaves
- Complex Topologies
- Replication Conflicts
- Replication Use Cases
- Replication for High Availability
- Configuring Replication
- Global Transaction Identifiers (GTIDs)
- Replication Filtering Rules
- Binary Log Formats
- Asynchronous Replication
- Semisynchronous Replication
- Multi-Source Replication
- MySQL Clone Plugin
Administering a Replication Topology
- Failover with Log Coordinates
- Failover with GTIDs
- Replication Threads
- Monitoring Replication
- SHOW SLAVE STATUS
- Replication Slave I/O Thread States
- Monitoring Multi-Source Replication
- Troubleshooting MySQL Replication
Achieving High Availability with MySQL InnoDB Cluster
- What Is MySQL InnoDB Cluster?
- MySQL Group Replication Plugin
- Single-Primary Mode
- Multi-Primary Mode
- Conflict Resolution
- Group Replication: Requirements and Limitations
- MySQL Shell (mysqlsh)
- Using MySQL Shell to Execute a Script
- MySQL Router (mysqlrouter)
- Deploying Sandbox Instances and Creating the Cluster
- Production Deployment
- Distributed Recovery
- Connecting Clients to the Cluster
- Managing Sandbox Instances
- Checking the Status of a Cluster
- Restoring Quorum Loss
- Recovering the Cluster from a Major Outage

Training schedule

Remote

… if you value the opportunity to learn with a trainer and other participants, from anywhere without having to commute.

Stationary

… if you want to learn while sitting in the same room with the trainer and other participants.

Online

… if you want to learn from materials available via the interenet anywhere at any time

Filters:

Date guarantee

location:

Training: OR_MYSQL8_DBA_Z

MySQL 8.0 for Database Administrators

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

location:

Training: OR_MYSQL8_DBA_Z

MySQL 8.0 for Database Administrators

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

form:

Training: OR_MYSQL8_DBA_Z

MySQL 8.0 for Database Administrators

Currently, there is no trainings in the selected form.

Szukasz szkolenia w innym terminie?

Co nowego?

Newest
Uncategorized

Dołącz do Membership

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Jak ugryźć innowacyjność

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Nowoczesne metody supportu – testowy wpis

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Chcesz z nami porozmawiać?

Zadzwoń do nas: tel. 801 30 30 30