Course Outline

Percona Server Installation

  • Choosing version
  • Downloading installer (YUM, RPM)
  • Installation on Linux machine

Percona Server Files and Scripts

  • Percona/MySQL Programs
  • Percona Server
  • Percona Client
  • GUI Tools

Percona Server Configuration

  • The Server SQL Mode
  • Server System Variables
  • Dynamic System Variables
  • Server Status Variables
  • Shutdown Process

Percona Security Issues

  • Securing Percona Server Against Attacks
  • Security-Related Options
  • Security Issues with LOAD DATA LOCAL

Percona Access Privilege System

  • Percona Privilege System Overview
  • Privileges Provided by Percona
  • Connecting to the Percona Server - Stages
  • Access Control, Stage 1: Connection Verification
  • Access Control, Stage 2: Request Verification
  • Access Denied Errors

Percona User Account Management

  • Users and Passwords
  • Creating New Users
  • Deleting User Accounts
  • Limiting User Resources
  • Changing Passwords

Percona Database Maintenance

  • Backup and Recovery – dump vs. XtraBackup
  • Point-in-Time Recovery
  • Maintenance and Crash Recovery
  • Getting Table Information

Percona Log Files

Error Log

  • General Query Log
  • Update Log
  • Binary Log
  • Slow Query Log
  • Log File Maintenance and Rotation

Percona  Query Cache

  • The Concept of Query Cache
  • Testing Query Cache with SELECT
  • Configuring Query Cache
  • Checking Query Cache Status and Maintenance

Installing and starting Percona XtraDB Cluster

  14 Hours


Related Courses

Administrating Percona Server for MongoDB

  7 hours

MySQL Database Administration

  14 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours

MariaDB Database Administration

  14 hours


  14 hours

MariaDB Galera Cluster Administration

  21 hours

MySQL Administration

  28 hours

Advanced MariaDB for High Availability and Performance

  28 hours

MySQL / Galera

  21 hours


  14 hours

Python in Data Science

  35 hours

MySQL Developer

  21 hours