Percona Server dla MySQL Training Course


14 hours (usually 2 days including breaks)


Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.

  • Cloud ready
    Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes
  • SaaS deployable
    Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies
  • Vertical scalability and server consolidation
    Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware
  • Query, object and user level instrumentation
    Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host
  • Enterprise ready
    Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition

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

Leave a Reply

Your email address will not be published. Required fields are marked *