Course Code: msqlperc
Duration: 21 hours
Prerequisites:

There are no specific requirements needed to attend this course.

Overview:

This course is a succession of 1/ introducing concepts and 2/ hands on labs, so there are many labs.

Course Outline:

Percona Server

  1. Features
  • Server Feature comparison
  • Changes in Percona server 5.7
  1. Installation
  • Installing Percona server form repositories
  • Uninstalling Percona server
  • Running the server
  • Installing Percona server form source
  • Running Percona in a docker container
    • Environment variables
  • Upgrading Percona serve
  1. Scalability& performance
  • Buffer Pool scalability
  • InnoDB I/O scalability
  • Asynchronous I/O requests
  • Query cache
  • NUMA support
  • Thread pool
  • I/O bound highly concurrent workloads
  • Prefix index queries optimization
  1. Configuration
  • Storage engine memory
  • Binlog files
  • MYSQLDUMP
  • Per query variable statement
  • MYSQLBINLOG
  • Slow query log rotation
  • CS engine mode
  • Proxy control
  • Dictionaries for compressed columns
  • Stop word lists
  • Enforce storage engines
  1. Management
  • Corrupted tables
  • Idle transactions
  • Users & authentication
  • Options modifiers
  • Fast index creation
  • Backup logs
  • Log audits
  • Consistent snapshots
  • Grants
  1. Statistics& reports
  • User statistics
  • Slow query log
  • innoDB status
  • Show storage engines
  • Process list
  • Schema tables
  • Thread based profiling
  • Scalability metrics
  • Response time
  • Page fragmentation
  1. TokuDB
  • Requirements & Installation
  • Characteristics & limitations
    • Insertion and indexes
    • Secondary indexes
    • Hot add, delete, expand, rename
    • ACID recovery
    • Files & directory structure
    • Background analyze table
    • Status variables
    • Performance schema
  1. MyRocks
  • Installation
  • Characteristics & limitations

Percona Monitoring

  • Monitoring Architecture
  • Installation & deployment
  • Using the management platform
  • Advanced features

Percona XtraBackup

  • How it works
  • Prerequisites & Installation
  • Configuration
  • Backup Scenarios
  • Advanced features (throttling, encryption)

Percona XtraDBCluster

  • Features and limitations
  • Installation
  • Configuring nodes
  • Deploying the cluster(first node, adding nodes)
  • Replication
  • High availability features
  • Multi master replication
  • Security
  • Administration
    • Snapshot transfer
    • SST configuration
    • Restarting nodes
    • Failovers configuration
    • Monitoring
    • Threading model
  • Gcache & record-set caches
  • Performance
  • Galeria arbitrator
  • Load balancing with HAProxy

Percona Tooling

This part of the training is first about an overview of the available tools and secondly the exploration of some of them according to the attendees needs and requirements.